topic Re: Show Hide for Multiple Objects in Qlikview in QlikView

Show Hide for Multiple Objects in Qlikview

Chanty4u — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a requirement loveisfail‌ stalwar1‌

I have a list box and a Table Object.

Initial value of Variable vSelectTextBox =0

I have used the action to show the List box =if(vSelectTextBox = 0, 1, 0) and then Used the trigger On any select to Reset the variable

vSelectTextBox=0\.

After Selecting the value in the List box I need to Select the value from Table box and Upon selection the value in Table box the Table box needs to disappeared.

Could you please suggest if there is any Solution available for achieving this.

Thanks,

Chanty

Re: Show Hide for Multiple Objects in Qlikview

Anil_Babu_Samineni — Thu, 01 Feb 2018 17:08:22 GMT

Looks like achievable, Will you able to provide QVW?

Re: Show Hide for Multiple Objects in Qlikview

Anil_Babu_Samineni — Thu, 01 Feb 2018 17:25:51 GMT

PFA

Re: Show Hide for Multiple Objects in Qlikview

Chanty4u — Thu, 01 Feb 2018 17:29:52 GMT

Hi Anil,

Attachment is missing.

Re: Show Hide for Multiple Objects in Qlikview

Chanty4u — Thu, 01 Feb 2018 17:49:01 GMT

Hi All,

I have attached a sample.

Could please me out on this.

Re: Show Hide for Multiple Objects in Qlikview

sunny_talwar — Thu, 01 Feb 2018 17:53:52 GMT

Don't see any table box object?

Re: Show Hide for Multiple Objects in Qlikview

Chanty4u — Thu, 01 Feb 2018 18:28:04 GMT

sorry sunny its stright table stalwar1‌

Re: Show Hide for Multiple Objects in Qlikview

swuehl — Thu, 01 Feb 2018 18:36:03 GMT

After the selecting a value in the listbox, you want to do what exactely?

Note that you are using the same field / dimension in all three objects, so if you select a value in the list box, selecting in the table chart or bar chart will just remove the selection in the field again.

Can you give a detailed step by step explanation what you want to get when doing what actions?

Re: Show Hide for Multiple Objects in Qlikview

sunny_talwar — Thu, 01 Feb 2018 18:36:19 GMT

So, this is what you are trying to do...

1) Select a region/ or multiple regions in list box (nothing happens)

2) Select/deselect region from straight table and straight table disappears?

So, is the logic that if you select something in the straight table, it disappears or does it disappears on the second time you select in region?

Re: Show Hide for Multiple Objects in Qlikview

Chanty4u — Thu, 01 Feb 2018 18:48:34 GMT

Hi Sunny,

This how I want to Implement.

Select a Value in the region --> The List Box with Region should disappear and Table should remain as it is.

Select a value in the Table --> The Chart should be displayed and the table should Disappear.

Upon Clearing all the Selections I should only see the chart others should disappaer.

Re: Show Hide for Multiple Objects in Qlikview

sunny_talwar — Thu, 01 Feb 2018 18:50:23 GMT

Have you thought about using an alternate state or is that ruled out already

Re: Show Hide for Multiple Objects in Qlikview

Chanty4u — Thu, 01 Feb 2018 18:54:23 GMT

i tried now but still no luck.

created two states and added one state to list box and other for stright table

i m in right way? if not give a route

Re: Show Hide for Multiple Objects in Qlikview

Chanty4u — Thu, 01 Feb 2018 19:01:46 GMT

could you try in my sample and attach?

am missing some where else

Re: Show Hide for Multiple Objects in Qlikview

Chanty4u — Thu, 01 Feb 2018 19:35:37 GMT

Hi,

Finally achieved using Onselect and onChange Trigger on Region Field.

Note: I have achieved in Original app.

Anyway thanks for your replies.