Discussion Board for collaboration related to QlikView App Development.
I want to show/hide a column in a table based on a button.
My requirement is -
The button Text will be 'Show Customers' and when the user clicks, it should add customers to the table.
Once the column is visible, the button Text should change to 'Hide Customers'. And when the user clicks, it should hide the Customers column.
Is this possible ? Please advise.
Use Straight table and add Customer dimension along with other dimensions.
Create a variable using Settings Menu -> Variable Overview and create a variable
Now Create button and
Button Properties -> General -> Text -> Give If(vShowCustomer = 1, 'Hide Customer', 'Show Customer') ->
Actions -> Add-> External -> Set Variable -> Variable = vShowCustomer
Value = =If(vShowCustomer =1, 0, 1)
Now in Straight table Properties -> Click on Customer Dimension -> Select Enable Conditional option and give
Hope this helps you.
View solution in original post
Use a variable to do this.
Create a variable say vCust.
Create 2 buttons
On the Action, choose External-> Set Variable -> 1
Goto the layout table and go to conditional and say $(vCust)=0
on the action, choose External -> Set Variable -> 0
Goto the layout tab and go to conditional and say $(vCust)=1
in your chart, go to the dimension , click on enable and say $(vCust)=1
This link may help you:
Re: Re: Button to Show/Hide a Calculated Dimension