topic Re: How to get Days in Queue as another column in QlikView

How to get Days in Queue as another column

Wed, 23 Oct 2013 12:29:14 GMT

Hi,

I have to get Days in Queue as another column in straight/table box by using below formula

=DAYS360(TODAY(),Date)

I sit possible to get this in script?

CompanyItems:

LOAD ID,

Name,

ContactMethod,

Portfolio,

WorkItemType,

Priority,

Date;

SQL SELECT *

FROM CompanyItems

where Date between #01/07/2013# and #25/10/2013#;

Re: How to get Days in Queue as another column

javier_florian — Wed, 23 Oct 2013 12:34:26 GMT

You can try with follow script:

CompanyItems:

LOAD ID,

Name,

ContactMethod,

Portfolio,

WorkItemType,

Priority,

Date

Datediff(day, Date, getdate()) ;

SQL SELECT *

FROM CompanyItems

where Date between #01/07/2013# and #25/10/2013#;

Datediff apply to SQL Server.

Re: How to get Days in Queue as another column

Wed, 23 Oct 2013 12:45:36 GMT

Hi,

Thanks can you please explain a bit more as I have to show how many days the ID is in Queue with a column as

Days in Queue.

Actually my source is access database table

Re: How to get Days in Queue as another column

Gysbert_Wassenaar — Wed, 23 Oct 2013 12:52:44 GMT

CompanyItems:

LOAD ID,

Name,

ContactMethod,

Portfolio,

WorkItemType,

Priority,

Date

interval(Today()-Date,'D') as DaysInQueue;

SQL SELECT *

FROM CompanyItems

where Date between #01/07/2013# and #25/10/2013#;

Re: How to get Days in Queue as another column

Wed, 23 Oct 2013 12:57:27 GMT

Thanks and it's working but when I am sending data to excel it is showing Days in Queue as

DaysInQueue

336:00:00

###############################################################################################################################################################################################################################################################

1488:00:00

216:00:00

1656:00:00

0:00:00

144:00:00

360:00:00

0:00:00

144:00:00

504:00:00

0:00:00

216:00:00

0:00:00

1512:00:00

48:00:00

624:00:00

144:00:00

168:00:00

0:00:00

24:00:00

1296:00:00

336:00:00

120:00:00

480:00:00

120:00:00

312:00:00

288:00:00

840:00:00

144:00:00

288:00:00

As I can formt cells as Number but I don't want my user to do again formatting as I have to send my user file means he/she can use that wothout alignment please can you help me how to set this.

And also is it possible to show minus values as in Red colour by using RGB?

Re: How to get Days in Queue as another column

javier_florian — Wed, 23 Oct 2013 13:19:23 GMT

Ooopss.. Wassenaar are right...

Amelia, If you work with access, try to get format to new field with format function.

Re: How to get Days in Queue as another column

Wed, 23 Oct 2013 13:22:39 GMT

How to use format?

Re: How to get Days in Queue as another column

javier_florian — Wed, 23 Oct 2013 14:18:40 GMT

try with over your script:

num(interval(Today()-Date,'D'),'#0')

Re: How to get Days in Queue as another column

Wed, 23 Oct 2013 14:29:59 GMT

Thanks and it's working and is there anyway to show number in RED colour if Days in Queue is less than Today number for eg:

please see attached.

Re: How to get Days in Queue as another column

javier_florian — Wed, 23 Oct 2013 14:46:37 GMT

=If('Your_Date'<Today(),RGB(255,0,0),RGB(0,128,0))

Re: How to get Days in Queue as another column

javier_florian — Wed, 23 Oct 2013 14:48:03 GMT

Check additional options in your expression:

Re: How to get Days in Queue as another column

Wed, 23 Oct 2013 14:57:07 GMT

I gave in Text color as =If('Your_Date'<Today(),RED(255),RED(128)) because i need RED colour.

And moreover I need to appear RED colour only the Days in Queue Number is less than TODAY

Is that possible. please let me know.