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

jim_chan — Tue, 16 Feb 2016 09:25:41 GMT

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.

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

shree909 — Wed, 17 Feb 2016 15:44:14 GMT

Hi try to use

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

topic Qlik Sense Pivot Table - how to display issue tickets based on days in App Development

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

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