Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Ignore selection in chart

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

1 Solution

Accepted Solutions
matt_crowther
Luminary Alumni
Luminary Alumni

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

View solution in original post

13 Replies
erichshiino
Partner - Master
Partner - Master

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
Luminary Alumni
Luminary Alumni

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

Just wanted to clarify...

Cheers - DV

mstoler
Partner - Specialist
Partner - Specialist

Hello,

In the set analysis expression

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

YEAR and MONTH selections are ignored.

That should work fine for you.

Michael

Anonymous
Not applicable
Author

Thanks for your quick respons!

Will do it that way.

Henco

Anonymous
Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

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
Not applicable
Author

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

Regards,

Henco