Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I need your help in identifying solution on how to get previous month or qtr value based on respective month or qtr selection.
The data set is as below:
Year | Date | Month Name | Month Number | Qtr | Qtr No | ME ID | Data Type | Interaction Channel Type |
2018 | 2018-01-21 10:00:00 | Jan | 1 | Q1 | 1 | 66997 | Interaction Data | Face to Face |
2018 | 2018-02-21 15:00:00 | Feb | 2 | Q1 | 1 | 196116 | Interaction Data | Face to Face |
2018 | 2018-03-26 14:26:00 | Mar | 3 | Q1 | 1 | 103622 | Interaction Data | Face to Face |
2018 | 2018-04-27 14:30:00 | Apr | 4 | Q2 | 2 | 100269 | Interaction Data | Face to Face |
2018 | 2018-05-02 20:19:00 | May | 5 | Q2 | 2 | 34306 | Interaction Data | Face to Face |
2018 | 2018-06-13 14:17:00 | Jun | 6 | Q2 | 2 | 37701 | Interaction Data | Face to Face |
2018 | 2018-07-13 14:19:00 | Jul | 7 | Q3 | 3 | 104661 | Interaction Data | Face to Face |
2018 | 2018-08-13 14:20:00 | Aug | 8 | Q3 | 3 | 167804 | Interaction Data | Face to Face |
2018 | 2018-09-13 14:21:00 | Sep | 9 | Q3 | 3 | 152025 | Interaction Data | Face to Face |
2018 | 2018-10-13 14:22:00 | Oct | 10 | Q4 | 4 | 41596 | Interaction Data | Face to Face |
2018 | 2018-01-21 10:00:00 | Nov | 11 | Q4 | 4 | 66997 | Interaction Data | Face to Face |
2018 | 2018-02-21 15:00:00 | Dec | 12 | Q4 | 4 | 196116 | Interaction Data | Face to Face |
2019 | 2019-03-26 14:26:00 | Jan | 13 | Q1 | 5 | 103622 | Interaction Data | Face to Face |
2019 | 2019-04-27 14:30:00 | Feb | 14 | Q1 | 5 | 100269 | Interaction Data | Face to Face |
2019 | 2019-05-02 20:19:00 | Mar | 15 | Q1 | 5 | 34306 | Interaction Data | Face to Face |
2019 | 2019-06-13 14:17:00 | Apr | 16 | 37701 | Interaction Data | Face to Face | ||
2019 |
2019-07-13 14:19:00 |
May | 17 | 104661 | Interaction Data | Face to Face |
The dashboard is built with below filter option:
In order to calculate Face to Face interaction value, I used below set analysis
=Count({<[Data Type]={'Interaction Data'},[Interaction Channel Type]={'Face to Face'}>} [ME ID])
The data gets represented as per to the selection of Year (2019): Period (Month): Month:( Mar).
Now I want to calculate growth vs previous month or quarter respective to previous month or qtr I select.
For example:- If I select Month: (Feb) I want to see Feb month value and growth vs Jan.
I tried using Month number (Month number-1 ) in set analysis but it is not working. Kindly help me to resolve the issue.
@subhankarb9 Are you using QlikView or Sense? I would like to move this into the product forum. This is typically for general non-product related discussion and it will be visible to more specific experts.