topic Re: Help plaese! with 2 tables and variables to control which table is displayed in QlikView

Help plaese! with 2 tables and variables to control which table is displayed

helen_pip — Fri, 07 Jun 2013 13:25:48 GMT

Hello

I have one page in Qlikview

I then have 3 buttons within the page

-All

-Main

-Eye

When I currently click on All, a table appears. This is easy for me to do with a variable

However I have now been asked to split the table into Adult or Paediatrics

I ahve split out all my data, but need to know how I can noe select the All button and then be able to show the Adult table by clicking on a button and then show the Paediatrics table when I click on the button

I wanted to refrain from using restore the objects, as they seem to store themselves in the corner of my page

Any suggestions

Much appreciated

Thanks

Helen

Re: Help plaese! with 2 tables and variables to control which table is displayed

alexandros17 — Fri, 07 Jun 2013 13:35:51 GMT

In the layout tab of an object you can set conditional condition to show the object.

So you can use only 1 button that change from All -> Adult -> Pediatric or

use 3 buttons (one upon the other) that hide / show with the same logic

in the layout the condition is set by a variable

Re: Help plaese! with 2 tables and variables to control which table is displayed

helen_pip — Fri, 07 Jun 2013 13:40:25 GMT

Hello

Thank you for your response

I completely forgot to mention that my table is very static and is built off an in_line table and therefore I am very reliant upon the actual Object ID instead

My data will not flex with list boxes

Do you have nay examples at hand?

Thanks

Helen

Re: Help plaese! with 2 tables and variables to control which table is displayed

Sokkorn — Sun, 09 Jun 2013 05:10:27 GMT

Hi Helen,

Check example here

Regards,

Sokkorn

Re: Help plaese! with 2 tables and variables to control which table is displayed

rustyfishbones — Sun, 09 Jun 2013 10:53:40 GMT

This video will show you how it can be done

http://www.youtube.com/watch?v=-eckykbCTh4

Let me know if that helps