Add-ons for transposed table (custom objects)

[sebHan]

Hey! I'm currently developing an app, where I've used the custom objects "transposedTable". However, for this custom table I would like to add a statement, that it only shows if I have chosen an object in one of my filters.

I have done this for several of my other graphs under add-ons data handling with the statement:

Count(distinct BU)=1 or count(distinct BU) = 2 or count(distinct BU) = 3, otherwise it shows the text "Choose BU in order to show graph".

Is there a way to do this for custom objects, as they do not contain add-on.

[abhijitnalekar · Accepted solution]

Hi @sebHan,

Use container object and add your custom object in the container and apply the same condition in the show hide property of container.

[sebHan]

Thanks work completely fine! Is there a way to show add a text box to show if nothing has been selected.

I have tried adding a text box to master items and set the show condition to if count(distinct BU) = 0.

This however, does not work. 

[abhijitnalekar]

Sure. you can add the same text box in the container and apply the reverse condition. 

[sebHan]

Thanks still fairly new to qlik sense, How would that condition look like? Because the "count(distinct BU) = 0" does not work 😕

[abhijitnalekar]

Hi @sebHan ,

First of all, disable the tabs property of the container

and use GetSelectedCount(BU)=0 condition for text object