

Contributor III
2018-08-07
02:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Fixed KPI for Specific Values
Hello
I want to show KPI in my dashboard that does not change its values.
My table is like this:
And I want two KPI one for BUDGET and one for ACTUAL
but the problem is they both show the sum of total values of data field and if I chose budget as a filter then they both change their value for the budget and for the actual.
I want to fix the KPI one for Budget and one for Actual
- Tags:
- qlikview_deployment
849 Views
1 Reply

MVP
2018-08-07
07:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you tried using set analysis to ignore selection? Let's say your expressions are Sum(Budget) and Sum(Actual)... you can either ignore all selections by using Sum({1} Budget) and Sum({1} Actual) or ignore just selection in Budget by doing this Sum({<Budget>} Budget) and Sum({<Budget>} Actual). Read more about set analysis here
778 Views
