topic Re: Looking for Total Ignoring Chart Dimension in QlikView

Looking for Total Ignoring Chart Dimension

Fri, 21 Nov 2014 15:37:23 GMT

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!

Re: Looking for Total Ignoring Chart Dimension

datanibbler — Fri, 21 Nov 2014 15:39:19 GMT

Hi,

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

Best regards,

DataNibbler

Re: Looking for Total Ignoring Chart Dimension

Fri, 21 Nov 2014 15:43:40 GMT

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)

Re: Looking for Total Ignoring Chart Dimension

datanibbler — Fri, 21 Nov 2014 15:46:59 GMT

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 ...