2 Replies Latest reply: Jan 5, 2018 8:30 PM by Mohammad Azadi RSS

    condition in Table in qlik sense

    Mohammad Azadi

      hello experts;

      i have below tables

       

      TableUser:

      load * inline [

      UserID, Name

      1001, User1

      1002, User2

      1003, User3

      ];

       

      TableSales:

      load * inline [

      UserID, Sale

      1001, 200

      1001, 300

      1001, 250

      1002, 400

      1002, 450

      1003, 700

      1003, 550

      ];

       

      in qlik sense i want maketable with expression condition that show me UserID , Name and only Maximum of value Sales. same below:

       

      UserIdNameSale
      1001User1300
      1002User2450
      1003User3700

       

      how can i do it , without make other table in data editor (only use expression in Table section)?