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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the values row wise in pivot table


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

2 Replies
Not applicable
Author

Hi,

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

abeyphilip
Creator II
Creator II

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