Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

virilo_tejedor
New Contributor III

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

Re: Counting in the left side of the set expression

May be try this

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

2 Replies

Re: Counting in the left side of the set expression

May be try this

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

virilo_tejedor
New Contributor III

Re: Counting in the left side of the set expression

Hi Sunny,

Thanks a lot.

It's working.

Best regards

Community Browser