Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
this video could help
Qlikview Design Variable by RFB 86 - YouTube
and this maybe
Qlikview Advanced Charts with Conditional Variables by RFB 113 - YouTube
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)
Thanks for the feedback. I am going to look this over.
Will definately try that site,thanks.
See this video tutorial: Show and Hide Multiple Objects
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