Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Max75
Contributor II
Contributor II

Filterable first date creation

Hello everyone,

I need to create a dimension in a graph, which identifies me the first date when the order goes into 'PAI' status.
I am using :
Date(Min({< [order_status_log] ={'PAI'}>} ([event_date_log]),[Order number]),'DD/MM/YYYY')
Which returns me an unfilterable measure. How do I create a filterable dimension in a graph?
Thank you

Order number event_date_log order_status_log
7001022512 29/12/2021 16:47 DRAFT
7001022512 09/02/2022 15:30 IPF
7001022512 01/07/2022 07:49 TBF
7001022512 01/07/2022 11:52 TBF
7001022512 01/07/2022 17:30 TBF
7001022512 01/07/2022 17:30 TBF
7001022512 01/07/2022 17:30 TBF
7001022512 01/07/2022 17:31 PAI
7001022512 04/07/2022 13:17 PAI
7001022512 04/07/2022 13:17 PAI
7001022512 12/07/2022 10:20 PAI
7001022512 12/07/2022 10:20 PAI
7001022512 12/07/2022 10:20 PAI
7001022512 12/07/2022 10:20 PAI
7001022512 12/07/2022 10:20 PAI
7001022512 12/07/2022 10:21 ACT
Labels (2)
2 Replies
chaorenzhu
Creator II
Creator II

Why not just creating a field for the first date in load script, something like:


load [Order number],
date(min(event_date_log)) as first_date
resident [your_table]
where order_status_log = 'PAI'
group by [Order number];

 

If you want first timestamp instead, just change date() to timestamp()

Max75
Contributor II
Contributor II
Author

Unfortunately, I do not have access to the loading script