Displaying Only Exception Data

[#1]

We would like to create a document that only displays data if it fails to meet certain target criteria. Is there a way to do that?  I know I can use the > & < funtions in Presentation to highlight values if they are in a certain range.Thanks sumski

[#2]

Hi

Could you precise your objective. Do you want to create a conditional chart or to display some dimensions depending of the value of a variable ?

Regards  - JJ

[#3]

Jean-Jaques.

Thanks for your reply. Actually, I would like to learn to do both. My first priority would be to display dimensions depending on the value of the variable.

Thanks

Brian

[#4 · Accepted solution]

Brian

You can create a chart with you dimension then add an expression with  an If statement :

example :   if (   sum(  value) > 100 ,   sum(value) ) it displays only the dimension where the sum > 100.

There plenty of possibility to use display conditions. In the QV11, you will find out a new panel :: "Dimension limits" where you can  create easy conditions like the 10 largest values or the 80% biggest values , etc.

Hope that help

JJ