I’m trying to build a hierarchical view with 8 categorized columns, each one has one field (like level_1 in column 1, level_2 in column 2 …etc). Some of these fields can be empty.
I only want the categories that have a value in the related field to show, but it’s showing me all categories (some are “(Not Categorized)”) even when I click “Don’t show empty categories” in the view design.
What am I missing here?
Subject: can someone please define what is an “empty category”
A category is deemed empty when the user displaying that view cannot see any Documents that are in that category, due to Readers fields on those documents.
It won’t help you with levels of categories.
There’s a couple of things you might try…
If one of your levels is blank, put in your own message. (There HAS to be some value displayed in the column.)
@IF(LEVEL2=“”;";LEVEL2)
Alternatively, you could use one column instead of 8, and build a cascaded category.
Here’s a simple example.
C1 := Level1;
C2 := @If(Level2 = “”; C1 ; C1 + “\”+Level2);
C3 := @If(Level3 = “”; C2 ; C2 + “\”+Level3);
…
C8 := @If(Level8 = “”; C7 ; C7 + “\”+Level8);
C8
The “\” makes notes create a category with more than one level, in a single column of your view.
Subject: RE: can someone please define what is an “empty category”
Thanks a lot.
Subject: can someone please define what is an “empty category”
use @Trim(textarray) to eliminate empty categories.“Don’t show empty categories” as far as I know affects only categories where all documents in that category have readers fields and you do not have access to any of them.
Subject: can someone please define what is an “empty category”
You’ll need to have a single column for your categorisation scheme and compute the output using @Formula, so that you can cope with the empty categories programatically.nwilkins@hmi.co.uk