https://community.qlik.com/t5/QlikView/set-analysis-for-rolling-six-months/m-p/1647883#M447632 <P>Hi Experts,</P><P>i have the following data with Month names and the corresponding %. i have to build a chart/table with Month name as dimension and two expressions 1. Current Month % as it is 2. Previous six months average.</P><P>For example, if the Month name is September-2019, then current month % is 86.69% and Previous six months average should be 85.03%. can you please help me with the expression? i cannot do this in the data.</P><P>Input:</P><TABLE><TBODY><TR><TD>Month Year</TD><TD>Current Month %</TD></TR><TR><TD>01-2019</TD><TD>84.81%</TD></TR><TR><TD>02-2019</TD><TD>83.94%</TD></TR><TR><TD>03-2019</TD><TD>84.43%</TD></TR><TR><TD>04-2019</TD><TD>84.51%</TD></TR><TR><TD>05-2019</TD><TD>86.25%</TD></TR><TR><TD>06-2019</TD><TD>85.86%</TD></TR><TR><TD>07-2019</TD><TD>85.19%</TD></TR><TR><TD>08-2019</TD><TD>85.07%</TD></TR><TR><TD>09-2019</TD><TD>86.69%</TD></TR><TR><TD>10-2019</TD><TD>85.50%</TD></TR><TR><TD>11-2019</TD><TD>87.09%</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 19:39:17 GMT prrajendran 2024-11-16T19:39:17Z https://community.qlik.com/t5/QlikView/set-analysis-for-rolling-six-months/m-p/1647883#M447632 <P>Hi Experts,</P><P>i have the following data with Month names and the corresponding %. i have to build a chart/table with Month name as dimension and two expressions 1. Current Month % as it is 2. Previous six months average.</P><P>For example, if the Month name is September-2019, then current month % is 86.69% and Previous six months average should be 85.03%. can you please help me with the expression? i cannot do this in the data.</P><P>Input:</P><TABLE><TBODY><TR><TD>Month Year</TD><TD>Current Month %</TD></TR><TR><TD>01-2019</TD><TD>84.81%</TD></TR><TR><TD>02-2019</TD><TD>83.94%</TD></TR><TR><TD>03-2019</TD><TD>84.43%</TD></TR><TR><TD>04-2019</TD><TD>84.51%</TD></TR><TR><TD>05-2019</TD><TD>86.25%</TD></TR><TR><TD>06-2019</TD><TD>85.86%</TD></TR><TR><TD>07-2019</TD><TD>85.19%</TD></TR><TR><TD>08-2019</TD><TD>85.07%</TD></TR><TR><TD>09-2019</TD><TD>86.69%</TD></TR><TR><TD>10-2019</TD><TD>85.50%</TD></TR><TR><TD>11-2019</TD><TD>87.09%</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 19:39:17 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-rolling-six-months/m-p/1647883#M447632 prrajendran 2024-11-16T19:39:17Z https://community.qlik.com/t5/QlikView/set-analysis-for-rolling-six-months/m-p/1647887#M447633 <P>Look at my response here</P><P><A href="https://community.qlik.com/t5/New-to-QlikView/expression-for-rolling-six-months/td-p/1647884" target="_blank">https://community.qlik.com/t5/New-to-QlikView/expression-for-rolling-six-months/td-p/1647884</A></P> Mon, 18 Nov 2019 11:40:40 GMT https://community.qlik.com/t5/QlikView/set-analysis-for-rolling-six-months/m-p/1647887#M447633 sunny_talwar 2019-11-18T11:40:40Z