topic Fetching Previous Quarter Values with respect to Multiple-dimensions in App Development https://community.qlik.com/t5/App-Development/Fetching-Previous-Quarter-Values-with-respect-to-Multiple/m-p/1800761#M64892 <P>Hi All,</P><P>I have requirement where I need to fetch the previous Quarter values and calculate it with the current Quarter values aggregating more than a couple of dimensions and present in a table.</P><P>Please do help me with a solution here. Thanks all in advance. I have also attached a sample excel file with this post</P><P>Please find the below table:</P><P>Where ever the Measure says QoQ, I need to take the Current Quarter Actual value and divide it by the Previous Quarter Actual Value with respective to the same Product, KPI and Market and need to display as the table below.&nbsp;</P><TABLE><TBODY><TR><TD>ReportQuarter</TD><TD>Market</TD><TD>KPI</TD><TD>Product</TD><TD>Measure</TD><TD>Value</TD><TD>comments</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>11.1</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">2.47</FONT></TD><TD>QoQ = current quarter (Q2-2021) actual value / previous quarter (Q1-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>60.6</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>15.33</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">1.381081</FONT></TD><TD>QoQ = current quarter (Q3-2021) actual value / previous quarter (Q2-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>56</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Q1-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>14.1</TD><TD>&nbsp;</TD></TR><TR><TD>Q1-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">4.5</FONT></TD><TD>QoQ = current quarter (Q1-2021) actual value / previous quarter (Q4-2020) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q1-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>16</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>11.1</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">0.787234</FONT></TD><TD>QoQ = current quarter (Q2-2021) actual value / previous quarter (Q1-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q2-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>60.6</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>15.33</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">1.381081</FONT></TD><TD>QoQ = current quarter (Q3-2021) actual value / previous quarter (Q2-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q3-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>56</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Q1-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Actual</TD><TD>23</TD><TD>&nbsp;</TD></TR><TR><TD>Q1-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>QoQ</TD><TD><FONT size="5">4.5</FONT></TD><TD>QoQ = current quarter (Q1-2021) actual value / previous quarter (Q4-2020) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q1-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Delta Vs DB</TD><TD>16</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Actual</TD><TD>30</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>QoQ</TD><TD><FONT size="5">1.304348</FONT></TD><TD>QoQ = current quarter (Q2-2021) actual value / previous quarter (Q1-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Delta Vs DB</TD><TD>60.6</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Actual</TD><TD>20</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>QoQ</TD><TD><FONT size="5">0.666667</FONT></TD><TD>QoQ = current quarter (Q3-2021) actual value / previous quarter (Q2-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Delta Vs DB</TD><TD>56</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 20 Apr 2021 06:09:23 GMT KishorePandurangan 2021-04-20T06:09:23Z Fetching Previous Quarter Values with respect to Multiple-dimensions https://community.qlik.com/t5/App-Development/Fetching-Previous-Quarter-Values-with-respect-to-Multiple/m-p/1800761#M64892 <P>Hi All,</P><P>I have requirement where I need to fetch the previous Quarter values and calculate it with the current Quarter values aggregating more than a couple of dimensions and present in a table.</P><P>Please do help me with a solution here. Thanks all in advance. I have also attached a sample excel file with this post</P><P>Please find the below table:</P><P>Where ever the Measure says QoQ, I need to take the Current Quarter Actual value and divide it by the Previous Quarter Actual Value with respective to the same Product, KPI and Market and need to display as the table below.&nbsp;</P><TABLE><TBODY><TR><TD>ReportQuarter</TD><TD>Market</TD><TD>KPI</TD><TD>Product</TD><TD>Measure</TD><TD>Value</TD><TD>comments</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>11.1</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">2.47</FONT></TD><TD>QoQ = current quarter (Q2-2021) actual value / previous quarter (Q1-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>60.6</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>15.33</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">1.381081</FONT></TD><TD>QoQ = current quarter (Q3-2021) actual value / previous quarter (Q2-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>56</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Q1-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>14.1</TD><TD>&nbsp;</TD></TR><TR><TD>Q1-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">4.5</FONT></TD><TD>QoQ = current quarter (Q1-2021) actual value / previous quarter (Q4-2020) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q1-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>16</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>11.1</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">0.787234</FONT></TD><TD>QoQ = current quarter (Q2-2021) actual value / previous quarter (Q1-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q2-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>60.6</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Actual</TD><TD>15.33</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>QoQ</TD><TD><FONT size="5">1.381081</FONT></TD><TD>QoQ = current quarter (Q3-2021) actual value / previous quarter (Q2-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q3-2021</TD><TD>South Africa</TD><TD>A</TD><TD>Cookie</TD><TD>Delta Vs DB</TD><TD>56</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Q1-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Actual</TD><TD>23</TD><TD>&nbsp;</TD></TR><TR><TD>Q1-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>QoQ</TD><TD><FONT size="5">4.5</FONT></TD><TD>QoQ = current quarter (Q1-2021) actual value / previous quarter (Q4-2020) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q1-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Delta Vs DB</TD><TD>16</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Actual</TD><TD>30</TD><TD>&nbsp;</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>QoQ</TD><TD><FONT size="5">1.304348</FONT></TD><TD>QoQ = current quarter (Q2-2021) actual value / previous quarter (Q1-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q2-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Delta Vs DB</TD><TD>60.6</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Actual</TD><TD>20</TD><TD>&nbsp;</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>QoQ</TD><TD><FONT size="5">0.666667</FONT></TD><TD>QoQ = current quarter (Q3-2021) actual value / previous quarter (Q2-2021) actual value respective to the Product, KPI and Market</TD></TR><TR><TD>Q3-2021</TD><TD>Germany</TD><TD>A</TD><TD>Ice Cream</TD><TD>Delta Vs DB</TD><TD>56</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 20 Apr 2021 06:09:23 GMT https://community.qlik.com/t5/App-Development/Fetching-Previous-Quarter-Values-with-respect-to-Multiple/m-p/1800761#M64892 KishorePandurangan 2021-04-20T06:09:23Z