Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Only Max Values

Hi,

I am attaching the sample app .refer it and  provide the solution.

Hope some one would help me out this.

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

11 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Try this expression: only({<StartDate={'$(=date(max(StartDate)))'}>}StartDate)


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Hi,

try this

only({<StartDate={'$((=date(only(max(StartDate))))'}>}StartDate)

Highlighted
Contributor III
Contributor III

Thanks for responding me

Could you try with this date in Excel file.

the same expression is not working with the date

Highlighted
MVP & Luminary
MVP & Luminary

Works for me.


talk is cheap, supply exceeds demand
Highlighted
Contributor III
Contributor III

Could you share me the sample app

I will look into probably I missed out something

Highlighted
MVP & Luminary
MVP & Luminary

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Contributor III
Contributor III

Gysbert,

Coould you also check this please?

seeking your suggestion

Highlighted
MVP & Luminary
MVP & Luminary

Since you're working with timestamps instead of plain dates you'll have to make sure to format the result as a timestamp too: only({<Start={'$(=timestamp(max(Start)))'}>}Start)


talk is cheap, supply exceeds demand
Highlighted
Contributor III
Contributor III

HI Thanks for valuable solution but still I need the max time stamp to be converted in Dates

I need the Max dates in the output though it is timestamp fields