Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
subhankarb9
New Contributor

Get previous month or qtr value based on respective month or qtr selection

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:

Qlik Dashboard.JPG

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.

Tags (2)
1 Reply
Community Manager
Community Manager

Re: Get previous month or qtr value based on respective month or qtr selection

@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. 

Sue Macaluso