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

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

milindnikumbh — Tue, 27 Aug 2019 14:46:20 GMT

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.

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

sunny_talwar — Tue, 27 Aug 2019 15:29:09 GMT

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

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

sunny_talwar — Tue, 27 Aug 2019 15:46:06 GMT

Something like this to add %Change

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

milindnikumbh — Wed, 28 Aug 2019 03:32:55 GMT

Dear Sunny ,

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

Thanks & Regards,

Milind.

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

Brett_Bleess — Thu, 05 Sep 2019 15:32:25 GMT

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

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

milindnikumbh — Wed, 11 Sep 2019 14:55:00 GMT

Dear Sunny ,

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

Thanks

Milind.

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

milindnikumbh — Wed, 11 Sep 2019 14:55:58 GMT

Yes. Its helpful and resolve my issue.