topic Re: Pivot Chart Expression using RowNo() in QlikView

Pivot Chart Expression using RowNo()

Wed, 25 Nov 2020 16:16:04 GMT

Can some please take a look at my second Pivot Chart and help me understand why I am getting value only for 1 value of the dimension?

Re: Pivot Chart Expression using RowNo()

Anil_Babu_Samineni — Sat, 11 Feb 2017 01:33:37 GMT

This is you are expecting to see?

Re: Pivot Chart Expression using RowNo()

Sat, 11 Feb 2017 14:38:11 GMT

Hi Anil,

No! my expectation is to see value for each row and column intersection. Similar to what I have in Pivot 1

Thanks for your help.

Re: Pivot Chart Expression using RowNo()

rubenmarin — Sat, 11 Feb 2017 15:26:58 GMT

Hi, the $-expansion is done before the table is calculated, so the RowNo() in set analysis won't work as expected, it returns '1' (for all rows), so only sums v1.

Something as this can work but with this sample, I don't know if it's suitable in real data:

pick(RowNo(),

sum(total{<Venue={'v1'}>} Value),

sum(total{<Venue={'v2'}>} Value),

sum(total{<Venue={'v3'}>} Value),

sum(total{<Venue={'v4'}>} Value)

) + pick(ColumnNo(), // or should be '*' or any other operation?

sum(total{<Venue={'v1'}>} Value),

sum(total{<Venue={'v2'}>} Value),

sum(total{<Venue={'v3'}>} Value),

sum(total{<Venue={'v4'}>} Value)

)