Using a button to show/hide different charts

[zagzebski]

I have a container with 2 summarization tables

Revenue

Expense

Through some sort of automation I want the ability to click on a button and hide each of these summary tables and replace with detail tables. Then get the summarization tables back if I click the button again.

I am just confused on how to do it when it is within containers.

[rustyfishbones]

I think it would be better to have the Container with the 2 Summaerization tables and a Details Table thats only shown when you click a button

create a variable called vShowHide = 1

create a text object and add an action > external > set variable vShowHide = IF($(vShowHide) = 1,0,1)

On the Layout tab of the Detailed Chart add IF($(vShowHide) = 1,0,1) and that should do it.

Visit my Youtube Channel Rustyfishbones, and you will find some videos that will help you do this

[rustyfishbones]

this video could help

Qlikview Design Variable by RFB 86 - YouTube

and this maybe

Qlikview Advanced Charts with Conditional Variables by RFB 113 - YouTube

[sebastiandperei]

Do you use the same type of object to show each summarization and their detail?

If yes, you could hide the dimmentions and expressions that are in detail and not in de summarization tables.

Also, you could try with no using a container. Make two non-linked tables with the following fields and values:

Table 1, field "TableName", values "Expense" and "Revenue"

Table 2, field "TableType", values "Summarization" and "Detail"

Now, the show conditions of each table will be:

Revenue Summarization. : TableName='Revenue" and TableType="Summarization"

Revenue Detail. : TableName='Revenue" and TableType="Detail"

Expense Summarization. : TableName='Expense " and TableType="Summarization"

Expense Detail. : TableName='Expense " and TableType="Detail"

You could put the list box with "TableName" field as the container likes, and create a button to select "Detail" or "Summarization" with the following action:

Make a Selection

Field: TableType

Value: If (TableType='Summarization', 'Detail','Summarization')

Dont forget to mark both fields as "Always one selected value"

(sorry for my bad english)

[zagzebski]

Thanks for the feedback. I am going to look this over.

[zagzebski]

Will definately try that site,thanks.

[Gysbert_Wassenaar]

See this video tutorial: Show and Hide Multiple Objects

[ngulliver]

Hi, Zagzebski.

If you are show/hiding charts is there a need to have these in containers at all ?

There is a good blog on buttons with some working examples:

http://www.quickintelligence.co.uk/qlikview-buttons/

Regards,

Neil