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

[sunny_talwar · Accepted solution]

May be try this

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

[virilo_tejedor]

Hi Sunny,

Thanks a lot.

It's working.

Best regards