Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gavthomson
Contributor
Contributor

Set Analysis with Operators

Hi All,

A little stuck and it seems easy but for some reason I cannot get it to work.  The formula is supposed to 

1. count IDs between age 0 and 26 (which it does fine) and

2. Ignore the selection of the field Date.YearMonth (which it does not do fine!)


Count(distinct {(<[Age (Years)]={"=[Age (Years)]<26"}> * <[Age (Years)]={"=[Age (Years)]>0"}>) * <[Date.autoCalender.YearMonth]=>}
[Identifier])

Help please, it's driving me mad!

Regards

Gav

Labels (2)
1 Reply
sunny_talwar

Try this

Count(DISTINCT {<[Age (Years)] = {">0<26"}, [Date.autoCalender.YearMonth]>} [Identifier])