Qlik Community

App Development

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

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
rcandeo
Creator III
Creator III

why is this set analysis not working?

I have this expression that works bringing amount

sum({$<YearMonth_LayOut={"$(=$(vYearMonth))"}>} amount)

But it brings only actual year/month and I need to see the months till actual month not including it. So I change the expression to

sum({$<YearMonth_LayOut={"<$(=$(vYearMonth))"}>} amount) and it brings me nothing

vYearMonth has the result = 2019/07 and I have data for YearMonth_LayOut since last year

Any idea what is wrong in  my expression please?

11 Replies
rcandeo
Creator III
Creator III
Author

Unfortunatelly no numbers here

rcandeo
Creator III
Creator III
Author

the first expression came with no numbers and the second did no respected the selection and all months were there