Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Reply
Highlighted

Re: Set Analysis with Operators

Try this

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