Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
milindnikumbh
New Contributor III

Dynamic variance analysis / How to hide the column in pivot table

Dear Experts ,

How to hide the non - selected the month in pivot table . My excel data and qvw file is attached for your reference.  I have generated the MonthID column in fiscal year . Can we create dynamic year-month instead of hard codded month-yr in expression and also calculate variance.

Please suggest the approach to achieve this .

Thanks.

Regards,

Milind.

1 Solution

Accepted Solutions

Re: Dynamic variance analysis / How to hide the column in pivot table

Something like this to add %Change

image.png

View solution in original post

6 Replies

Re: Dynamic variance analysis / How to hide the column in pivot table

May be using a pivot table where periodid is a pivoted dimension?

image.png

Re: Dynamic variance analysis / How to hide the column in pivot table

Something like this to add %Change

image.png

View solution in original post

milindnikumbh
New Contributor III

Re: Dynamic variance analysis / How to hide the column in pivot table

Dear Sunny ,

Thanks a ton for your updates. I will check and update you.

 

Thanks & Regards,

Milind.

Support
Support

Re: Dynamic variance analysis / How to hide the column in pivot table

Milind, just wanted to be sure you circled back on this one to mark Sunny's posts as the solution using the Accept as Solution button on those posts if they did work out for you.  

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
milindnikumbh
New Contributor III

Re: Dynamic variance analysis / How to hide the column in pivot table

Dear Sunny ,

Thanks a ton. Its really helpful for me .  I resume today after vacation. 

Thanks

Milind.

Highlighted
milindnikumbh
New Contributor III

Re: Dynamic variance analysis / How to hide the column in pivot table

Yes. Its helpful and resolve my issue.