Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kaitlynwagner_s
Contributor II
Contributor II

Count IF that does not set expression

Hi all! Hope all is well--

 

I am working on a report where i need to count Distinct OrderKeys (Orders) where they are late, based on  specific warehouse (WHSE), and how late they are (Date Group). The problem I am running into is i wanted to create a measure using COUNT DISTINCT (as one orderkey can have multiple customers), but the set expression does not "change" when i filter on particular date groups.

 

Im trying to figure out how to write a measure that is not static, that will change when i select my date group filters filter-- 

 

 

count({<DayGroup={'1-7','8-14','14+'},WHSE={'Phoenix'}>}distinct Orders)

 

 

Labels (1)
1 Reply
Digvijay_Singh

Probably you may want to remove DayGroup condition from the set expression if you want to make selections in the filter and wants to see the change