Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max function on date in dimension in straight table

Hi

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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Dimension: Product

Expression: Date(Max(Date))

OR

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.

View solution in original post

3 Replies
ashfaq_haseeb
Champion III
Champion III

HI,

Look at firstsortedvalue() Function

Regards

ASHFAQ

balkumarchandel
Specialist II
Specialist II

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Dimension: Product

Expression: Date(Max(Date))

OR

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.