topic Button to clear expression in QlikView

Button to clear expression

Wed, 18 Jul 2012 17:07:26 GMT

I have an input box where you can enter a range of Shipment ID's (separated by commas) and a 'Go' button to search on the inputed values. I also have a 'Clear' button to clear the selection. This all works fine, but the previous Shipment IDs searched still shows up in the input field (even though the selection is cleared). Is there a way to clear the expression, and not just the selection?

My 'Go' button is a 'Select in Field' action:

='('&replace(ShipmentID,',','|')&')'

My 'Clear'button is just a 'Clear All' field. Does anyone have any suggestions?

Re: Button to clear expression

cesaraccardi — Wed, 18 Jul 2012 17:17:10 GMT

Hi,

You can add another action to the Clear button that sets the variable used in the inputbox (External / Set Variable), if you don't have constraints in the inputbox you can left the field "Value" for the action blank.

Re: Button to clear expression

Wed, 18 Jul 2012 17:24:46 GMT

Do you know what the search string would be?

Re: Button to clear expression

nagaiank — Wed, 18 Jul 2012 17:34:31 GMT

Leave the search string blank

Re: Button to clear expression

cesaraccardi — Wed, 18 Jul 2012 17:39:31 GMT

Yes, leave it blank... I said "Value" but its "Search string"

Re: Button to clear expression

Wed, 18 Jul 2012 17:41:18 GMT

Hi Rebeccad,

See the attached example. This is what Cesar Accardi Jr and krishnamoorthy is saying.

Hope this help,

Anosh

Re: Button to clear expression

Wed, 18 Jul 2012 17:44:31 GMT

Got it! Thank you for all your help everyone. That is exactly what Ineeded.

Re: Button to clear expression

Wed, 18 Jul 2012 21:17:50 GMT

Regarding the input field... is is possible to have multiple inputs (one per expression line) without using comma seperators? My box works just fine if you use commas between ID#'s, but if you copy/paste a few rows of Excel data into the expression, it doesn't run.

I thought about using multiple variables, but the user will likely need to input hundreds of Shipment ID's.

Re: Button to clear expression

cesaraccardi — Wed, 18 Jul 2012 21:21:16 GMT

Rebecca, for this requirement i think you could use a common listbox with all the available Shipment ID's and you can set the variable like

=GetFieldSelections(ShipmentID_filter)

Re: Button to clear expression

Wed, 18 Jul 2012 21:44:18 GMT

I tried that to no avail.

What about this idea... I could have a button to load an Excel document, then a macro to concatenate all the rows in Column A with comma separators, and then a macro to load that concatenated value into the input field. Is this even possible??

Re: Button to clear expression

Thu, 19 Jul 2012 12:00:00 GMT

Hi Rebeccad,

You can use this function in Go button Action:

='('&replace(trim(VProdID),' ','|')&')'

Please see the attached qvw. You just need to copy Ids from excel and past them in input box.

Hope this help,

Anosh

Re: Button to clear expression

Thu, 19 Jul 2012 12:59:28 GMT

That worked! Thanks!!