Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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

Re: Ignore selection in chart

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

Ignore selection in chart

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

Highlighted
Luminary
Luminary

Ignore selection in chart

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

Just wanted to clarify...

Cheers - DV

Highlighted
Partner
Partner

Ignore selection in chart

Hello,

In the set analysis expression

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

YEAR and MONTH selections are ignored.

That should work fine for you.

Michael

Highlighted
Creator II
Creator II

Ignore selection in chart

Thanks for your quick respons!

Will do it that way.

Henco

Highlighted
Creator II
Creator II

Ignore selection in chart

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

Highlighted
Partner
Partner

Ignore selection in chart

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

Highlighted
Luminary
Luminary

Re: Ignore selection in chart

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

Highlighted
Luminary
Luminary

Re: Ignore selection in chart

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

Highlighted
Creator II
Creator II

Re: Ignore selection in chart

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

Regards,

Henco