Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
krishna20
Valued Contributor

Hide and Show using Text or Button Object

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

1 Solution

Accepted Solutions
nehasmalekar
New Contributor III

Re: Hide and Show using Text or Button Object

Hello,

Please find attached file

Thanks

12 Replies
manojkulkarni
Valued Contributor II

Re: Hide and Show using Text or Button Object

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

krishna20
Valued Contributor

Re: Hide and Show using Text or Button Object

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

MVP
MVP

Re: Hide and Show using Text or Button Object

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
cabhijit
Valued Contributor

Re: Hide and Show using Text or Button Object

Look at the attached sample.

nehasmalekar
New Contributor III

Re: Hide and Show using Text or Button Object

Hello,

Please find attached file

Thanks

Not applicable

Re: Hide and Show using Text or Button Object

Hi,

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

krishna20
Valued Contributor

Re: Hide and Show using Text or Button Object

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

MVP
MVP

Re: Hide and Show using Text or Button Object

See attached

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: Hide and Show using Text or Button Object

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser