Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yashpace
Contributor III
Contributor III

Set Expression to change value in KPI using multiple Filters

Hi, I have three filters for date, week and month and I would like to change the count of Distinct ORDNUM as user select any of the above filters 

Test.JPG

 I am trying this in Current KPI (Total Orders Dispatched) - 

Count({1} DISTINCT {<ORDNUM = {"=[NewOrderDate] = [NewDispatchDate] or [Week] = [WeekNewDispatchDate] or [Month] = [MonthNewDispatchdate]"}>} ORDNUM)

My filters respectively are- NewOrderDate. Week, Month (Here week and month are calendar values created by me ) 

This is giving me count of month if I select any date or week.

TIA!!

Labels (4)
2 Replies
sugathirajkumar
Creator
Creator

can you pls try it with $ current selection?

yashpace
Contributor III
Contributor III
Author

Hi, 

I tried -

Count({$} DISTINCT {<ORDNUM = {"=[NewOrderDate] = [NewDispatchDate] or [Week] = [WeekNewDispatchDate] or [Month] = [MonthNewDispatchdate]"}>} ORDNUM)

 

But still getting months count.