topic Displaying Only Exception Data in QlikView

Displaying Only Exception Data

Tue, 29 Nov 2011 19:24:19 GMT

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

Displaying Only Exception Data

Tue, 29 Nov 2011 19:41:56 GMT

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

Re: Displaying Only Exception Data

Tue, 29 Nov 2011 19:44:32 GMT

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

Displaying Only Exception Data

Tue, 29 Nov 2011 20:07:31 GMT

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