topic Macro to toggle between straight tables in QlikView

Macro to toggle between straight tables

ivandrago — Thu, 26 Aug 2010 22:43:05 GMT

Hi, Is it possible to have a macro which when you click on it, it toggles between different straight tables? So basically hides one then another one appears with in the same place?

Thanks

Macro to toggle between straight tables

Thu, 26 Aug 2010 23:07:22 GMT

Hi Drago, enclosed you will find and example that solves your question. Pay special attention to:

- The Variable is visible

- The action within the toggle button. Which basically toggles the value on the variable.

- The property show->conditional under the Layout tab in both tables.

Regards

Macro to toggle between straight tables

ivandrago — Thu, 26 Aug 2010 23:19:47 GMT

Nice tip Ivan, but the the two tables I want to toggle against one is a pivot and one is a straight table with different field names, would this be possible?

Macro to toggle between straight tables

Fri, 27 Aug 2010 14:40:47 GMT

Hi Drago, as you can see in the qvw enclosed, it doesn't really matter the type of chart or dimensions within each chart, the logic behind is done in the show conditional option under the layout tab.

Hope this helps.

Regards