8 Replies Latest reply: Oct 31, 2017 3:29 AM by Michele De Nardi RSS

    want to use max function in where clause of load editor in qliksense?

    Divyanshi Bansal

      Hi,

       

      I want to calculate the data of latest Quarter of the year.

      Quarter is the column in the table FY.

       

      tab1:
      Load
      "Customer Group",

      Text(if(Sum("Total Revenue")<=0.25,'Tail Account (Rev< 1 Mn)',
      if(Sum("Total Revenue")>=1.2,'Large Account (Rev> 5 Mn)',
      If(Sum("Total Revenue")>=0.25 and sum("Total Revenue")<=1.2,'Middle Account (Rev 1-5 Mn)')))) as account
      Where Quarters=Max(Quarters)

      Resident FY
      Group by "Customer Group";

       

      Using max(Quarters ) in where clause gives error.

       

      Kindly help.