KPI based on different filters

[Anonymous]

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).

[jolivares]

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]

Hi Ed,

Check out https://community.qlik.com/docs/DOC-4951

And http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx