topic Selected value as variable in QlikView

Selected value as variable

Fri, 12 Jun 2009 22:14:03 GMT

Hi *,

is it possible to use the value of a selected field as value.

eg. I have the a year field that contains years from 2000 - 2009.

I'd like to use the select field e.g. 2006 as a variable.

Thanks

Selected value as variable

Fri, 12 Jun 2009 22:31:33 GMT

I think you can do that in macro

Suppose you have one field ref year value and you want to make receive year same as ref year.

Set Z = ActiveDocument.Fields("Reference Year")
ActiveDocument.Fields("Receive Year").Selectvalues Z.GetSelectedValues()

aslo ref the API guide

Talha

Selected value as variable

Fri, 12 Jun 2009 22:59:45 GMT

You can also do this in a variable by adding the following to the variable declaration:

=GetFieldSelections("ReceiveYear")

The only potential issue is that it does some rather odd things when more than one selection is made from the same field (when I say odd, it does make sense, but it seems odd).

Regards,

Nigel.

Selected value as variable

Anonymous — Fri, 12 Jun 2009 23:36:20 GMT

Not clear what exactly you want. If follow your question literally, the answer is to createa variable, e.g. vSelectedYear, and define it as =Year