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

Hint: How to filter Dimensions Based on complex Calculations

To filter dimensions based on complex calculations I use the following way:

Use the Pareto Select as an action in a button. The trick is the expression.

Put your condition in the form

If( condition = true, 1,0) and select the percentage as 50.

The condition can be really complex. Don't use "=" at the beginning of the expression in front of if (bug ?).

Together with a select excluded button, this is very powerful and user friendly.

I hope this is interesting for you.

Norbert

3 Replies
Not applicable
Author

Could you post a small exempel? I don't really fellow (ok it is late over here...). But I'm curious!

Thanks in advance!

Anonymous
Not applicable
Author

Roberto, please see attached example.

Regards

Norbert

Not applicable
Author

Nice! Thanks!