topic Re: Set Analysis Not Working in QlikView

Set Analysis Not Working

Mon, 15 Sep 2014 02:07:54 GMT

Hi,

Please take a look at the attached qvw file. In there I have an expression named: Total #Parts with a set analysis defined in it. The idea is this expression, for each PartName, to display the count for all PartColor values.. So for example for the first row I want the expression to display 6 (2+4) and for the second row it should display 7 (4+3). But instead, it is displaying the same data as #Parts expression. Why is that the set analysis not working as expected here?

Re: Set Analysis Not Working

JonnyPoole — Mon, 15 Sep 2014 02:18:16 GMT

change your 2nd expression to:

=count( total <PartName> Key)

it will give you a subtotal on PartName. 6 on first row, 7 on 2nd.

Re: Set Analysis Not Working

jagan — Mon, 15 Sep 2014 02:39:34 GMT

Hi,

Use TOTAL to ignore the dimension which is simlar to Group by in SQL

=Count( TOTAL <PartName> Key)

Regards,

jagan.