2 Replies Latest reply: Oct 27, 2017 7:36 AM by Virilo Tejedor RSS

    Counting in the left side of the set expression

    Virilo Tejedor

      Hi,

       

      I'd like to do a segmentation differentiating between just registered users in a web portal and actual clients who had bought something in the past.

       

      I'd like to do things like counting users without any purchase:

       

                      Count( {$<=Count(ORDER_ID) = {0}>} DISTINCT USERNAME )

       

      Having this, I could show graphics of real clients vs just registered users.

       

      The expression above doesn't work in QlikSense. How could I do this type of set expressions?

       

      I'd like to know if it's possible or if I should do this segmentation creating a new column in the load script.

       

      Thanks in advance.

       

      Best regards,

       

      Virilo