topic Re: Order_Date=max(Order_Date) gives an error in formula in QlikView

Order_Date=max(Order_Date) gives an error in formula

london1980 — Sun, 22 Nov 2015 23:08:59 GMT

Hi All,

I'm trying to write a conditional sum function.

When I write it like this, it works.

sum(if(Order_Date='18/11/2015',Order_Qty)

But if I want to make the chosen date dynamic as the most recent date in the table, where I'm using max(Order_Date), it gives an error:

Error in Expression

sum(if(Order_Date=max(Order_Date),Order_Qty)

Any idea how to fix this?

thanks..

jagan — Mon, 23 Nov 2015 03:45:26 GMT

Try like this using SEt analysis

sum({<Order_Date={'$(=Date(max(Order_Date)))'}>} Order_Qty)

Hope this helps you.

Regards,

jagan.

vipin_mishra479 — Mon, 23 Nov 2015 07:27:04 GMT

Hi Maham

there multiple way you find this answer what ever Jagan has mention this is the one way and another way is

create a variable like

vMaxdate = Date(max(Order_Date),'DD/MM/YYYY')

and use

sum({<Order_Date = {'$(vMaxdate )'}>}Order_Qty)

Try this may be helpful for you

vipin

Anonymous — Mon, 23 Nov 2015 07:30:09 GMT

Try what Jagan and Vipin suggested,

also make sure format should match as max() returns a integer value not a formatted date like ORDERDate