Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
RoyBatty
Contributor III
Contributor III

Filter (button?) that applies set expression?

Hi,

On the sheet we have a simple user table that only has dimensions: Name, Email, User ID ...

There is also a KPI that has the following measure:

Count({<[Standard Activity Period]={'Y'}, [Activity]={'Payment'}>} distinct [user_id])

RoyBatty_0-1712092810988.png

Then we used the set expression that was used for the KPI to show me only those specific users in the users table. It looks like this:

=Aggr(
Only({<[Standard Activity Period]={'Y'}, [Activity]={'Payment'}>} distinct [user_id]),
[user_id]
)

We specified that for the "user_id" column (dimension) of the users table and it works, everything is good, it only shows those specific users. However, is it possible to make a special filter/button, something that is "toggleable": when we click on it to apply that set expression, when we click again to remove it?

We tried with the "Button" element, with different types of actions to apply that set expression (as "value"), but nothing worked.

Labels (1)
1 Reply
marcus_sommer

I suggest just to use the normal usability and providing the period/activities as selections and then the user selects the wanted views. It's not only simpler in the development/maintaining else also in the usability if no button/action magic is included.