topic Re: To pick the value in the variable in QlikView

To pick the value in the variable

Anonymous — Wed, 26 Sep 2012 07:54:50 GMT

Hi Masters,

I have a table in which there are two columns Pipeline Scenario Date, Pipeline Scenario Categories.

In front end I have Pipeline scenario Categories displayed in the list box

I want when the user select in any of the pipeline scenario categories the pipeline scenario date associated with that category will get store in a variable

and that variable il use in my set

Appreciate your help

Thanks in advance

Re: To pick the value in the variable

Wed, 26 Sep 2012 08:06:00 GMT

Hi,

Create a variable and use GetCurrentSelections(Fieldname) in definition. Fieldname must be based on Pipeline Scenario Categories.

Regards,

Janzen

Re: To pick the value in the variable

jonathandienst — Wed, 26 Sep 2012 08:07:50 GMT

Use this in the script:

Set vScenDate = =Max([Pipeline Scenario Date]);

Now if you select a pipeline scenario, then the vScenDate will contain the corresponding date.

You could also use Min instead of Max. If you want the variable to contain nothing when no scenario category is selected, then change Max to Only.

Regards

Jonathan

The double = sign is not a typo

Re: To pick the value in the variable

Anonymous — Wed, 26 Sep 2012 08:25:16 GMT

Thanks Jonathan

What a answer thanks for the quick response tooo:)