GetFieldSelections for versions below SR8

[sifatnabil]

Hi all,

Our QlikView server won't be upgraded for a while (I don't have control over it), and it's below SR8, so Rob's solution with alternate state getfieldselections() doesn't work (the last post):

Alternate states and Trigger together

Is there an alternative to this for SR7 and below?

My end goal is to get the correct field selection from State A and State B into charts, i.e.

Client	(State A Selection) Volume	(State B Selection) Volume
A	515	345
B	325	34
C	235	436

[tresesco]

You can get the possible values using concat(distinct {State}...). Afraid there is no alternative to get the selected values prior to SR8

[sunny_talwar]

The only problem with this is that GetFieldSelection caught values only when something or all is selected, whereas Concat will pick the values without selections also unless you have a if statement to restrict it. It kinds of get complicated to perform workaround (for a lack of a better word) GetFieldSelection with Concat function.

Best,

Sunny

[sifatnabil]

Thanks..what if I wanted to show different possible selections in the column, e.g.

concat(distinct {StateA} Week) works. But if the end user chooses month instead, can I display the month instead?