Exclude null values from chart

[Anonymous]

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 · Accepted solution]

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]

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]

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]

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]

you are welcome ! good luck