Pivot Table Issue

rahulsingh12 — Fri, 14 Jul 2017 06:45:12 GMT

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,

Re: Pivot Table Issue

balar025 — Fri, 14 Jul 2017 06:54:29 GMT

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

Still if you have confusion, Please provide your sample application

Regards,

Ravi

topic Re: Pivot Table Issue in QlikView

Pivot Table Issue

Re: Pivot Table Issue