Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markp201
Creator III
Creator III

Set analysis result doesn't change

I have 2 kpi with the measure - sum({$<Location={Dealer}>}Orders) and sum({$<Location={Home}>}Orders)

There are only two options for Location - Home and Dealer

I have various filters including location.  When I select Home or Dealer for the location neither KPI changes.

The KPI does change when other filters are selected.

I created a table with Location and SUM(Orders) and this works when filtering the Location.

Why does the KPI not change for the one filter?

1 Solution

Accepted Solutions
agigliotti
Partner
Partner

maybe this:


sum( {$< Location *= {'Dealer'} >} Orders )


I hope it helps

View solution in original post

2 Replies
agigliotti
Partner
Partner

maybe this:


sum( {$< Location *= {'Dealer'} >} Orders )


I hope it helps

View solution in original post

vijetasharma
Specialist
Specialist

You have already filter out data based on location in expression sum({$<Location={'Dealer'}>}Orders) so it's not changing location filter and get affected by other filer. when you have sum(orders) and select values in location either Dealer or Home you will see same value as getting displayed on above expressions.


Regards,

Vijeta