topic Hiding fields in Multibox in QlikView

Hiding fields in Multibox

montubhardwaj — Wed, 21 Sep 2011 13:30:27 GMT

I have a multibox and a set of charts. The problem is when I select Chart1, Multibox should show all the fields(i.e. Accounts,Day, Month and Year). But as soon as I open/select Chart2/Chart3, the Multibox should exclude Accounts field from there and should show only Day, Month and Year.

Any Idea how to do this using Trigger/Macros?

PFA the sample attached.'

Regards,

Sharma

Hiding fields in Multibox

richard_chilvers — Wed, 21 Sep 2011 14:40:10 GMT

I do not think you are able to exclude the Accounts field from the Multibox.

But you can use triggers to Lock the Accounts field (when you open Chart2/3) so it cannot be changed. If this helps, you might need to remember that the field might also need to be Unlocked at some stage.

Regards

Hiding fields in Multibox

montubhardwaj — Wed, 21 Sep 2011 14:51:57 GMT

This is not helping me. I think the only way to do this is using macros. But I am not getting it all right

Hiding fields in Multibox

richard_chilvers — Wed, 21 Sep 2011 15:02:05 GMT

OK, sorry. Did the trigger not help ?

I have no experience of macros, I'm afraid.

Regards

Re: Hiding fields in Multibox

Wed, 21 Sep 2011 15:08:23 GMT

You can achieve the functionality using 2 separate multi-boxes. Create a variable and use it for show/hide condition. Create actions on charts that will modify the value of variable , there by enabling show/hide feature for account no. Please refer to the attached file for the implementation.

Regards

Pauljin

Re: Hiding fields in Multibox

richard_chilvers — Wed, 21 Sep 2011 16:20:56 GMT

That sounds a nice solution !

Hiding fields in Multibox

montubhardwaj — Thu, 22 Sep 2011 06:31:56 GMT

Hi Pauljin,

Thanks for looking into it. Yes it works but fine but in the process if we just click on other charts(single click), the value of variable change( I understand this as the trigger is based on "OnActive" state and if we just even click once, the charts get activated). So I was looking for some solution using macros which can identify the minimize/maximire state for charts and accrodingly set the value for variables.

For now, I will go ahead with this solution but will look for more stable solution.

Thanks a lot.

Regards,

Sharma

Re: Hiding fields in Multibox

Thu, 22 Sep 2011 07:45:32 GMT

Hi Sharma,

Please see the attached application if this is the solution that your looking for. Basically, I just revised Pauljin's file and added some macros and buttons. The macro that I include is that it activates the Chart object and Restore it. And the button has the Action to run that macro and also to hide the restored chart.

Just a tip if you will implement this:

Take note of the Layer of button and the chart.. The layer of the button should be higher than of thte Chart..

Regards,

Lester

*Let me know if I helped you solved your problem..

Hiding fields in Multibox

montubhardwaj — Thu, 22 Sep 2011 11:00:29 GMT

Thanks Lester for your response. Anyway, i have adopted the earlier technique.

Re: Hiding fields in Multibox

Wed, 22 May 2013 07:48:58 GMT

Hi Lesther,

I develped the same like what you have mentioned in the file

but my charts are not hiding based on the selection of the buttons......could you please guide the smae

Re: Hiding fields in Multibox

Wed, 22 May 2013 07:55:24 GMT

create variable vHide assign value is 0.

like vHide=0

then call this variable any where in coditional, then that field will be hide.

now select field and go to its conditional then write =vHide

Re: Hiding fields in Multibox

Wed, 22 May 2013 08:09:37 GMT

hi viswaranjan,

thnaks for your prompt reply

correct me f i'am wrong anywhere..i wanted to hide(entire chart ) based on the button ..not on a particular filed....

Regards

Imran khan

Re: Hiding fields in Multibox

Wed, 22 May 2013 12:53:36 GMT

If you wanted to hide(entire chart ) based on the button

create variable vHide assign value is 0.

like vHide=0

then take a button -->properties-->Action-->setvariable-->external-->set variable

then write variable = vHide

and value=0

now then go to properties of chart-->general-->In calculation condition

write code vHide