topic Re: Exclude null values from chart in QlikView

Exclude null values from chart

Anonymous — Wed, 29 Nov 2017 14:00:02 GMT

Hello Guru's!

I am looking to write an expression that will exclude a certain value from being included in my data model.

The EXAMPLE column contains a range of data of which I wish to include apart from the value of AABB.

Would this be done through a conditional expression in the chart in which the data is displayed? Or is this done in the load script?

Also what would be the most suitable statement to achieve this? It seems to be a WHERE statement but not 100%.

Thanks All

YoussefBelloum — Wed, 29 Nov 2017 14:19:50 GMT

Hi,

the solution depends on what you really need.

you need exclude this value from one chart or you don't need it at all in your model?

if you don't need it at all, do it on the script:

TABLE:

LOAD

FROM TABLE...

WHERE not match(EXAMPLE,'AABB');

if you just need to remove on a chart:

example : AGGR_FUNCTION( {< EXAMPLE -={'AABB'} >} MEASURE)

Anonymous — Wed, 29 Nov 2017 14:33:02 GMT

Hi Youssef,

Thanks for the reply! I am trying to remove the data only from the chart, apologies I should have made this clear.

So the aggregative function is the option i will use, can you tell me whether this is a conditional expression within the chart expressions?

Thanks again!

Alex.

YoussefBelloum — Wed, 29 Nov 2017 14:52:51 GMT

with the expression i gave you, the condition is already inside:

AGGR_FUNCTION( {< EXAMPLE -={'AABB'} >} MEASURE)

so just put it on the expression part of the chart

is it clear ?

Anonymous — Wed, 29 Nov 2017 16:04:30 GMT

Yes that is brilliant thank you.

Also, I was able to do this by a set analysis expression in the chart which seems to provide a more rigid display.

Thanks for your time!

Alex.

YoussefBelloum — Wed, 20 Dec 2017 10:11:07 GMT

you are welcome ! good luck