topic Re: Variable storing a value based on island table in QlikView

Variable storing a value based on island table

Anonymous — Thu, 21 May 2015 15:06:20 GMT

Hello QlikView Gurus,

I am troubleshooting an existing application and have come across this scenario:-

The datamodel along with facts and dimension tables contains an Island table that has a single column: _Name.

This column has values: Sales,Flow,Asset

A list box is used in the dashboard to show the above values from this field (_Name)

There is a line chart that has two dimensions: Month and ='$(vCycDim)'.

Now based on the selection in the list box (or even a multibox having _Name field), the value for variable vCycDim gets updated.

E.g if list box has 'Sales' selected, the variable vCycDim gets the value 'Sales'. In the Variable Overview window I only see the string 'Sales' as the value for this variable. There is no expression.

I am aware of GetFieldSelections function but I am not able to find out how the variable value is assigned with a selection in listbox or multibox? There is no macro or Action(as in text box or button object) that is assigning the value. Not sure how the variable is picking the value?

I am sure this is a very common approach and hope my explanation is clear.

Any ideas?

Thanks

Nakul

Re: Variable storing a value based on island table

sunny_talwar — Thu, 21 May 2015 15:10:02 GMT

If your variable is defined with GetFieldSelections, then the function itself is telling the variable to use whatever is selected as a vCycDim. My guess is that the list box it is linked to has Always One Selected Value option selected to make sure that user are unable to select more than one value at a time.

Re: Variable storing a value based on island table

awhitfield — Thu, 21 May 2015 15:14:59 GMT

Hi,

What's the definitions of the variable vCycDim?

Andy

Re: Variable storing a value based on island table

Gysbert_Wassenaar — Thu, 21 May 2015 15:16:43 GMT

Check the field triggers on the Triggers tab of the Document Properties window. It sounds like your variable is set by an action assigned to the OnSelect of one of the fields.

Re: Variable storing a value based on island table

Anonymous — Thu, 21 May 2015 15:17:50 GMT

That's right, the list box has Always One Selected Value. In the variable overview window, since this variable always has a string value, I am not sure what function was originally defined. If I were to create a new variable, vCycDim1 (that stores the same set of values), what should the approach be?

Re: Variable storing a value based on island table

sunny_talwar — Thu, 21 May 2015 15:20:15 GMT

You can use do it bunch of ways:

vCycDim1 = GetFieldSelections(ListBoxField) or

vCycDim1 = Concat(DISTINCT ListBoxField) or

vCycDim1 = Only(ListBoxField)

I think all of the above should work.

Best,

Sunny

Re: Variable storing a value based on island table

Anonymous — Thu, 21 May 2015 15:20:53 GMT

It just shows up with a string value (eg: Sales)

Re: Variable storing a value based on island table

Anonymous — Thu, 21 May 2015 15:22:59 GMT

Yes! I found a FieldEvent Trigger for this field that 'OnSelect' assigns the value to the variable. I did check the triggers tab before but must have missed it! Thanks Gysbert.