5 Replies Latest reply: Sep 30, 2016 6:58 AM by Deepak K M RSS

    Tableau expression in Qlik sense

    Deepak K M

      `{ fixed [Customer Number]: if COUNTD([Order Number])>25 then 'Frequent Shoppers' Else 'Non-Frequent Shoppers' END}`



      I have this expression in tableau. It is counting the order number greater than 25 for each customer number. Customer number and order number are the two columns in the table XYZ. What would be the expression for dimension in qlik sense ? Frequent and non frequent shoppers are  just a declared in text