Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
virilo_tejedor
Creator
Creator

Counting in the left side of the set expression

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

1 Solution

Accepted Solutions
sunny_talwar

May be try this

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

View solution in original post

2 Replies
sunny_talwar

May be try this

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

virilo_tejedor
Creator
Creator
Author

Hi Sunny,

Thanks a lot.

It's working.

Best regards