topic Show YTD , 12RM, Monthly data in bar chart in App Development

topic Show YTD , 12RM, Monthly data in bar chart in App Development https://community.qlik.com/t5/App-Development/Show-YTD-12RM-Monthly-data-in-bar-chart/m-p/1728488#M55544 <P>Hello Everyone,</P><P> </P><P> I have to create a bar chart that shows value of YTD, 12 rolling months and monthly data .</P><P>How can i achieve that. Do i need to use alternate states in qliksense. I am not sure.</P><P>Sample data is:</P><TABLE width="192"><TBODY><TR><TD width="64">Year</TD><TD width="64">Month</TD><TD width="64">Amount</TD></TR><TR><TD>2018</TD><TD>Jan</TD><TD>1000</TD></TR><TR><TD>2018</TD><TD>Feb</TD><TD>2000</TD></TR><TR><TD>2018</TD><TD>Mar</TD><TD>5000</TD></TR><TR><TD>2018</TD><TD>Apr</TD><TD>100</TD></TR><TR><TD>2018</TD><TD>May </TD><TD>200</TD></TR><TR><TD>2018</TD><TD>June</TD><TD>5555</TD></TR><TR><TD>2018</TD><TD>July </TD><TD>789</TD></TR><TR><TD>2018</TD><TD>Aug</TD><TD>789</TD></TR><TR><TD>2018</TD><TD>Sep</TD><TD>598</TD></TR><TR><TD>2018</TD><TD>Oct</TD><TD>432</TD></TR><TR><TD>2018</TD><TD>Nov</TD><TD>1000</TD></TR><TR><TD>2018</TD><TD>Dec</TD><TD>789</TD></TR><TR><TD>2019</TD><TD>Jan</TD><TD>56000</TD></TR><TR><TD>2019</TD><TD>Feb</TD><TD>6888</TD></TR><TR><TD>2019</TD><TD>Mar</TD><TD>98222</TD></TR><TR><TD>2019</TD><TD>Apr</TD><TD>2344</TD></TR><TR><TD>2019</TD><TD>May </TD><TD>982</TD></TR><TR><TD>2019</TD><TD>Jun</TD><TD>765</TD></TR><TR><TD>2019</TD><TD>Jul</TD><TD>951</TD></TR><TR><TD>2019</TD><TD>Aug</TD><TD>287</TD></TR><TR><TD>2019</TD><TD>Sep</TD><TD>999</TD></TR><TR><TD>2019</TD><TD>Oct</TD><TD>876</TD></TR><TR><TD>2019</TD><TD>Nov</TD><TD>129</TD></TR><TR><TD>2019</TD><TD>Dec</TD><TD>1244</TD></TR></TBODY></TABLE><P>Please help .</P><P>Thanks</P> Thu, 16 Jul 2020 14:02:09 GMT Aspiring_Developer 2020-07-16T14:02:09Z Show YTD , 12RM, Monthly data in bar chart https://community.qlik.com/t5/App-Development/Show-YTD-12RM-Monthly-data-in-bar-chart/m-p/1728488#M55544 <P>Hello Everyone,</P><P> </P><P> I have to create a bar chart that shows value of YTD, 12 rolling months and monthly data .</P><P>How can i achieve that. Do i need to use alternate states in qliksense. I am not sure.</P><P>Sample data is:</P><TABLE width="192"><TBODY><TR><TD width="64">Year</TD><TD width="64">Month</TD><TD width="64">Amount</TD></TR><TR><TD>2018</TD><TD>Jan</TD><TD>1000</TD></TR><TR><TD>2018</TD><TD>Feb</TD><TD>2000</TD></TR><TR><TD>2018</TD><TD>Mar</TD><TD>5000</TD></TR><TR><TD>2018</TD><TD>Apr</TD><TD>100</TD></TR><TR><TD>2018</TD><TD>May </TD><TD>200</TD></TR><TR><TD>2018</TD><TD>June</TD><TD>5555</TD></TR><TR><TD>2018</TD><TD>July </TD><TD>789</TD></TR><TR><TD>2018</TD><TD>Aug</TD><TD>789</TD></TR><TR><TD>2018</TD><TD>Sep</TD><TD>598</TD></TR><TR><TD>2018</TD><TD>Oct</TD><TD>432</TD></TR><TR><TD>2018</TD><TD>Nov</TD><TD>1000</TD></TR><TR><TD>2018</TD><TD>Dec</TD><TD>789</TD></TR><TR><TD>2019</TD><TD>Jan</TD><TD>56000</TD></TR><TR><TD>2019</TD><TD>Feb</TD><TD>6888</TD></TR><TR><TD>2019</TD><TD>Mar</TD><TD>98222</TD></TR><TR><TD>2019</TD><TD>Apr</TD><TD>2344</TD></TR><TR><TD>2019</TD><TD>May </TD><TD>982</TD></TR><TR><TD>2019</TD><TD>Jun</TD><TD>765</TD></TR><TR><TD>2019</TD><TD>Jul</TD><TD>951</TD></TR><TR><TD>2019</TD><TD>Aug</TD><TD>287</TD></TR><TR><TD>2019</TD><TD>Sep</TD><TD>999</TD></TR><TR><TD>2019</TD><TD>Oct</TD><TD>876</TD></TR><TR><TD>2019</TD><TD>Nov</TD><TD>129</TD></TR><TR><TD>2019</TD><TD>Dec</TD><TD>1244</TD></TR></TBODY></TABLE><P>Please help .</P><P>Thanks</P> Thu, 16 Jul 2020 14:02:09 GMT https://community.qlik.com/t5/App-Development/Show-YTD-12RM-Monthly-data-in-bar-chart/m-p/1728488#M55544 Aspiring_Developer 2020-07-16T14:02:09Z