Range Min of dates not working

[lakshmittpd]

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.

[Vegar]

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)) )

[lakshmittpd]

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.

[Vegar · Accepted solution]

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))))

[lakshmittpd]

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.

[lakshmittpd]

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.