Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

Date with Max value

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

1 Solution

Accepted Solutions
everest226
Creator III
Creator III
Author

=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

View solution in original post

6 Replies
sunny_talwar

May be like this:

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

sunny_talwar

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

Not applicable

sunny_talwar

Is your issue still not resolved?

everest226
Creator III
Creator III
Author

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]))

everest226
Creator III
Creator III
Author

=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