topic Re: Max function on date in dimension in straight table in QlikView

Max function on date in dimension in straight table

Tue, 25 Nov 2014 10:04:08 GMT

I have a date field in dimension in straight table and I wan to use max date but max function no working in if condition on date.

It's like I want to show products for max date in straight table.

What to do?

Thanks

Saurabh

ashfaq_haseeb — Tue, 25 Nov 2014 10:40:00 GMT

HI,

Look at firstsortedvalue() Function

Regards

ASHFAQ

Anonymous — Tue, 25 Nov 2014 10:57:11 GMT

use this =FirstSortedValue(Products, -[DateDim])

jagan — Wed, 26 Nov 2014 02:43:22 GMT

Hi,

Try like this

Dimension: Product

Expression: Date(Max(Date))

Displays the list of products which exists on max date.

Dimension: Product

Expression: Only({<Date={'$(=Max(Date))'}>} Date)

Hope this helps you. If this is not you are expecting come up with some sample data and expected output.

Regards,

Jagan.