Qlik Sense Pivot Table - how to display issue tickets based on days

[jim_chan]

Hi all,

i am doing it in Qlik Sense.

I created en expression/measure - filedname(Need By) , and i have added the expression as below. Once it is loaded, it loaded out not what i have expected.

i know the expression i have applied should be wrong. what i wanted it list out all the tickets, but list out tickets that going to due soon then only follow by others.

example will be - i have used "today() " which is 16/02/2016 today, and list out ticket dueing soon , that would be 18/02, 19/02.. then only follow by the rest...

i am not able to achieve it rite now.

[shree909]

Hi try to use

If( floor(today()-floor([Need By]) <=3 , [Date([Need By]))