Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a problem which needs your attention
I have a excel file in which year, quarter and month and forecast values are coming ,below is a sample
I want a chart in such a way that my dimension will be quater year and it should display the maximum month value so the result set look like below
2019-Q1 --> 76198
2019-Q2 --> 98398
I am attaching the complete excel please help me to create the chart
If you use "quater year "in Dimension then using "max(TOTAL_COMPT_LOCAL_AMT)" will give max amt under each quater year.
Please let me know if I missed to understand complexity in your problem