topic Re: max date in set operator in QlikView

max date in set operator

Tue, 19 Mar 2013 23:03:14 GMT

I have the following dataset. I am trying to get the latest three_year_fund_stdv_prod by using the following formula but it doenst work

max( {$<dte={"=$(=max(dte))"}>} three_yr_fund_stdev_prod)

I think there is an issue with my set operator

three_yr_fund_stdev_test three_yr_fund_stdev_prod dte

0.34665516783936 0.34665516783936 2013-03-01

0.35967874969951 0.35967874969951 2013-02-01

0.3737224266293 0.3737224266293 2013-01-01

0.38559724159305 0.38559724159305 2012-12-01

0.40008534514359 0.40008534514359 2012-11-01

CELAMBARASAN — Tue, 19 Mar 2013 23:08:31 GMT

Check with this

max( {$<dte={"=$(=Date(max(dte)))"}>} three_yr_fund_stdev_prod)

jagan — Wed, 20 Mar 2013 06:17:23 GMT

Hi,

Check whether date format in dte and Date(max(dte)) returns the date in same format, if not convert the date format.

Try like this

=max( {$<dte={"=$(=Date(max(dte)))"}>} three_yr_fund_stdev_prod)

=FirstSortedValue( three_yr_fund_stdev_prod, -dte)

Hope this helps you.

Regards,

Jagan.

kaushiknsolanki — Wed, 20 Mar 2013 06:22:17 GMT

Hi,

You expression is correct. All you need to do is just remove =. Have a look at the below expression.

max( {$<dte={"$(=max(dte))"}>} three_yr_fund_stdev_prod)

Regards,

Kaushik Solanki