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



      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,