Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with an dimension "name" column and an expression column. My expression:
count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CB-={'TAR','EST'},CAD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID)
It shows something like:
Name | expression |
XXXX | 3 |
AAAAA | 3 |
BBBB | 2 |
DDDD | 2 |
SSSS | 2 |
JJJJJJJ | 2 |
QQQQQQQQQ | 1 |
WWWWW | 1 |
EEEEEE | 1 |
RRRRRRR | 1 |
I need to show a graphic of the names only with expression higher then 2. How can I do that?
Try this in calculated dimension:
=if(aggr(count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CB-={'TAR','EST'},CAD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID),Name)>2,Name,null())
Under settings on selected dimension,
Check(Tick) suppress when value is null.
Im using the dracula graph extension below, so this "supress when value is null" is not an option.
https://community.qlik.com/t5/QlikView-Extensions/Visualization-of-Graph-Data/td-p/471132