Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Not Working

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?

1 Solution

Accepted Solutions
JonnyPoole
Former Employee
Former Employee

change your 2nd expression to:

=count( total <PartName>  Key)

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

View solution in original post

2 Replies
JonnyPoole
Former Employee
Former Employee

change your 2nd expression to:

=count( total <PartName>  Key)

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

=Count( TOTAL <PartName> Key)

Regards,

jagan.