topic How to get the values row wise in pivot table in QlikView

How to get the values row wise in pivot table

Tue, 17 Sep 2013 04:41:59 GMT

Hi ,

Can anyone let me know how to get the values row wise in the pivot table. Am attaching xls for your reference.

Please reply if you need any more information.

Thanks and Regards,

Smitha

Re: How to get the values row wise in pivot table

Tue, 17 Sep 2013 04:54:50 GMT

Hi,

You have to write set analysis to getting values for Currentmonth, previous month, before previous month.

Re: How to get the values row wise in pivot table

abeyphilip — Tue, 17 Sep 2013 05:02:15 GMT

Hi Smitha,

You can assign the values for current , previous and month before in the load and then use these variables in expression (probably set analysis). You will have to use one expression each for the 3 diff months,

Regards,

Abey