Discussion Board for collaboration regarding Qlik DataMarket.
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% ?
Go to Solution.
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
May be like this:
If(PrecentageExpression >= 0.20, PrecentageExpression)
Update: Replace PrecentageExpression with whatever your current expression is for PERCENTAGE column above
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.