topic Re: getfieldslection with multiple field in qlikview in QlikView

getfieldslection with multiple field in qlikview

vipingarg23 — Thu, 19 Apr 2018 13:22:12 GMT

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 — Thu, 19 Apr 2018 13:31:23 GMT

Use this?

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

vipingarg23 — Thu, 19 Apr 2018 13:39:39 GMT

Great Anil,

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

sunny_talwar — Thu, 19 Apr 2018 13:42:12 GMT

Why can't you just use this?

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

vipingarg23 — Thu, 19 Apr 2018 13:47:31 GMT

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 — Thu, 19 Apr 2018 13:56:47 GMT

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 — Thu, 19 Apr 2018 13:59:35 GMT

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

cheenu_janakira — Thu, 19 Apr 2018 14:13:26 GMT

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

vipingarg23 — Thu, 19 Apr 2018 14:14:49 GMT

You are absolutely right...

sunny_talwar — Thu, 19 Apr 2018 14:16:46 GMT

okay