Ignore selection in chart

[Anonymous]

Dears,

I have a chart wich shows me the sales of 2009, 2010, 2011 and our target. Each of them is an expression, shown as line.

Now I would like to ignore the date selection in QlikView, but not the producttype. Does someone know how to fix this?

So, at the moment I use {1}, to ignore all selections, but I only would like to ignore the dates selection.

Kind regards,

Henco

[#2]

I dont want to start a new thread, but I need help with a similar issue:

I use the following expression in a chart:

Sum({$<[Current Sourcing Stage]={'6DNS'}>} [Ref Cost])

I would like to ignore selection of another field called [Top Spend Indicator]

Can you please confirm which of the below expressions ignores any selection in the field [Top Spend Indicator] :

1. Sum({$<[Current Sourcing Stage]={'6DNS'}>, [Top Spend Indicator]= > } Ref Cost])

OR

2. Sum({$<[Current Sourcing Stage]={'6DNS'}>} {<[Top Spend Indicator]= >}[Ref Cost])

or are they BOTH correct? Any comments on which expression to use if they are both correct.

Thanks much for your help,

Hemanth.

[CELAMBARASAN]

Hi,

     Sum({$<[Current Sourcing Stage]={'6DNS'}>, [Top Spend Indicator]= > } Ref Cost])

     This one correct you can go with this.

Celambarasan

[mstoler]

The first one.

Michael Stoler

Cohn Consulting Group

Tel: 973-228-3500 x4391

Fax: 973-364-7731

mstoler@jhcohn.com<mailto:mstoler@jhcohn.com>

www.jhcohn.com<http://www.jhcohn.com/>

J.H. COHN LLP

Accountants and Consultants since 1919

[Anonymous]

Hi

Lets say if i have more number of dimensions 10 to 15 dimensions to be added in the list ,is there any alternative other than you suggested .Should i need to include all the dimensions in then set

Thanks