topic Re: Max Date in expression in QlikView

Max Date in expression

venkatg6759 — Mon, 05 May 2014 20:08:57 GMT

Hello ,

I need to include max date in expression . Can anyone help me how to write it.

I tried aggr(max)

Count({<Rating={'NR'}>}Rating)

I need to include max(Rating Date) into the above expression . I am using bar chart .

Thanks,

Venkata

Mon, 05 May 2014 20:19:31 GMT

Is it max date of date selected, or maybe max date of some chart dimension?

regards

Darek

venkatg6759 — Mon, 05 May 2014 20:35:42 GMT

Its max date of dimension which is called rating date

Mon, 05 May 2014 20:43:41 GMT

Try to look here:

regards

Darek

kangaroomac — Tue, 06 May 2014 02:25:58 GMT

Hiya,

Maybe this will help:

=Count({$<Rating={'NR'},RatingDate={$(=Max(RatingDate))}>}Rating)

jagan — Tue, 06 May 2014 02:33:18 GMT

Hi,

Try this

=Count({<Rating={'NR'}, [Rating Date] = {'$(=Date(Max([Rating Date])))'}>}Rating)

Regards,

Jagan.