Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
steveniow
Contributor III
Contributor III

Suppress a dimension label when expression is null

Hi,

I am trying to create a chart in a trellis with multiple dimensions, however not all of the values I need are populated on each day I have in the trellis.

How do I supress the labels where I have no data? I have tried to use an omit if null expression and it hasn't worked.

In the picture below you can see that there are several blank cloumns labelled AM, PM, EV and it is these I need to drop.

Thank you...

QVprob.PNG

7 Replies
sunny_talwar

What is the expression that you are using?

mark6505
Partner - Master
Partner - Master

Hi,

Not best practice , but you can use a calculated dimension.

If(ISNULL(SUM(Field)) =0,dimension)

Mark

stigchel
Partner - Master
Partner - Master

steveniow
Contributor III
Contributor III
Author

Thanks, this is a variation of the formula I tried but it doesn't work. I just gave it another shot with your syntax but no joy.

steveniow
Contributor III
Contributor III
Author

similar to below - but I couldn't get this to work either.

Not applicable

did you set the dimension to supress if value is null or 0?

steveniow
Contributor III
Contributor III
Author

yes - and after a bit of playing I have a slightly different problem.

It now seems to have worked but is displaying an'error in expression' value instead of the dimension label I was expecting.

A different formula but with the same idea has given the same output... as below...

Thanks for your help - really appreciated.

QVprob.PNG