topic Re: Only Max Values in QlikView

Only Max Values

Anonymous — Tue, 11 Nov 2014 13:16:42 GMT

Hi,

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

Hope some one would help me out this.

Thanks in advance

Re: Only Max Values

Gysbert_Wassenaar — Tue, 11 Nov 2014 13:29:54 GMT

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

Re: Only Max Values

Tue, 11 Nov 2014 13:33:25 GMT

Hi,

try this

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

Re: Only Max Values

Anonymous — Tue, 11 Nov 2014 14:08:05 GMT

Thanks for responding me

Could you try with this date in Excel file.

the same expression is not working with the date

Re: Only Max Values

Gysbert_Wassenaar — Tue, 11 Nov 2014 14:17:53 GMT

Works for me.

Re: Only Max Values

Anonymous — Tue, 11 Nov 2014 14:19:57 GMT

Could you share me the sample app

I will look into probably I missed out something

Re: Re: Only Max Values

Gysbert_Wassenaar — Tue, 11 Nov 2014 14:25:50 GMT

See attached qvw.

Re: Re: Re: Only Max Values

Anonymous — Wed, 12 Nov 2014 04:23:58 GMT

Gysbert,

Coould you also check this please?

seeking your suggestion

Re: Only Max Values

Gysbert_Wassenaar — Wed, 12 Nov 2014 08:26:02 GMT

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)

Re: Only Max Values

Anonymous — Wed, 12 Nov 2014 14:16:01 GMT

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

Re: Only Max Values

Gysbert_Wassenaar — Wed, 12 Nov 2014 14:19:23 GMT

Then create a date field from the timestamp:

date(floor(Start)) as StartDate

Re: Re: Only Max Values

Anonymous — Thu, 13 Nov 2014 09:43:31 GMT

Thanks Gysbert

that works fine

could you go through the following app