Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a KPI in my dashboard in Qlik Sense that I would like that it changes as I select different filters (the half year with 2018 or quarter or month but all in 2018)
the KPI refers to growth across time and looks like :
((sum({<[Year]={"2018"}>}Order)
/
sum({<[Year]={"2017"}>}Order)))-1
unfortunately when I select a filter - the kpi just goes blank
Could anyone help?
many thanks
Kind Regards
Sofia
Have you data in 2018??
Share sample data and Expected output
You probably need to override your actual selections - without that, the date you select will conflict with one term (or both terms) of the expression. Something like:
=(sum({<[Year]={"2018"}, Date, MonthYear>} Order) / sum({<[Year]={"2017"}, Date, MonthYear>} Order)) - 1
(assuming you are making selections in two fields (Date and MonthYear) - adjust to fit your data)
Hi Jonathan,
many thanks for your tip.
Indeed after your solution, when i filter month or quarter doesn't go blank the KPI field, and keep the same figure for the year.
Nevertheless i would like that the KPI would reflect the growth for the sub period selected.
For example: when i select quarter 1 on the filters - the kpi show the growth for Q1
many thanks and take care
Sofia
Hi Enrique, yes i have some data for 2018
thanks
Sofia
I suggest then that you upload a small sample containing some representative data, and then provide some example of what you might select and what you would expect (a date ranges, some dates, some months, etc) to get for each of these selections.