Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

virilo_tejedor
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)?

Thanks in advance,

Virilo

1 Solution

Accepted Solutions
MVP
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
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)

virilo_tejedor
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
MVP

Re: Ignoring the selection in one field

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

virilo_tejedor
New Contributor III

Re: Ignoring the selection in one field

Thanks again!