how to mention alternate state in getfieldselection() function?

[#1]

hi,

i am using getfieldselections() function in chart title to show dynamic changing country values.

=GetFieldSelections(country)

but  i want to show country values which are present in another state called "Primary''.

Is it Possible?or any other solutions?

[qlikmsg4u]

there is no functionality similar to this in qlikview

GetFieldSelections(<Primary> Country)

Instead you can use

=Concat({[Primary]} DISTINCT Country,'|')

[sunny_talwar]

You can specify alternate state in GetFieldSelections() function starting with QV 11.20 SR8. If you have anything later than that, then you can try this:

GetFieldSelections(FieldName, ',', 100, 'AlternateStateName')

[qlikmsg4u]

Thanks sunindia

[sunny_talwar]

No problem