topic Suppress a dimension label when expression is null in QlikView

Suppress a dimension label when expression is null

steveniow — Tue, 10 Nov 2015 13:57:43 GMT

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

Re: Suppress a dimension label when expression is null

sunny_talwar — Tue, 10 Nov 2015 14:39:34 GMT

What is the expression that you are using?

Re: Suppress a dimension label when expression is null

Mark_Little — Tue, 10 Nov 2015 14:59:48 GMT

Hi,

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

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

Mark

Re: Suppress a dimension label when expression is null

stigchel — Tue, 10 Nov 2015 15:28:33 GMT

Maybe these threads are helpfull as well

Getting the most out of a Trellis bar chart, some tricks

hide dimension values in trellis

Re: Suppress a dimension label when expression is null

steveniow — Tue, 10 Nov 2015 15:31:40 GMT

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.

Re: Suppress a dimension label when expression is null

steveniow — Tue, 10 Nov 2015 15:36:52 GMT

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

Re: Suppress a dimension label when expression is null

Tue, 10 Nov 2015 15:38:23 GMT

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

Re: Suppress a dimension label when expression is null

steveniow — Tue, 10 Nov 2015 16:18:12 GMT

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.