Visulaization based on selection help!

amit_saini — Wed, 08 Mar 2017 04:43:03 GMT

Hi Folks,

I'm created a line chart with simple

Dim : Values

Expression :

sum({<Cost_Flag ={'1'}>} Data)

and I'm having below result:

Now what user want to have is something like below:

By default it should above graph , but the moment user selects 2 Plants as in below example KBO as 1 and KLA as 2 then we should get 2 lines showing "Values" and if the selection is for 3 plants then respective 3 lines. We want same working not only for Plant , but also for 'Region' and might be for other list box selections.

I tried something like below , but it's not working as expected:

sum({<Cost_Flag ={'1'},Plant={'$(=getfieldselections(Plant))'},Region={'$(=getfieldselections(Region))'}>} Data)

Please suggest how this can be possible!

Thanks,

Re: Visulaization based on selection help!

tresB — Wed, 08 Mar 2017 05:25:41 GMT

Take Plant (or any other dimension you want) as your second dimension, and use Enable Condition for this dimension exp: =GetSelectedCount(Plant)

Re: Visulaization based on selection help!

amit_saini — Wed, 08 Mar 2017 05:31:03 GMT

Thank You!

That was easy .

topic Visulaization based on selection help! in QlikView

Visulaization based on selection help!

Re: Visulaization based on selection help!

Re: Visulaization based on selection help!