topic Re: Ignore second dimension in QlikView

Ignore second dimension

yura_ratu — Wed, 03 Sep 2014 09:46:17 GMT

Hi all

I have a chart with 2 dimensions - Level and Item, and I want to ignore one of them in expression and visually

I use this formula:

count(total <Level> distinct UserID)

and expect to see bar chart with one dimension - Level, but instead of this I got this

how to ignore second dimension completely?

Also I can't set a condition for this dimension. I provided only denominator of final expression. Numerator shouldn't ignore second dimension

Re: Ignore second dimension

MK_QSL — Wed, 03 Sep 2014 09:49:50 GMT

Total Qualifier is used something like Grouping ..... Here Count of UserID by Level...

Still unclear about your requirements from your question itself. Can you provide some brief information along with possible dummy data or apps and expected result?

Re: Ignore second dimension

yura_ratu — Wed, 03 Sep 2014 10:10:57 GMT

Hi Manish. Sure

The result should be - just count of UserID for each Level, without breaking them up by Item dimension. Nevertheless i can't delete the Item dimension from a chart.

Re: Ignore second dimension

MK_QSL — Wed, 03 Sep 2014 10:35:11 GMT

I am not getting actually... Where you want to display the COUNT(Distinct UserID) without Level break up...?

If you want to display the total, just go to Expression tab and Change Expression as

COUNT(DISTINCT UserID)

and select Values on Data Points

Go to style tab and select Stacked..