topic Re: Pivot table - 2 same dimension in QlikView

Pivot table - 2 same dimension

Anonymous — Mon, 02 Jan 2017 10:57:57 GMT

Hello,

I have a table Year Month, Bucket and RefNOid.

I am trying to build a pivot table with 2 dimensions in it. One with Bucket for current month and second dimension with last month.

I am not able to get the desired output as seen in the attached excel sheet.

Need your help to define the dimensions/ expression to get this output.

lironbaram — Mon, 02 Jan 2017 11:15:57 GMT

in your case i think it's better to calculate the previous bucket in the load script

attach is an example

Anonymous — Mon, 02 Jan 2017 11:24:54 GMT

Any alternative on how to handle at dimension and expression level at front end ?

mkelemen — Mon, 02 Jan 2017 14:11:57 GMT

Hi,

it is possible - you have to use p() function in set analysis.

You can find it implemented in the qvw.

BR,

Matus