New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

Ignoring the selection in one field

Hi,

I'd like to count all users that have reached a point in the purchasing process.

The idea is to have a segmentation of users who wasn't able to overcome a step (or users that decided to leave at this step): STATE_OF_PROGRESS > 2

For me, it's important to differenciate between users that have overcome this point at least once in the past.  So I group by user and take into account their Max(STATE_OF_PROGRESS)

Count({\$<USER_ID = {"=Max(STATE_OF_PROGRESS) > 2"}>} DISTINCT USER_ID)

The problem here, is that STATE_OF_PROGRESS is a complex function depending on another STATE field.

I'd like the expression above to be indifferent to the selection in STATE.

I tryed without success:

Count({\$<USER_ID = {"=Max(STATE_OF_PROGRESS) > 2"},STATE=>} DISTINCT USER_ID)

Count({\$<USER_ID = {"=Max(STATE_OF_PROGRESS) > 2,STATE="}>} DISTINCT USER_ID)

How could I ignore the selection in one concrete field (STATE)?

Virilo

Tags (3)
1 Solution

Accepted Solutions
MVP

Re: Ignoring the selection in one field

May be this

Count({\$<USER_ID = {"=Max({<STATE>}STATE_OF_PROGRESS) > 2"},STATE=>} DISTINCT USER_ID)

Or this

Count({\$<USER_ID = {"=Max({<STATE>}STATE_OF_PROGRESS) > 2"}>} DISTINCT USER_ID)

4 Replies
MVP

Re: Ignoring the selection in one field

May be this

Count({\$<USER_ID = {"=Max({<STATE>}STATE_OF_PROGRESS) > 2"},STATE=>} DISTINCT USER_ID)

Or this

Count({\$<USER_ID = {"=Max({<STATE>}STATE_OF_PROGRESS) > 2"}>} DISTINCT USER_ID)

New Contributor III

Re: Ignoring the selection in one field

Thanks a lot, Sunny!

The first one is working like a charm:

Count({\$<USER_ID = {"=Max({<STATE>}STATE_OF_PROGRESS) > 2"},STATE=>} DISTINCT USER_ID)

The other one is not working for me.

Why must I use this set modifier {<STATE>}?  What does it mean without an equal operator?

MVP

Re: Ignoring the selection in one field

Equal sign or no equal sign... it means the same thing... ignore selection

New Contributor III

Thanks again!