topic Re: Show Hide column based on a button click. in QlikView

Show Hide column based on a button click.

Thu, 26 Jun 2014 06:34:43 GMT

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.

Paramita

Thu, 26 Jun 2014 06:41:40 GMT

Use a variable to do this.

Create a variable say vCust.

Create 2 buttons

1st button

'Show Customers'

On the Action, choose External-> Set Variable -> 1

Goto the layout table and go to conditional and say $(vCust)=0

2nd button

'Hide Customers'

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

jagan — Thu, 26 Jun 2014 06:43:03 GMT

Hi,

Use Straight table and add Customer dimension along with other dimensions.

Create a variable using Settings Menu -> Variable Overview and create a variable

vShowCustomer=1

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

=vShowCustomer

Hope this helps you.

Regards,

Jagan.

amit_saini — Thu, 26 Jun 2014 06:43:16 GMT

Hi Paramita,

This link may help you:

Thanks,

Anonymous — Thu, 26 Jun 2014 06:50:52 GMT

See attachment