topic Re: Hide List Box in QlikView

Hide List Box

aveeeeeee7en — Mon, 24 Mar 2014 08:51:20 GMT

Hi Community

I have a 8 Distinct Calculated List Boxes.

When I use Filters Suppose I Select the Name ABCD, the Associated and Possible data is Filtering out in the 5 List Boxes

and the remaining 3 List Boxes has no data associated with that selection.

What I need is to Hide those 3 non-associated List Boxes.

Is there any workaround???

Regards

Aviral Nag

Re: Hide List Box

alexandros17 — Mon, 24 Mar 2014 08:54:42 GMT

you can do it with a button, define a variable and set the conditional visibility property for the list box (i.e. myVar=1)

then with the button trigger the value of variable

Re: Hide List Box

Mon, 24 Mar 2014 09:03:09 GMT

I would set the list boxes to be conditionally shown when GetPossibleCount(appropriate listbox)> 0

Re: Hide List Box

Mon, 24 Mar 2014 09:07:52 GMT

Hi,

Just make remaining 3 list boxes conditional and give the condition as:

GetSelectedCount([Your Fieldname]) >0

Replace "Your Field name" with your actual field name. You can use it for multiple fields.

Hope this helps!

Edit :

Sorry, I read your requirement incorrectly. It should be

GetSelectedCount([Your Fieldname]) <1

Re: Hide List Box

Mon, 24 Mar 2014 09:07:55 GMT

Hiii Nag

Simply use getpossiblecount(particular listbox)=1

Re: Hide List Box

aveeeeeee7en — Mon, 24 Mar 2014 09:42:22 GMT

Thanks All for the Quick Reply Guys.

Can anyone provide me the sample qvw.

Re: Re: Hide List Box

Mon, 24 Mar 2014 09:54:50 GMT

Hi,

Might be something like attached.

Re: Hide List Box

aveeeeeee7en — Mon, 24 Mar 2014 09:56:50 GMT

Thanks Alessandro for your reply.

I want to hide List Boxes if there is no data availability. So, for this button doesn't don't work.

I want to do this by doing GetPossiblecount() . Do you have any solution for it.

Re: Re: Re: Hide List Box

aveeeeeee7en — Mon, 24 Mar 2014 10:03:53 GMT

Hi Shyamal thanks for the reply

Please see the Attchment - what I actually want???

Re: Hide List Box

mangalsk — Mon, 24 Mar 2014 10:23:15 GMT

Hello,

Find the attachment.

I have used condition which works as per you requirement where sum field is hidden if no data.

Re: Re: Re: Hide List Box

aveeeeeee7en — Mon, 24 Mar 2014 10:28:57 GMT

Thanks Magal for your reply

I have a conditional list box which has Concatenated fields which contains text as well as Numbers and also it has Picture in it. So, it can't be possible with the Sum condition. Any other option.

Re: Hide List Box

Mon, 24 Mar 2014 10:30:41 GMT

Can you post your sample data?

Re: Re: Hide List Box

aveeeeeee7en — Mon, 24 Mar 2014 13:47:46 GMT

See the Attachment.

Re: Hide List Box

Mon, 24 Mar 2014 15:34:31 GMT

use layout condition as below

=if(GetSelectedCount(Name3)>0,if(len(if(Level=2,Name&chr(13)&emp_location&chr(13)&Department))>0,1,0),1)