topic Ignore selection in chart in QlikView

Ignore selection in chart

Anonymous — Wed, 18 May 2011 13:45:05 GMT

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

Ignore selection in chart

erichshiino — Wed, 18 May 2011 13:57:24 GMT

You need to include the field on set analysis without forcing values, like this:

If you have the date fields: YEAR and MONTH

and a value field:VALUE:

You can write:

sum ( {<YEAR = , MONTH = >} VALUE)

You can include all the fields you want to ignore.

Regards,

Erich

Ignore selection in chart

IAMDV — Wed, 18 May 2011 14:12:14 GMT

Erich - In the above example. The expression ignores any selections on YEAR & MONTH fields. Is it right?

Just wanted to clarify...

Cheers - DV

Ignore selection in chart

mstoler — Wed, 18 May 2011 14:14:55 GMT

Hello,

In the set analysis expression

sum ( {<YEAR = , MONTH = >} VALUE)

YEAR and MONTH selections are ignored.

That should work fine for you.

Michael

Ignore selection in chart

Anonymous — Wed, 18 May 2011 14:33:55 GMT

Thanks for your quick respons!

Will do it that way.

Henco

Ignore selection in chart

Anonymous — Wed, 18 May 2011 14:37:12 GMT

Just one other question. Is it also possible to exclude everything except product?

In that way the lines will only change when I select a specific product.

Thanks in advance.

Henco

Ignore selection in chart

mstoler — Wed, 18 May 2011 14:43:38 GMT

Hello,

I would just add all your fields separated by commas

sum ( {<YEAR = , MONTH = , FIELD2=, FIELD3=>} VALUE)

How many fields do you have?

If you have many then you could look at the full set {1} and the function getfieldselections to return the Products separated by commas.

Michael

Re: Ignore selection in chart

matt_crowther — Wed, 18 May 2011 15:45:54 GMT

Henco,

As you could well have hundreds of fields to potentially exclude I'd recommend trying the following workaround (as suggested above):

To ignore all selections bar those made in the 'Product' dimension try the following expression and variable:

=sum({1<Product={'$(vProduct)'}>} Value)

Where 'vProduct' is a Variable: =getfieldselections(Product,chr(39)&', '&chr(39))

Essentially the variable is building a suitable string of only those selected Product values (not just associated) to pass to the Set Analysis.

Hardly out of the box functionality but it works for me.

Hope that helps,

Matt - Visual Analytics Ltd

Re: Ignore selection in chart

IAMDV — Wed, 18 May 2011 16:13:35 GMT

Henco - I am sure above solutions will get you going. Here is one more idea...

=COUNT({$<[$(=Concat({1<$Field-={'Gender'}>}distinct $Field,'],[')&']=')>} Resp_ID)

In the above example except 'Gender' everything will be excluded.

Cheers - DV

Re: Ignore selection in chart

Anonymous — Wed, 18 May 2011 16:14:40 GMT

Thank you all very much. I think its a perfect solution for my 'problem'.

Regards,

Henco

Ignore selection in chart

Wed, 06 Jun 2012 17:43:36 GMT

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])

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.

Ignore selection in chart

CELAMBARASAN — Wed, 06 Jun 2012 19:29:35 GMT

Hi,

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

This one correct you can go with this.

Celambarasan

Re: Ignore selection in chart

mstoler — Wed, 06 Jun 2012 20:15:53 GMT

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

Re: Ignore selection in chart

Anonymous — Tue, 26 Apr 2016 11:32:24 GMT

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