Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Shashank2006
New Contributor

Scripting or chart logic required

Hi Geniuses,

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

1Q120192019-Q1APJ81002
2Q120192019-Q1APJ74571
3Q120192019-Q1APJ76198
4Q220192019-Q2APJ66504
5Q220192019-Q2APJ73966
6Q220192019-Q2APJ98398

 

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 

 

Thanks,

Shashank

Labels (2)
1 Reply
santhiqlik
New Contributor III

Re: Scripting or chart logic required

Hi,

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

Community Browser