topic Only displaying data which reaches a certain % in bar chart in QlikView

Only displaying data which reaches a certain % in bar chart

Wed, 09 Dec 2009 23:10:23 GMT

Hi,

I have a bar chart which has 3 dimensions and one expression which gives the value as a %

If the % value is below 5% I do not want to display it - does anyone know how to do this?

Thanks

Only displaying data which reaches a certain % in bar chart

Thu, 10 Dec 2009 01:23:45 GMT

Use calculated dimension. Instead of

MyDimension

use

=if( your_expression > 0.05, MyDimension)

Only displaying data which reaches a certain % in bar chart

johnw — Thu, 10 Dec 2009 02:40:37 GMT

That may not work without a little modification. If the expression is sum(A)/sum(B), for instance, the sums won't work without doing an explicit aggregation. Adding aggregation across the three dimensions would be one solution, but since we have three dimensions, I'd think we'd be adding it to all three, which is an unweildy solution even if it would work. It would be simpler to apply this approach to the expression instead of the dimensions:

if(your_expression>0.05,your_expression)

And make sure that zero values are suppressed.