Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get Days in Queue as another column


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#;

11 Replies
javier_florian
Creator III
Creator III

Check additional options in your expression:

Not applicable
Author

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.