topic Re: Enable button Only when one distinct value is selected in table in QlikView

Enable button Only when one distinct value is selected in table

Mon, 15 Apr 2013 10:26:17 GMT

Hi all,

I require a conditional statement to enable a button when one distinct value is selected in a straight/pivot table?

E.g.

table A:

client_num expression

1 25

2 30

3 35

1 40

Button is disabled by default. However if the user selects one distinct value in field 'client_num' the button should switch to enabled. e.g. if a user selects client_num '1' the table should have 2 rows but since it contains one distinct value (i.e. 1) the button should switch to enabled.

I appreciate any assistance!

Re: Enable button Only when one distinct value is selected in table

kaushiknsolanki — Mon, 15 Apr 2013 12:08:17 GMT

Try this expression.

=if(getselectedcount(client_num)=1,1,0)

Use this in layout property of the button to hide and show the button.

Regards,

Kaushik Solanki

Message was edited by: Kaushik Solanki

Re: Enable button Only when one distinct value is selected in table

kaushiknsolanki — Mon, 15 Apr 2013 12:09:36 GMT

Hi,

Ignore above post.

Use this

=if(getselectedcount(client_num)=1,1,0)

Use this expression in layout tab of the button properties to hide and show the button.

Rergards,

Kaushik Solanki

Re: Enable button Only when one distinct value is selected in table

Mon, 15 Apr 2013 12:18:49 GMT

Button -> Properties -> General -> Enable condition: =if(only(client_num)=1, 1, 0)

Re: Enable button Only when one distinct value is selected in table

Mon, 15 Apr 2013 13:18:05 GMT

Thanks Kaushik, however your solution will only display the button when there is only one row selected in the table. I need the button to show when there is one distinct value selected e.g. if client_num '1' is selected in my example table two rows would be displayed..in this instance I need the button to be displayed (note some clients may have one or multiple rows). Any other idea?

Cheers

Re: Enable button Only when one distinct value is selected in table

Mon, 15 Apr 2013 13:21:32 GMT

Guys, I have found the answer...I just need to use :

=if(only(client_num ), 1, 0) to enable/disable the button.

Thanks again

Re: Enable button Only when one distinct value is selected in table

kaushiknsolanki — Mon, 15 Apr 2013 13:33:13 GMT

Hi,

have a look at the attached example.

Regards,

Kaushik Solanki