topic Re: GetFieldSelections for versions below SR8 in QlikView

GetFieldSelections for versions below SR8

sifatnabil — Fri, 22 May 2015 09:52:01 GMT

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

Re: GetFieldSelections for versions below SR8

tresB — Fri, 22 May 2015 10:01:28 GMT

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

Re: GetFieldSelections for versions below SR8

sunny_talwar — Fri, 22 May 2015 10:07:01 GMT

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

Re: GetFieldSelections for versions below SR8

sifatnabil — Fri, 22 May 2015 10:07:58 GMT

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?