topic Re: Add-ons for transposed table (custom objects) in App Development

Add-ons for transposed table (custom objects)

sebHan — Mon, 27 Sep 2021 11:14:12 GMT

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.

Re: Add-ons for transposed table (custom objects)

abhijitnalekar — Mon, 27 Sep 2021 11:59:05 GMT

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.

Re: Add-ons for transposed table (custom objects)

sebHan — Mon, 27 Sep 2021 12:45:37 GMT

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.

Re: Add-ons for transposed table (custom objects)

abhijitnalekar — Mon, 27 Sep 2021 12:49:18 GMT

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

Re: Add-ons for transposed table (custom objects)

sebHan — Mon, 27 Sep 2021 12:54:33 GMT

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

Re: Add-ons for transposed table (custom objects)

abhijitnalekar — Mon, 27 Sep 2021 13:06:04 GMT

Hi @sebHan ,

First of all, disable the tabs property of the container

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