Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Set Analysis Calculation Measure

Hi all lovely people,

I need to get some figure.

I managed to get the Count of ID for the latest YearPeriod.

Now I would like to get the growth of the ID compare to previous YearPeriod.

I guess the measure should be using the [ Count ({<YearPeriod={"$(=max(YearPeriod))"}, OrderType={'New'}>}ID) ] to minus out the previous YearPeriod.

For e.g. now the new ID is 3, the growth of new ID should be -1. (previous YearPeriod is 20181202)

Please find attached my qvf and excel file.

LayoutLayoutNew ID MeasureNew ID MeasureExisting ID measureExisting ID measurePart of my scriptingPart of my scripting

 

2 Replies
Highlighted
Specialist III
Specialist III

Re: Set Analysis Calculation Measure

i think you need to check this variable

vPrevYearPeriod

 

this you looking for same month last year or same year previous month

 

 

Channa
Highlighted
Creator
Creator

Re: Set Analysis Calculation Measure

I'm looking for Previous YearPeriod.

For e.g.  20190101's previous YearPeriod is 20181202.

20181202 previous YearPeriod is 20181201.