topic Re: Help on Button? in QlikView

Help on Button?

dmohanty — Thu, 24 Jul 2014 18:35:31 GMT

Hi All,

I need some help in Buttons.

Requirement:

First Home page should have 3 Buttons. If I click on any one button, the required sheet will be activated (I can do)
But while on First Home page, rest 3 Sheets will be hidden. When Clicked on 1st button, the 1st sheet will be activated along with Home page and rest 2 will be hidden. Similarly for next two buttons and sheets(HOW TO DO THIS?)
When a sheet is activated, it should have a Button to navigate to Main page back (I can do)
But when the main page is displayed again, all the next sheets again go back to hidden (HOW TO DO THIS?)

Can anyone show me a sample example on this? Or any better alternate way to do this?

Regards!!!

Thu, 24 Jul 2014 18:53:04 GMT

PFA sample QVW.

Hope this helps.

Thanks

Sabal

maxgro — Thu, 24 Jul 2014 18:58:19 GMT

- define a variable vshow (0 = show main,1 = show first sheet, .....)

- in every sheet go to General --> Show sheet --> Conditional and add an expression

=$(vShow)=0 (this is for main, adapt to other sheets)

- add the buttons with action as image

see attachment

dmohanty — Thu, 24 Jul 2014 19:15:02 GMT

Thanks a ton Sabal for this quick help. Its really appreciated. I got the concept!!!

dmohanty — Thu, 24 Jul 2014 19:15:37 GMT

Thanks a ton Massimo for this explanation!!!.

Its really appreciated. I learnt the concept.