Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
FirstSortedValue(Weekday, -Aggr(Count(DISTINCT Customer), Weekday))