topic Re: Avoiding list box selection in chart in QlikView

Avoiding list box selection in chart

Anonymous — Tue, 28 Oct 2014 11:31:11 GMT

Hi folks,

I want to make one chart unresponsive for one perticular list box selection...... selections of listbox should not effect chart..

Thanks in Advance...

Regards,

Venkat.

Re: Avoiding list box selection in chart

sorrakis01 — Tue, 28 Oct 2014 11:33:37 GMT

Hi,

On Properties of chart (General Sheet) you have a property to unlink the chart.

Or other option (if you need the listbox) is in expressions you can use set analysis for it.

Regards,

Re: Avoiding list box selection in chart

nagaiank — Tue, 28 Oct 2014 11:34:56 GMT

If the list box is for a dimension Field1, include in the expression of the chart the following set expression

{<Field1=>}

Re: Avoiding list box selection in chart

Tue, 28 Oct 2014 11:35:32 GMT

Hi,

Try to create a alternate state in document properties and place in chart general properties,

or else whatever list box you are using just exclude that list box field in chart expression

suppose you have Country list box

in chart you have sum(sales)

just write exoression like this sum({<countrty=>} sales)

Re: Avoiding list box selection in chart

Tue, 28 Oct 2014 11:36:19 GMT

Hi,

Use Alternate States option to do this. Please check 11 developers guide for Alternate State.

Thank you.

Regards,

Srinivasu

Re: Avoiding list box selection in chart

ashfaq_haseeb — Tue, 28 Oct 2014 11:38:34 GMT

Hi,

Go for Alternate states.

Regards

ASHFAQ

Re: Avoiding list box selection in chart

Kushal_Chawda — Tue, 28 Oct 2014 11:41:43 GMT

Create a chart with Expression as

Sum({<Field1 =, Field2=>} Sales)

Selections from Field1 & Field2 will not affect the chart using above expression

Re: Avoiding list box selection in chart

Anonymous — Tue, 28 Oct 2014 12:02:11 GMT

Thanks Nag...

i hav this expr..

Sum({$<TerritoryGroup={Europe} >}Sales)/Sum(Sales)

and i hav list box for TerritoryGroup...when i select values in that my stacked bar chart showing >100%..... i hav 3 values in TG...Europe, NorthAmerica and Pacific....