Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulsingh12
Contributor III
Contributor III

Pivot Table Issue

Hi I have a pivot table with 2 columns

ID1 Id2 and I do a count of it in expression.

ID2 comes after ID1 so  what I want is that if I rollup ID2 upto ID1 then it should count only ID1 occurrence and if I expand it till ID2 then should count only ID2 value.

E.g

They have respective count as

ID1-50

ID2-40

Case1:

            Count

ID1      50

Case2:

                         Count

ID1       ID2          40

Regards,

1 Reply
balar025
Creator III
Creator III

You have to use Dimensionality()or Aggr function based on your dimension.

Still if you have confusion, Please provide your sample application

Regards,

Ravi