Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Community,
Is there a way to create static KPI's that are not influenced by any filters?
For example i have a table with the columns "revenue" and "date".
I want to have one KPI which sums the revenue of only the past week and one next to it which shows the revenue of the current week, even if it's for example just wednesday.
I want both KPI's so i can have a comparison and can monitor the performance of my business.
If possible they should not be affected by any filters that are selected.
See the following about Using alternate states for comparative analysis
Create Alternate states for your KPIs. Charts in a specific state (Alternate State) ignore selections made on charts in different states
KPIs will only be affected by filters that are associated with the identical Alternate state.
Look into Set identifies in Qlik. Set identifiers
Use global identifier {1} in set analysis
example : sum( {1} revenue)
Tip: Also look into Alternative States for more control
Hi,
if you want to exclude fields you can use like below
Sum({<year = >}Field)
or
=sum( {1} {<year=,month=>}field)
I understand what the {1} does now. How do i automate the calculation of the revenue of the past week?
How do i code Week-1? If i write "=sum( {1} {<year=,week=>}field)" i would have to update the calculation every week.
See the following about Using alternate states for comparative analysis
Create Alternate states for your KPIs. Charts in a specific state (Alternate State) ignore selections made on charts in different states
KPIs will only be affected by filters that are associated with the identical Alternate state.