Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
Contributor

Using a button to show/hide different charts


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.

Tags (1)
7 Replies
rustyfishbones
Honored Contributor II

Re: Using a button to show/hide different charts

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
Honored Contributor II

Re: Using a button to show/hide different charts

sebastiandperei
Valued Contributor

Re: Using a button to show/hide different charts

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
Contributor

Re: Using a button to show/hide different charts

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

zagzebski
Contributor

Re: Using a button to show/hide different charts

Will definately try that site,thanks.

Re: Using a button to show/hide different charts

See this video tutorial: Show and Hide Multiple Objects


talk is cheap, supply exceeds demand
ngulliver
Valued Contributor III

Re: Using a button to show/hide different charts

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

Community Browser