topic Get previous month or qtr value based on respective month or qtr selection in App Development https://community.qlik.com/t5/App-Development/Get-previous-month-or-qtr-value-based-on-respective-month-or-qtr/m-p/1590498#M43907 <P>Dear All,</P> <P>I need your help in identifying solution on how to get previous month or qtr value based on respective month or qtr selection.</P> <P>The data set is as below:</P> <TABLE> <TBODY> <TR> <TD>Year</TD> <TD><STRONG>Date</STRONG></TD> <TD><STRONG>Month Name</STRONG></TD> <TD><STRONG>Month Number</STRONG></TD> <TD><STRONG>Qtr</STRONG></TD> <TD><STRONG>Qtr No</STRONG></TD> <TD><STRONG>ME ID</STRONG></TD> <TD><STRONG>Data Type</STRONG></TD> <TD><STRONG>Interaction Channel Type</STRONG></TD> </TR> <TR> <TD>2018</TD> <TD>2018-01-21 10:00:00</TD> <TD>Jan</TD> <TD>1</TD> <TD>Q1</TD> <TD>1</TD> <TD>66997</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-02-21 15:00:00</TD> <TD>Feb</TD> <TD>2</TD> <TD>Q1</TD> <TD>1</TD> <TD>196116</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-03-26 14:26:00</TD> <TD>Mar</TD> <TD>3</TD> <TD>Q1</TD> <TD>1</TD> <TD>103622</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-04-27 14:30:00</TD> <TD>Apr</TD> <TD>4</TD> <TD>Q2</TD> <TD>2</TD> <TD>100269</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-05-02 20:19:00</TD> <TD>May</TD> <TD>5</TD> <TD>Q2</TD> <TD>2</TD> <TD>34306</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-06-13 14:17:00</TD> <TD>Jun</TD> <TD>6</TD> <TD>Q2</TD> <TD>2</TD> <TD>37701</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-07-13 14:19:00</TD> <TD>Jul</TD> <TD>7</TD> <TD>Q3</TD> <TD>3</TD> <TD>104661</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-08-13 14:20:00</TD> <TD>Aug</TD> <TD>8</TD> <TD>Q3</TD> <TD>3</TD> <TD>167804</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-09-13 14:21:00</TD> <TD>Sep</TD> <TD>9</TD> <TD>Q3</TD> <TD>3</TD> <TD>152025</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-10-13 14:22:00</TD> <TD>Oct</TD> <TD>10</TD> <TD>Q4</TD> <TD>4</TD> <TD>41596</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-01-21 10:00:00</TD> <TD>Nov</TD> <TD>11</TD> <TD>Q4</TD> <TD>4</TD> <TD>66997</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-02-21 15:00:00</TD> <TD>Dec</TD> <TD>12</TD> <TD>Q4</TD> <TD>4</TD> <TD>196116</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD>2019-03-26 14:26:00</TD> <TD>Jan</TD> <TD>13</TD> <TD>Q1</TD> <TD>5</TD> <TD>103622</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD>2019-04-27 14:30:00</TD> <TD>Feb</TD> <TD>14</TD> <TD>Q1</TD> <TD>5</TD> <TD>100269</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD>2019-05-02 20:19:00</TD> <TD>Mar</TD> <TD>15</TD> <TD>Q1</TD> <TD>5</TD> <TD>34306</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD>2019-06-13 14:17:00</TD> <TD>Apr</TD> <TD>16</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>37701</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD> <P>2019-07-13 14:19:00</P> </TD> <TD>May</TD> <TD>17</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>104661</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The dashboard is built with below filter option:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik Dashboard.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13548iCDBFD59FD107CB25/image-size/medium?v=v2&amp;px=400" role="button" title="Qlik Dashboard.JPG" alt="Qlik Dashboard.JPG" /></span></P> <P>In order to calculate Face to Face interaction value, I used below set analysis&nbsp;</P> <P><STRONG>=Count({&lt;[Data Type]={'Interaction Data'},[Interaction Channel Type]={'Face to Face'}&gt;} [ME ID])</STRONG></P> <P>The data gets represented as per to the selection of Year (2019): Period (Month): Month:( Mar).</P> <P>Now I want to calculate growth vs previous month or quarter respective to previous month or qtr I select.</P> <P>For example:- If I select Month: (Feb) I want to see Feb month value and growth vs Jan.</P> <P>I tried using Month number&nbsp; (Month number-1 ) in set analysis but it is not working. Kindly help me to resolve the issue.</P> Wed, 26 Jun 2019 15:57:20 GMT subhankarb9 2019-06-26T15:57:20Z Get previous month or qtr value based on respective month or qtr selection https://community.qlik.com/t5/App-Development/Get-previous-month-or-qtr-value-based-on-respective-month-or-qtr/m-p/1590498#M43907 <P>Dear All,</P> <P>I need your help in identifying solution on how to get previous month or qtr value based on respective month or qtr selection.</P> <P>The data set is as below:</P> <TABLE> <TBODY> <TR> <TD>Year</TD> <TD><STRONG>Date</STRONG></TD> <TD><STRONG>Month Name</STRONG></TD> <TD><STRONG>Month Number</STRONG></TD> <TD><STRONG>Qtr</STRONG></TD> <TD><STRONG>Qtr No</STRONG></TD> <TD><STRONG>ME ID</STRONG></TD> <TD><STRONG>Data Type</STRONG></TD> <TD><STRONG>Interaction Channel Type</STRONG></TD> </TR> <TR> <TD>2018</TD> <TD>2018-01-21 10:00:00</TD> <TD>Jan</TD> <TD>1</TD> <TD>Q1</TD> <TD>1</TD> <TD>66997</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-02-21 15:00:00</TD> <TD>Feb</TD> <TD>2</TD> <TD>Q1</TD> <TD>1</TD> <TD>196116</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-03-26 14:26:00</TD> <TD>Mar</TD> <TD>3</TD> <TD>Q1</TD> <TD>1</TD> <TD>103622</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-04-27 14:30:00</TD> <TD>Apr</TD> <TD>4</TD> <TD>Q2</TD> <TD>2</TD> <TD>100269</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-05-02 20:19:00</TD> <TD>May</TD> <TD>5</TD> <TD>Q2</TD> <TD>2</TD> <TD>34306</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-06-13 14:17:00</TD> <TD>Jun</TD> <TD>6</TD> <TD>Q2</TD> <TD>2</TD> <TD>37701</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-07-13 14:19:00</TD> <TD>Jul</TD> <TD>7</TD> <TD>Q3</TD> <TD>3</TD> <TD>104661</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-08-13 14:20:00</TD> <TD>Aug</TD> <TD>8</TD> <TD>Q3</TD> <TD>3</TD> <TD>167804</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-09-13 14:21:00</TD> <TD>Sep</TD> <TD>9</TD> <TD>Q3</TD> <TD>3</TD> <TD>152025</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-10-13 14:22:00</TD> <TD>Oct</TD> <TD>10</TD> <TD>Q4</TD> <TD>4</TD> <TD>41596</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-01-21 10:00:00</TD> <TD>Nov</TD> <TD>11</TD> <TD>Q4</TD> <TD>4</TD> <TD>66997</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2018</TD> <TD>2018-02-21 15:00:00</TD> <TD>Dec</TD> <TD>12</TD> <TD>Q4</TD> <TD>4</TD> <TD>196116</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD>2019-03-26 14:26:00</TD> <TD>Jan</TD> <TD>13</TD> <TD>Q1</TD> <TD>5</TD> <TD>103622</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD>2019-04-27 14:30:00</TD> <TD>Feb</TD> <TD>14</TD> <TD>Q1</TD> <TD>5</TD> <TD>100269</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD>2019-05-02 20:19:00</TD> <TD>Mar</TD> <TD>15</TD> <TD>Q1</TD> <TD>5</TD> <TD>34306</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD>2019-06-13 14:17:00</TD> <TD>Apr</TD> <TD>16</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>37701</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> <TR> <TD>2019</TD> <TD> <P>2019-07-13 14:19:00</P> </TD> <TD>May</TD> <TD>17</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>104661</TD> <TD>Interaction Data</TD> <TD>Face to Face</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The dashboard is built with below filter option:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik Dashboard.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13548iCDBFD59FD107CB25/image-size/medium?v=v2&amp;px=400" role="button" title="Qlik Dashboard.JPG" alt="Qlik Dashboard.JPG" /></span></P> <P>In order to calculate Face to Face interaction value, I used below set analysis&nbsp;</P> <P><STRONG>=Count({&lt;[Data Type]={'Interaction Data'},[Interaction Channel Type]={'Face to Face'}&gt;} [ME ID])</STRONG></P> <P>The data gets represented as per to the selection of Year (2019): Period (Month): Month:( Mar).</P> <P>Now I want to calculate growth vs previous month or quarter respective to previous month or qtr I select.</P> <P>For example:- If I select Month: (Feb) I want to see Feb month value and growth vs Jan.</P> <P>I tried using Month number&nbsp; (Month number-1 ) in set analysis but it is not working. Kindly help me to resolve the issue.</P> Wed, 26 Jun 2019 15:57:20 GMT https://community.qlik.com/t5/App-Development/Get-previous-month-or-qtr-value-based-on-respective-month-or-qtr/m-p/1590498#M43907 subhankarb9 2019-06-26T15:57:20Z Re: Get previous month or qtr value based on respective month or qtr selection https://community.qlik.com/t5/App-Development/Get-previous-month-or-qtr-value-based-on-respective-month-or-qtr/m-p/1591135#M43908 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/75929">@subhankarb9</a>&nbsp; Are you using QlikView or Sense? I would like to move this into the product forum.&nbsp; This is typically for general non-product related discussion and it will be visible to more specific experts.&nbsp;</P> Wed, 12 Jun 2019 15:27:23 GMT https://community.qlik.com/t5/App-Development/Get-previous-month-or-qtr-value-based-on-respective-month-or-qtr/m-p/1591135#M43908 Sue_Macaluso 2019-06-12T15:27:23Z