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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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