topic Re: Date with Max value in QlikView

Date with Max value

everest226 — Tue, 22 Nov 2016 00:38:11 GMT

How to get date of last months which has highest value . dimension is Day-week.

I want to capture 15 Tuesday as shown in attachment

Re: Date with Max value

sunny_talwar — Tue, 22 Nov 2016 02:02:35 GMT

May be like this:

FirstSortedValue([Day-week], -Aggr(Sum(value), [Day-week]))

Re: Date with Max value

sunny_talwar — Tue, 22 Nov 2016 02:03:00 GMT

Replace Sum(value) with whatever expression you are using in your chart

Re: Date with Max value

Tue, 22 Nov 2016 21:35:41 GMT

everest226‌

Re: Date with Max value

sunny_talwar — Wed, 23 Nov 2016 01:32:42 GMT

Is your issue still not resolved?

Re: Date with Max value

everest226 — Wed, 23 Nov 2016 04:42:09 GMT

hi i want to use set analysis for this to do . this is my expression in the chart

=Max(Aggr(Count (DISTINCT {<Year={'$(=max(Year))'}, Month-={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month),'MM')))"}>} [Authenticated user]),[Date Time]))

Re: Date with Max value

everest226 — Tue, 29 Nov 2016 19:25:29 GMT

=concat ( distinct IF( aggr ( Rank( Count (DISTINCT

[user])), [Date Time])<=1,

[YYYY-MMM] ), ', ' , num([YYYY-MMM]))

thanks Sunny i was able to get the result