topic Re: list box for only one chart in QlikView

list box for only one chart

Anonymous — Sat, 31 Jan 2015 04:48:23 GMT

Hello,

I have one sheet with 4 charts and 3 objects. i have 4 list boxes.my requirement is 3 list box selections should effect all the objects and charts when i give selection in 4th list box that should be effected only one particular chart with keeping previous list box selections.

Thanks,

Venkat.

Re: list box for only one chart

sujeetsingh — Sat, 31 Jan 2015 05:56:54 GMT

You can use the set analysis to ignore the selection of this 4th field in the expression of the chart you want where there should be no selection.

If you have Brand you do not want the Brand filter selection to to an expressions

sum({<Brand=->}Slaes)

Re: list box for only one chart

kulasekhar — Sat, 31 Jan 2015 06:01:18 GMT

Hi Venkat,

May be like this? PFA,

Thanks,

Sekkhar

Re: list box for only one chart

Anonymous — Sat, 31 Jan 2015 06:02:56 GMT

i cant open qvw file coz i am using personal editor

Re: list box for only one chart

Sat, 31 Jan 2015 06:39:07 GMT

You can make use of Alternate States.

1. Create a new State (Doc Props -- General -- Alternate States)

2. Use this newly created state only for the two objects you want to be unaffected by any selections. Object Props -- General -- Alternate State. This field is visible only when a user created Alternate State exists in the document.

Please see attached screenshots for better understanding.

Re: list box for only one chart

Anonymous — Sat, 31 Jan 2015 06:42:52 GMT

if we do like that other list box selection wont effect final chart right...coz chart state is different from others list boxs...

Re: list box for only one chart

Sat, 31 Jan 2015 06:46:12 GMT

yes, that is what you wanted. The chart should be affected only by the 4th list box?

Re: list box for only one chart

Anonymous — Sat, 31 Jan 2015 06:52:20 GMT

thats not my requirment..my final chart shld effected by all list box selections......4th list box selection shld nt effect other object except my final chart....

Re: list box for only one chart

Sat, 31 Jan 2015 07:00:24 GMT

ok..then use Set Analysis in the chart expression and ignore the field used in this 4th list box.