topic Re: Using a button to show/hide different charts in QlikView

Using a button to show/hide different charts

zagzebski — Sat, 26 Oct 2013 19:55:27 GMT

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.

Re: Using a button to show/hide different charts

rustyfishbones — Sat, 26 Oct 2013 20:26:05 GMT

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

Re: Using a button to show/hide different charts

rustyfishbones — Sat, 26 Oct 2013 20:28:02 GMT

this video could help

Qlikview Design Variable by RFB 86 - YouTube

and this maybe

Qlikview Advanced Charts with Conditional Variables by RFB 113 - YouTube

Re: Using a button to show/hide different charts

sebastiandperei — Sat, 26 Oct 2013 21:37:29 GMT

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)

Re: Using a button to show/hide different charts

zagzebski — Sun, 27 Oct 2013 00:05:09 GMT

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

Re: Using a button to show/hide different charts

zagzebski — Sun, 27 Oct 2013 00:05:35 GMT

Will definately try that site,thanks.

Re: Using a button to show/hide different charts

Gysbert_Wassenaar — Mon, 28 Oct 2013 18:01:55 GMT

See this video tutorial: Show and Hide Multiple Objects

Re: Using a button to show/hide different charts

ngulliver — Wed, 30 Oct 2013 08:35:55 GMT

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