Skip to main content
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))