https://community.qlik.com/t5/App-Development/Scripting-or-chart-logic-required/m-p/1518039#M37037 <P>Hi Geniuses,</P><P>I have a problem which needs your attention&nbsp;</P><P>I have a excel file in which year, quarter and month and forecast values are coming ,below is a sample</P><TABLE><TBODY><TR><TD>1</TD><TD>Q1</TD><TD>2019</TD><TD>2019-Q1</TD><TD>APJ</TD><TD>81002</TD></TR><TR><TD>2</TD><TD>Q1</TD><TD>2019</TD><TD>2019-Q1</TD><TD>APJ</TD><TD>74571</TD></TR><TR><TD>3</TD><TD>Q1</TD><TD>2019</TD><TD>2019-Q1</TD><TD>APJ</TD><TD>76198</TD></TR><TR><TD>4</TD><TD>Q2</TD><TD>2019</TD><TD>2019-Q2</TD><TD>APJ</TD><TD>66504</TD></TR><TR><TD>5</TD><TD>Q2</TD><TD>2019</TD><TD>2019-Q2</TD><TD>APJ</TD><TD>73966</TD></TR><TR><TD>6</TD><TD>Q2</TD><TD>2019</TD><TD>2019-Q2</TD><TD>APJ</TD><TD>98398</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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</P><P>2019-Q1 --&gt; 76198</P><P>2019-Q2 --&gt; 98398</P><P>I am attaching the complete excel please help me to create the chart&nbsp;</P><P>&nbsp;</P><P>Thanks,</P><P>Shashank</P> Sat, 16 Nov 2024 07:05:54 GMT Anonymous 2024-11-16T07:05:54Z https://community.qlik.com/t5/App-Development/Scripting-or-chart-logic-required/m-p/1518039#M37037 <P>Hi Geniuses,</P><P>I have a problem which needs your attention&nbsp;</P><P>I have a excel file in which year, quarter and month and forecast values are coming ,below is a sample</P><TABLE><TBODY><TR><TD>1</TD><TD>Q1</TD><TD>2019</TD><TD>2019-Q1</TD><TD>APJ</TD><TD>81002</TD></TR><TR><TD>2</TD><TD>Q1</TD><TD>2019</TD><TD>2019-Q1</TD><TD>APJ</TD><TD>74571</TD></TR><TR><TD>3</TD><TD>Q1</TD><TD>2019</TD><TD>2019-Q1</TD><TD>APJ</TD><TD>76198</TD></TR><TR><TD>4</TD><TD>Q2</TD><TD>2019</TD><TD>2019-Q2</TD><TD>APJ</TD><TD>66504</TD></TR><TR><TD>5</TD><TD>Q2</TD><TD>2019</TD><TD>2019-Q2</TD><TD>APJ</TD><TD>73966</TD></TR><TR><TD>6</TD><TD>Q2</TD><TD>2019</TD><TD>2019-Q2</TD><TD>APJ</TD><TD>98398</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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</P><P>2019-Q1 --&gt; 76198</P><P>2019-Q2 --&gt; 98398</P><P>I am attaching the complete excel please help me to create the chart&nbsp;</P><P>&nbsp;</P><P>Thanks,</P><P>Shashank</P> Sat, 16 Nov 2024 07:05:54 GMT https://community.qlik.com/t5/App-Development/Scripting-or-chart-logic-required/m-p/1518039#M37037 Anonymous 2024-11-16T07:05:54Z https://community.qlik.com/t5/App-Development/Scripting-or-chart-logic-required/m-p/1518082#M37039 <P>Hi,</P><P>If you use "<SPAN>quater year "in Dimension then using "max(TOTAL_COMPT_LOCAL_AMT)" will give max amt under each quater year.&nbsp;</SPAN></P><P><SPAN>Please let me know if I missed to understand complexity in your problem</SPAN></P> Fri, 07 Dec 2018 15:57:54 GMT https://community.qlik.com/t5/App-Development/Scripting-or-chart-logic-required/m-p/1518082#M37039 santhiqlik 2018-12-07T15:57:54Z