topic Re: set analysis help in QlikView

set analysis help

Anonymous — Wed, 08 Apr 2015 06:49:12 GMT

Hi i have a table with 4 fields,

item,orderdate,unitcost,Rep

I want to get the unit cost for max(Orderdate).

I tried the following set expression ,it is not working .Please correct me

max({<OrderDate={$(=vDate)}>}[Unit Cost])

where vDate = max(OrderDate)

Anonymous — Wed, 08 Apr 2015 06:54:30 GMT

Sum({<OrderDate={"$(=vDate)"}>}[Unit Cost])

PrashantSangle — Wed, 08 Apr 2015 06:56:33 GMT

Hi,

Check date format after applying max()

OrderDate is num format then above solution work

else you need Date()

vDate=Date(max(OrderDate))

Regards

ganeshreddy — Wed, 08 Apr 2015 07:02:09 GMT

Hi RGV,

You can try both, Utkarsh and Max dreamer options. I hope it works fine

Best regards,

Ganesh