Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vivek12
Contributor II
Contributor II

Need to add growth rate between start date & end date of a filter selection

Hey 

I have a dashboard which has month selections in the filters. I need to show in a KPI what has been the growth rate of a parameter between the start date & the end date?
Can any body please help me on this? 

My expression is not working

(sum({[FB.Period]<{$(=Min([FB.Period]))}} Impressions)
/
sum({[FB.Period]>{$(=Min([FB.Period]))}} Impressions))
-1

Labels (4)
4 Replies
Or
MVP
MVP

You can't use greater than / less than with this part of the set analysis. Have a look at e.g.

https://community.qlik.com/t5/QlikView-App-Dev/Set-Analysis-for-Less-than-Equal/td-p/366270

 

Vivek12
Contributor II
Contributor II
Author

Thanks a lot for the revert

Can you please write the expression for me?
I got the issue with the usage of signs but seems like there's some issue with the min. function as well. 

Also do i need to use the getfieldselection as well to capture the minimun from the selcted values from the date filter?

Vivek12
Contributor II
Contributor II
Author

You can ignore the growth formula and just help with providing the sum before the starting date of the date range in the filter selection

Vivek12
Contributor II
Contributor II
Author

You can ignore the growth formula and just help with providing the sum before the starting date of the date range in the filter selection