How to hide the null values dimension from table box.

[srinivas91k]

Hi, Can anyone help to hide a dimension if all the fields values have nulls...

For Example:

------------------------------

Based on the product _group selection, promotion_code is not available.

Promotion_code:

-------------------------

NULL

NULL

NULL

So,  I want to hide this dimension in my table box , If selected product_group having the promotion_code values Then only it should be visible.

Thanks In Advance....

[Brett_Bleess]

I do not see anything in the Help related to the object that would allow for this, only at row level:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Table_Box.htm

In order to remove dimension, that would likely take a macro of some sort, but that is going to have a lot of implications on performance etc., so I would not recommend it, would likely consider trying to handle things in the scrip via a flag of some sort to see if that might work.  

You can look around the Design Blog area to see if you can find something there that may give you some ideas if you have not found anything in prior Community posts:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

The only other area where there might be something would be the following:

https://community.qlik.com/t5/QlikView-Documents/tkb-p/qlikview-documents

Regards,
Brett