Qlik Community

Qlik Sense App Development

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

deepanshu_chamo1
New Contributor

Pick the latest date

Hi All

Kindly help in the below logic in Qlik Sense( both in the SQL Query and Visualization):

In want to calculate the Age of the case as ( Snapshot attached )

Age = 5/1/2016 - 1/1/2016

i.e. the last Timestamp date (where case is closed) - the day on which the ticket is submitted.

But the problem is there are so many dates between the start date and closed date, can you please guide me how can I get the age

swuehl

sunindia

gwassenaar

Attached is the snapshot for your reference

Thanks

Deepanshu

Tags (1)
2 Replies

Re: Pick the latest date

May be like this:

Only({<Status = {'Closed'}>} Timestamp - [Submit Date])

MVP
MVP

Re: Pick the latest date

Maybe like

=Only({<Status = {Closed}>}Timestamp) - Only({<Status = {Open}>} Timestamp)

in a chart with dimension [Request Number].

Community Browser