Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.