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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis

hi

I'm sorry for the language. i m french

this is good: Count (DISTINCT {$<GERS={"=sum({1<MOIS={6}>}[Total Net])>0"} >} GERS)

but when i want to select a range the result is not good:

Count (DISTINCT {$<GERS={"=sum({1<MOIS={"<9>5"}>}[Total Net])>0"} >} GERS).

the formula with out "" is good but the results are 0

Count (DISTINCT {$<GERS={"=sum({1<MOIS={<9>5}>}[Total Net])>0"} >} GERS).

Have you got a solution?

best regards

0 Replies