Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

How to show a subset in a table

Hi all,

I'm trying to show a subset of values in a table, but I need an help.

I have got a table data like this:

________________________________

ID        NAME        PERCENTAGE

________________________________

001          Italy                   31%

002          Germany            19%

003          Swiden               20%

004          France                15%

005          Holland               15%

________________________________

But I need to show only the values which have the percentage >= 20%

Where can I add the condition in the table to obtain only the rows with percentage >= 20% ?

Thank you.

Tags (3)
1 Solution

Accepted Solutions

Re: How to show a subset in a table

There are diferent ways to realize this objective:

1) use dimension limit (is the third tab of properties of chart) and set the percentage you need

2) if you have only one expression you can write: if(opercentage >= 20%, percentage, 0) and in the presentation tab set

"suppress zero values"

3) in the dimension you can aggr the expression and test the result setting other items to null, then exclude null values

Let me know

3 Replies

Re: How to show a subset in a table

May be like this:

If(PrecentageExpression >= 0.20, PrecentageExpression)

Update: Replace PrecentageExpression with whatever your current expression is for PERCENTAGE column above

Re: How to show a subset in a table

There are diferent ways to realize this objective:

1) use dimension limit (is the third tab of properties of chart) and set the percentage you need

2) if you have only one expression you can write: if(opercentage >= 20%, percentage, 0) and in the presentation tab set

"suppress zero values"

3) in the dimension you can aggr the expression and test the result setting other items to null, then exclude null values

Let me know

Employee
Employee

Re: How to show a subset in a table

Hello Gio,

Check this out as well and let us know how else we can help:

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Community Browser