Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hencovanee
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
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
erich_shiino
Partner
Partner

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
Partner

Hello,

In the set analysis expression

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

YEAR and MONTH selections are ignored.

That should work fine for you.

Michael

hencovanee
Creator II
Creator II
Author

Thanks for your quick respons!

Will do it that way.

Henco

hencovanee
Creator II
Creator II
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
Partner

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

View solution in original post

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

hencovanee
Creator II
Creator II
Author

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

Regards,

Henco