topic Re: On Button Click: Conditional Selection of Values in QlikView

On Button Click: Conditional Selection of Values

PhilippZiemer — Wed, 08 May 2013 07:35:18 GMT

Hello everyone,

I want to specifically select values on a condition, as soon as I press a button. I got two values to compare. I succeeded in selecting the set. But I couldn't find any suitable way to apply this set as search string to a field.

The set is given as following:

( { $<DATE = {"$(=Max(DATE))"}, INVENTORY_LAST_MOVEMENT = {">=50"}> } MATERIAL_ID )

Is there any way to concatenate this set to a string with "|" (e.g. ="MATERIAL_ID1" | "MATERIAL_ID2" | ...). Or is there a better work around to select these values via button click?

Thanks for any help

Philipp

Re: On Button Click: Conditional Selection of Values

kumarnatarajan — Wed, 08 May 2013 11:21:48 GMT

Hi,

Try This

EX: '(' & Concat(DISTINCT { $<DATE = {"$(=Max(DATE))"}, INVENTORY_LAST_MOVEMENT = {">=50"}> } '"'&MATERIAL_ID&'"','|') & ')'

Re: On Button Click: Conditional Selection of Values

PhilippZiemer — Wed, 08 May 2013 11:23:48 GMT

Thx, that was what I was looking for