getfieldslection with multiple field in qlikview

[vipingarg23]

Hi Team,

Please find the sample file as an attachment.

I want, if I select any value for city, that value should not appear in bar chart.

It is working fine with one value but doesn't work if I select multiple value from city.

Can anyone help me on the same?

[Anil_Babu_Samineni]

Use this?

sum( {$<City = e({$<City={$(=Concat(Chr(39) & City & Chr(39), ','))}>} City)>} Sales )

[vipingarg23]

Great Anil,

It is working fine. Just one more question...Can we implement the same from getfieldselections() by any other way?

[sunny_talwar]

Why can't you just use this?

Sum({$<City = e(City)>} Sales)

[vipingarg23]

Hi Sunny,

Thanks..But I want to know that can we use getfieldselections() inside set

analysis in case of multiple selections. If yes then how?

On Thu, Apr 19, 2018 at 7:12 PM, Sunny Talwar <qcwebmaster@qlikview.com>

[cheenu_janakira]

I think you are looking for a solution somewhere based on Anil's:

sum( {$<City = e({$<City={$(=CHR(39) & GetFieldSelections(City, CHR(39) & ',' & CHR(39)) & CHR(39))}>} City)>} Sales )

even though Sunny gave you the simplest form.

Cheerio

[sunny_talwar]

You can, but I wonder why you want to make your expression complex?

[cheenu_janakira]

I know. Your guess as good as mine. For "learning" purposes, future reference?

[vipingarg23]

You are absolutely right...

[sunny_talwar]

okay