Select Bar &Line Chart and Pivot Table Measures Using Filter Pane Dynamically

EnigmaticForever — Fri, 02 Apr 2021 08:04:37 GMT

Created something similar in Power BI and Cognos. Got similar requirement in QlikSense now.

Can anyone please let me know if this is possible in QlikSense. Attached screenshot for reference

If user select eg. 2018/19 Financial Year in Filter pane(It’s dynamic selection. User could select any Financial Year)

The sheet should produce a bar chat for 2018/19(Selected Dynamic Year) and Line chart for 2017/18(Selected Year - 1)
Pivot Table should produce data for each Selected Financial Year month(not the previous financial year) along with YTD(Total of selected financial year) and LTD(Total of Selected Year - 1) in the columns and Grand Total in the bottom

Please let me know if this achievable?

Thanks

Eni

Re: Select Bar &Line Chart and Pivot Table Measures Using Filter Pane Dynamically

sri99999 — Wed, 21 Aug 2019 05:02:48 GMT

This is easily possible with your Master Calendar or AsOfCalendar table. Please search blog posts for Master Calendar setup.