1 Reply Latest reply: Apr 6, 2018 11:42 AM by Sunny Talwar RSS

    To find a weekday with maximum customer

    Consultancy ORBIT

      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