Qlik Community

Qlik Sense App Development

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

jim_chan
Contributor III

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

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.

error.png

1 Reply
shree909
Valued Contributor II

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

Hi try to use

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

Community Browser