How to hide the null values dimension from table box.

srinivas91k — Sat, 16 Nov 2024 18:12:37 GMT

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

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

Re: How to hide the null values dimension from table box.

Brett_Bleess — Thu, 03 Sep 2020 13:12:37 GMT

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

topic How to hide the null values dimension from table box. in QlikView

How to hide the null values dimension from table box.

Re: How to hide the null values dimension from table box.