Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
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
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