topic Selection with buttons in QlikView

Selection with buttons

Thu, 22 Sep 2011 13:21:11 GMT

hi community,

unfortunately I have not found any suitable solution to my problem here in the community.

I would like to make a selection in a table (diagram) with a button. The selection should select all records whose value formula (column) is greater than 10.

How can I implement in the best way ?

Am grateful for any help.

Best Regards,

Selection with buttons

Fri, 23 Sep 2011 07:37:19 GMT

hi community,

can nobody help me with my question ?

Best Regards,

Selection with buttons

Fri, 23 Sep 2011 10:14:14 GMT

Hi,

declare a variable with value 10. lett's call the variable v_limit.

create a button and on actions tab, select "Set variable" with the name of the variable and set the value with this expression : if($(v_limit)=10,0,10)

By cliking on teh button, the value will be either 10 or 0.

Now modify the expression of your column : if(value>=$(v_limit), value)

and select the "suppress zero-values" in presentation tab of your pivot table.

hope this helps

Gilles

Selection with buttons

Wed, 28 Sep 2011 15:22:27 GMT

Thank you very much