topic Re. :Re: Re. :Re: Re. :Show Unrelated data In Chart in QlikView

Show Unrelated data In Chart

Mon, 16 Aug 2010 10:18:50 GMT

When we select data in selection field, its shows all value but in different bg color for example Select data (Green), Associated data (White) and

Unrelated data (Gray), I want to show all values like selection field (same as Green, White & Gray) after selection of any deminsion value in Chart object can its possible?

Re. :Show Unrelated data In Chart

martin59 — Mon, 16 Aug 2010 10:22:45 GMT

I think you can do that with your expression background color.

you have several systems functions like getfieldselections(), getselectedcount(), getpossiblecount()...

Hope that helps you

Re. :Show Unrelated data In Chart

Mon, 16 Aug 2010 10:43:14 GMT

Thanks, but i have no issue regarding expression color and i used getfieldselections() and getselectedcount()for different purposes but dear when you select any value from dimension its shows only selected value in chart object other values are exculeded form the chart object, i want chart object all values either dimension values are selected or not.

Other than this if you have any example for above question.

Re. :Show Unrelated data In Chart

Mon, 16 Aug 2010 10:45:49 GMT

Thanks, but i have no issue regarding expression color and i used getfieldselections() and getselectedcount()for different purposes but dear when you select any value from chart dimension its shows only selected value in chart object other values are exculeded form the chart object, i want chart object show all values either chart dimension values are selected or not.

Other than this if you have any example for above question, please remember i am talking about chart dimension not field dimension.

Re. :Re: Re. :Show Unrelated data In Chart

martin59 — Mon, 16 Aug 2010 10:48:39 GMT

So you have to use Set Analysis functions :

Per exemple :

sum({1} Amout)

show the total amount for all datas, disreagarding the selections

Re. :Re: Re. :Show Unrelated data In Chart

Mon, 16 Aug 2010 10:57:01 GMT

Thanks, Set Analysis I never use before but its fine and i let you know after using set analysis.

Re. :Re: Re. :Show Unrelated data In Chart

Mon, 16 Aug 2010 10:58:53 GMT

Boss I did, thanks a lot, its really very good.

Re. :Re: Re. :Re: Re. :Show Unrelated data In Chart

martin59 — Mon, 16 Aug 2010 13:14:42 GMT

Here's a documentation of Set Analysis to better understand this very interesting feature

Re. :Re: Re. :Re: Re. :Show Unrelated data In Chart

Tue, 17 Aug 2010 05:09:08 GMT

Thanks Martin Favier.