Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exclude null values from chart

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

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

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)

View solution in original post

5 Replies
YoussefBelloum
Champion
Champion

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
Not applicable
Author

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
Champion
Champion

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
Not applicable
Author

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
Champion
Champion

you are welcome ! good luck