Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
yashpace
New Contributor II

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!!

2 Replies
sugathirajkumar
Contributor

Re: Set Expression to change value in KPI using multiple Filters

can you pls try it with $ current selection?

yashpace
New Contributor II

Re: Set Expression to change value in KPI using multiple Filters

Hi, 

I tried -

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

 

But still getting months count.