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

[erichshiino]

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

[IAMDV]

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

Just wanted to clarify...

Cheers - DV

[mstoler]

Hello,

In the set analysis expression

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

YEAR and MONTH selections are ignored.

That should work fine for you.

Michael

[Anonymous]

Thanks for your quick respons!

Will do it that way.

Henco

[Anonymous]

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

[mstoler]

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

[matt_crowther · Accepted solution]

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

[IAMDV]

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

[Anonymous]

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

Regards,

Henco