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
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
virilo_tejedor
Creator
Creator

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
sunny_talwar

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)

View solution in original post

4 Replies
sunny_talwar

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
Creator
Creator
Author

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?

sunny_talwar

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

virilo_tejedor
Creator
Creator
Author

Thanks again!