Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
alexbg1997
New Contributor III

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
YoussefBelloum
Esteemed Contributor

Re: Exclude null values from chart

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
Highlighted
YoussefBelloum
Esteemed Contributor

Re: Exclude null values from chart

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

alexbg1997
New Contributor III

Re: Exclude null values from chart

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
Esteemed Contributor

Re: Exclude null values from chart

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 ?

alexbg1997
New Contributor III

Re: Exclude null values from chart

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
Esteemed Contributor

Re: Exclude null values from chart

you are welcome ! good luck