topic Re: condition on graphics in QlikView

condition on graphics

rafael5958 — Sat, 16 Nov 2024 02:03:35 GMT

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?

Re: condition on graphics

Arthur_Fong — Mon, 04 Nov 2019 00:52:03 GMT

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.

Re: condition on graphics

rafael5958 — Mon, 04 Nov 2019 13:53:45 GMT

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