Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

itberatung24
New Contributor III

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

Re: Hint: How to filter Dimensions Based on complex Calculations

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

Thanks in advance!

itberatung24
New Contributor III

Re: Hint: How to filter Dimensions Based on complex Calculations

Roberto, please see attached example.

Regards

Norbert

Not applicable

Re: Hint: How to filter Dimensions Based on complex Calculations

Nice! Thanks!

Community Browser