topic max date in dimension in QlikView

max date in dimension

thanhphongle — Tue, 30 Jan 2018 08:31:02 GMT

Hello Community,

is there a way to return in a bar chart the max(date) as dimension.

Here is an example:

OrderNo	Order_Position	Date	Order_Quantity
10001	1	01.02.2018	10
10001	2	01.02.2018	20
10001	3	03.02.2018	30
10002	1	15.02.2018	50
10002	2	15.02.2018	100
10002	3	20.02.2018	150

QV should return in the dimension and as expression this:

OrderNo	Date	sum(Order_Quantity)
10001	max(date) = 03.02.2018	60
10002	max(date) = 20.02.2018	300

tresB — Tue, 30 Jan 2018 08:43:27 GMT

How is order_quantity 200 for order 10002? Do you want quantity of max date or the entire quantity for the order?

sumeet-vaidya — Tue, 30 Jan 2018 08:44:24 GMT

Hi Thanh,

Kindly add a calculated dimension as shown below in your chart.

Aggr(Max(Date#(Date, 'DD.MM.YYYY')),OrderNo)

Regards

Sumeet

thanhphongle — Tue, 30 Jan 2018 08:46:15 GMT

I m sorry it should be 300

tresB — Tue, 30 Jan 2018 08:55:45 GMT

Try like:

thanhphongle — Tue, 30 Jan 2018 09:04:06 GMT

Thanks for your solution!