topic Re: Set Analysis - Pivot Table in QlikView

Set Analysis - Pivot Table

Wed, 02 Apr 2014 22:36:55 GMT

Hi Everyone,

I'm creating a pivot table with two dimensions X and Y and then I'm doing counts of Z. But what I really want to be doing is percentages with respect to X. So my expression would be Count(X=x and Y=y, Z) / Count(X=x, Z). I've tried to do: Count(Z) / (Count({$<Y=>} Z), but that just returns 100% for everything.

Any help would be appreciated.

Thanks,

Rebecca

Re: Set Analysis - Pivot Table

swuehl — Wed, 02 Apr 2014 22:43:35 GMT

Try the TOTAL qualifier ,something like

=count(z) / count(total<x> z)

Re: Set Analysis - Pivot Table

Wed, 02 Apr 2014 22:53:08 GMT

Thank you so much!