topic Re: Using a button to deslect a value in QlikView

Using a button to deslect a value

Thu, 05 Jul 2012 21:01:15 GMT

Hi -

I have a very long list of values representing the profit at various accounts rangeing from large negative to large positive values.

I am trying to create a button object to select all values for profit except those accounts with a profit of $0.00.

I tried the Select Excluded action with the following expression: =profit=0

I also tried the Select in Field action with the following expression: =profit<>0

Neither of these seem to do anything.

Thanks,

Mike

Anonymous — Fri, 06 Jul 2012 04:02:09 GMT

Hi Mike,

Try creating a Select In Field action.

Set the Field to Profit and set the search expression to: <0>0

This should select all but 0

Fri, 06 Jul 2012 10:21:45 GMT

Dear,

Mike.

Kindly find the attachment with example.

Thanks,

Mukram