Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sofiabarbosa
Contributor
Contributor

Growth and filters

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

6 Replies
ecolomer
Master II
Master II

Have you data in 2018??

shraddha_g
Partner
Partner

Share sample data and Expected output

jonathandienst

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sofiabarbosa
Contributor
Contributor

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

sofiabarbosa
Contributor
Contributor

Hi Enrique, yes i have some data for 2018

thanks

Sofia

jonathandienst

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein