Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use this?
sum( {$<City = e({$<City={$(=Concat(Chr(39) & City & Chr(39), ','))}>} City)>} Sales )
Great Anil,
It is working fine. Just one more question...Can we implement the same from getfieldselections() by any other way?
Why can't you just use this?
Sum({$<City = e(City)>} Sales)
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>
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
You can, but I wonder why you want to make your expression complex?
I know. Your guess as good as mine. For "learning" purposes, future reference?
You are absolutely right...
okay