Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
BlakeGri2093
Contributor III
Contributor III

How to calculate growth percentage for any 2 months based on user selection

Hi Qlik Experts

I  want to create the sales KPI for growth based on the user selection so they want choose any 2 month and the KPI will return the growth with that selection. For example, if they choose August and January the KPI will return the sales growth between the august and January. Can you guy help me with that problem?

1 Reply
sunny_talwar

Is this based on a selection of date or Month? May be something like this

Sum({<Month = {"$(=MaxString(Month))"}>} Measure)/Sum({<Month = {"$(=MinString(Month))"}>}Measure) - 1