Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

To find a weekday with maximum customer

I am new to Qlik Sense, with the table like below:

Transaction_Date    Weekday    Customer

2018/04/01               Sun           1

2018/04/02               Mon         2

2018/04/03               Tue           3

2018/04/04               Wed         4

2018/04/05               Thu           5

2018/04/06               Fri             6

2018/04/07               Sat            7

2018/04/08               Sun           8

2018/04/09               Mon         9

2018/04/10               Tue           10

2018/04/11               Wed         11

2018/04/12               Thu          12

2018/04/13               Fri            13

2018/04/14               Sat            14

And I want to return the weekday with the maximum total customer, which is "Sun"

How can I do that?

Thanks to all

1 Reply
sunny_talwar

May be like this

FirstSortedValue(Weekday, -Aggr(Count(DISTINCT Customer), Weekday))