topic Re: Hide and Show using Text or Button Object in QlikView

Hide and Show using Text or Button Object

krishna20 — Fri, 13 Feb 2015 05:44:42 GMT

Hi Friends,

Using a Single text or button object how can we do hide and show of three tables and three charts. For Eg; By Default Produt wise details table and graph should be shown. When clicks on the text or button object Products should hide and Portals should be appear.On another click Business Source Details should be shown. I understood that we need to apply" If else If" condition over here.I tried much but no luck. In the image i'm showing with container.It's not required.Just normal hide and show i'm expecting. By using container we can't achieve this.

Please find the below attachment for clear understanding highlighted with colors. Please anyone suggest me how to achieve it.

Regards

Krishna

Re: Hide and Show using Text or Button Object

manojkulkarni — Fri, 13 Feb 2015 05:54:28 GMT

use a variable to indicate show/hide condition and then use it in the action of textbox. Same variable will be used in Show condition of Chart. Pls check attached file

Re: Hide and Show using Text or Button Object

krishna20 — Fri, 13 Feb 2015 05:59:48 GMT

Hi manoj,

Thank you for your quick reply. This is not what i'm looking for.Please read my requirement. I'm asking about three tables and three charts.

Regards

Krishna

Re: Hide and Show using Text or Button Object

jonathandienst — Fri, 13 Feb 2015 06:02:28 GMT

Set up the button action to set a variable - lets call it vState for this example. Set the action expression to be:

=Mod(vState + 1, 3)

Then set the conditional display for each chart and table to be

=vState = 0 ( for Products )

=vState = 1 ( for Portals )

=vState = 2 ( for Business Source Details )

HTH

Jonathan

Re: Hide and Show using Text or Button Object

AbhijitBansode — Fri, 13 Feb 2015 06:04:54 GMT

Look at the attached sample.

Re: Hide and Show using Text or Button Object

Anonymous — Fri, 13 Feb 2015 06:29:17 GMT

Hello,

Please find attached file

Thanks

Re: Hide and Show using Text or Button Object

Fri, 13 Feb 2015 06:51:49 GMT

Hi,

PFA, I have tried it with two objects.hope this may help to fix your issue.

Re: Hide and Show using Text or Button Object

krishna20 — Fri, 13 Feb 2015 07:52:10 GMT

Hi,

This =Mod(vState + 1, 3) is not working. I don't know why. I have checked with both button and text object. The objects are hiding but not showing when clicks on the button.

I tried with the below conditions in the layout tab as

=if(vstate=1,1,0)

and

=vstate=0

Please, let me know what may be the reason

Regards

Krishna

Re: Hide and Show using Text or Button Object

jonathandienst — Fri, 13 Feb 2015 08:19:44 GMT

See attached

Re: Hide and Show using Text or Button Object

jonathandienst — Fri, 13 Feb 2015 08:21:01 GMT

Field names and variable names are case sensitive in QV, so vstate and vState are two different variables.

Re: Hide and Show using Text or Button Object

Anonymous — Fri, 13 Feb 2015 08:30:42 GMT

try abc.qvw...its the same as ur requirement.

Thanks

Re: Hide and Show using Text or Button Object

krishna20 — Fri, 13 Feb 2015 08:33:06 GMT

Hi Neha,

I Tried based on that only. Its working for you and not me.. Don't know.. I have applied the same things which you have used.

Regards

Krishna

Re: Hide and Show using Text or Button Object

Anonymous — Fri, 13 Feb 2015 08:46:05 GMT

Hello,

Can u share ur sample qvw.

Thanks