Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Long
Contributor
Contributor

Static KPI's for comparisons

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.

1 Solution

Accepted Solutions
duchezbr
Contributor III
Contributor III

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

  1. In Master items>Alternate states>Create new alternate states and label (e.g., KPI_1, KPI_2).
  2. Drag and drop each labeled Alternate state onto its respective KPI.

KPIs will only be affected by filters that are associated with the identical Alternate state.

View solution in original post

4 Replies
PradeepK
Creator II
Creator II

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

Chanty4u
MVP
MVP

Hi,

if you want to exclude fields you can use  like below 

Sum({<year = >}Field)

or

=sum( {1} {<year=,month=>}field)

Long
Contributor
Contributor
Author

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.

duchezbr
Contributor III
Contributor III

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

  1. In Master items>Alternate states>Create new alternate states and label (e.g., KPI_1, KPI_2).
  2. Drag and drop each labeled Alternate state onto its respective KPI.

KPIs will only be affected by filters that are associated with the identical Alternate state.