Qlik Sense: Suppress column with no value

[gerald_lebret]

Hi,

I have a pivot table / table with about 50 columns. I would like Qlik Sense to suppress a column when it has no value in it.

I have looked and it is apparently possible in qlikview but cannot find the solution for qlik sense.

Can anyone help?

Thank you.

Gerald

[Chanty4u]

in data handling tab

un check the supress null value

[gerald_lebret]

Hello Chanty 4u,

If it was that easy... I tried but it does not work!!

[Chanty4u]

share sample app

[MK9885]

If it is a dimension, simple uncheck 'Display Null Values'??

You want to suppress a dimension or measure?

What is your expression?

[gerald_lebret]

Hello S Khan,

I did want to suppress a dimension, not a measure.

After spending too much time, I found a work-around.

Thank you.

[gerald_lebret]

Hi,

Thanks for your help. I found a work-around.

[Chanty4u]

great meanwhile share your work around and close the thread as well it will  help others

[pradosh_thakur]

you should share your idea my friend . it will help others. please share the workaround and close the thread.

[gerald_lebret]

Hello Pradosh Thakur,

I did not mention anything become I did some adjustments in the script load...