Looking for Total Ignoring Chart Dimension - Qlik Community

Report Inappropriate Content · ‎2014-11-21

I can't believe I can't figure this out.

I am making a simple bar chart, based on dimension 'ORDERSET'

The first expression is Count(DISTINCT VISITGUID)

And so the bar shows exactly what I'm looking for.

For my second Expression, I want the count of DISTINCT VISITGUIDS for ALL THE ORDERSETS (in other words, ignoring the dimension.

So, if there are 5 total Distinct VISITGUIDS, I want 5 to be the value of the expression for each of the ORDERSET dimension.

Why am I having so much trouble with this? Help!

datanibbler · ‎2014-11-21

Hi,

try set_analysis with the TOTAL operator - that should do what you want.

Best regards,

DataNibbler

Report Inappropriate Content · ‎2014-11-21

I appreciate the suggestion DataNihhler.

I played with set analysis, but was getting lost in the weeds.

I ultimately tried this and it seems to work:

=Count(TOTAL {$<OrderSet=>} DISTINCT VISITGUID)

datanibbler · ‎2014-11-21

Well, that would work too. I think it's a bit more than you need - try without the set_expression and without the DISTINCT keyword maybe - but if it works, off you go ...