Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

escarber
New Contributor

KPI based on different filters

I have created an actuals KPI and Pivot Table.  I added a KPI fields.  The user will see by all years.  I select by year (2015).  Then I see my KPI Dashboard and then select company.  I want to see KPI fields Sum by that select year and another sum based on my selected selection (example Company).

2 Replies
jolivares
Valued Contributor

Re: KPI based on different filters

In this case you need to use a set expression:

Sum({<Year={2015}> Sales}     Sales for the Year 2015

Sum({<Year={$(=Max(Year))}> Sales}     Sales for the selected Year

Sum({<Year={$(=Max(Year))}, Company_ID> Sales}     Sales for the selected Year, no matter a selected company


etc...

p_verkooijen
Valued Contributor

Re: KPI based on different filters

Community Browser