Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Product | Date Type | Date Type ID | Date |
abc | Order Date HYD | 111 | 22/11/2021 |
abc | Order Date CHE | 112 | 2/11/2021 |
abc | Order Date MUM | 113 | 20/11/2021 |
abc | Order Date DEL | 114 | 22/10/2021 |
abc | First Orderdate | 110 | 22/10/2021 |
bcd | Order Date HYD | 111 | 5/7/2022 |
bcd | Order Date CHE | 112 | 5/6/2022 |
bcd | Order Date MUM | 113 | 4/6/2022 |
bcd | Order Date DEL | 114 | 3/7/2022 |
bcd | First Orderdate | 110 |
Hi All,
I have a requirement, where for each product we have different order dates. in qliksense report I need to show order dates, and if first order date is not avaialble then show mininum of order dates. its not working for me with range min. Please help me with this. Thanks in advance.
Try something like this:
Dayname( If ([Date Type ID]=110,
alt(only(Date), min({<[Date Type ID]={111, 112, 113, 114}>}total <Product> Date)) ,
if([Date Type ID]=120,
alt(only(Date), min({<[Date Type ID]={121, 122, 123, 124}>}total <Product> Date)),
only(Date))))
You might need to use total in your expression as you do have the DateTypes in your table. Try this:
dayname( alt(only(Date), min(total <Product> Date)) )
Thank you for the reply. Actually it worked if I have only order date....but what if I have order date and delivery date as follows...
Product | Date Type | Date Type ID | Date |
abc | Order Date HYD | 111 | 22/11/2021 |
abc | Order Date CHE | 112 | 2/11/2021 |
abc | Order Date MUM | 113 | 20/11/2021 |
abc | Order Date DEL | 114 | 22/10/2021 |
abc | First Orderdate | 110 | 22/10/2021 |
abc | Delivery Date HYD | 121 | 25/11/2021 |
abc | Delivery Date CHE | 122 | 10/11/2021 |
abc | Delivery Date MUM | 123 | 22/11/2021 |
abc | Delivery Date DEL | 124 | 25/10/2021 |
abc | First Delivery Date | 120 | 25/10/2021 |
bcd | Order Date HYD | 111 | 5/7/2022 |
bcd | Order Date CHE | 112 | 5/6/2022 |
bcd | Order Date MUM | 113 | 4/6/2022 |
bcd | Order Date DEL | 114 | 3/7/2022 |
bcd | First Orderdate | 110 | |
bcd | Delivery Date HYD | 121 | 15/7/2022 |
bcd | Delivery Date CHE | 122 | 15/6/2022 |
bcd | Delivery Date MUM | 123 | 14/6/2022 |
bcd | Delivery Date DEL | 124 | 13/7/2022 |
bcd | First Delivery Date | 120 |
As my data have orderdates and Delivery dates....if first order date is null then take minimum of Hyd, Che,Mum and Del order dates and similarly if first delivery date is null then take minimum of Hyd, Che,Mum and Del Delivery dates.
Try something like this:
Dayname( If ([Date Type ID]=110,
alt(only(Date), min({<[Date Type ID]={111, 112, 113, 114}>}total <Product> Date)) ,
if([Date Type ID]=120,
alt(only(Date), min({<[Date Type ID]={121, 122, 123, 124}>}total <Product> Date)),
only(Date))))
I am getting correct value only upon selection of product. If no product is selected I am getting only one date for all products. Please help.
Thank you for the help. Now I am getting dates. I want to get status corresponding to the minimum date. Could you please help me with it.
Product | Date Type | Date Type ID | Date | Status |
abc | Order Date HYD | 111 | 22/11/2021 | Open |
abc | Order Date CHE | 112 | 2/11/2021 | Draft |
abc | Order Date MUM | 113 | 20/11/2021 | Assume Completed |
abc | Order Date DEL | 114 | 22/10/2021 | Done |
abc | First Orderdate | 110 | 22/10/2021 | Open |
abc | Delivery Date HYD | 121 | 25/11/2021 | Draft |
abc | Delivery Date CHE | 122 | 10/11/2021 | Assume Completed |
abc | Delivery Date MUM | 123 | 22/11/2021 | Done |
abc | Delivery Date DEL | 124 | 25/10/2021 | Open |
abc | First Delivery Date | 120 | 25/10/2021 | Draft |
bcd | Order Date HYD | 111 | 5/7/2022 | Assume Completed |
bcd | Order Date CHE | 112 | 5/6/2022 | Done |
bcd | Order Date MUM | 113 | 4/6/2022 | Open |
bcd | Order Date DEL | 114 | 3/7/2022 | Draft |
bcd | First Orderdate | 110 | Assume Completed | |
bcd | Delivery Date HYD | 121 | 15/7/2022 | Done |
bcd | Delivery Date CHE | 122 | 15/6/2022 | Open |
bcd | Delivery Date MUM | 123 | 14/6/2022 | Draft |
bcd | Delivery Date DEL | 124 | 13/7/2022 | Assume Completed |
bcd | First Delivery Date | 120 | Done |
Thank in advance.