Show in the chart just data up to...

[pascos88]

Hello,

In my datamodel, I use the calendar and I have all the data. Now in the chart I would just show date from 2017 that in the Qlik sense number is 42736.

What's wrong with my set expression:

= Aggr(Only({<NUM(Confirmdate) = {'>=42736'}>} Confirmdate), Confirmdate)

Thanks for any helps.

[sunny_talwar · Accepted solution]

May be try this

If(Confirmdate >= 42736, Confirmdate)