topic Re: Set Analysis - Adding to current selection in QlikView

Set Analysis - Adding to current selection

Fri, 10 Feb 2012 18:11:41 GMT

= sum (

Time= { ">= $(vminWeek) <= $(vmaxWeek) "},

Product = Product + { 'IndustryMin' }

Rating)

I have a line graph (chart) with Time as the dimension and the above as my expression.

I have a listbox for Product.

I want the chart so show the selected Product, PLUS another item that was not selected from that listbox.

Therefore I included this in my set analysis: Product = Product + { 'IndustryMin' }.

If I don't include the filter on Product, my chart filters on Time just fine.

What's wrong with my Product filter?

Re: Set Analysis - Adding to current selection

swuehl — Fri, 10 Feb 2012 18:32:52 GMT

I assume that IndustryMin is a value from field Product, right?

I don't see anything wrong with the Product set modifier.

What do you see if you apply above expression?

Have you tried (just as a test) just assigning your IndustryMin value to Product, like

= sum (

Time= { ">= $(vminWeek) <= $(vmaxWeek) "},

Product = { 'IndustryMin' }

Rating)

Set Analysis - Adding to current selection

Fri, 10 Feb 2012 19:27:58 GMT

Hi Suwehl,

Yes, IndustryMin is a value from the field Product.

After double-checking using your method, I realized that this is part of a structural issue.

Product_Display, Product, Rating

---------------------------------------------------------------------------------------

GameBoy, GameBoy 9

GameGear, GameGear 10

SegaSaturn, SegaSaturn 5

- IndustryMin 4

The Set Analysis formula Product += {'IndustryMin'} worked,

but the problem was that the listbox shown to users is using the field Product_Display instead of Product.

If I select from the listbox Product_Display, IndustryMin would show up.

If I select from the listbox Product, IndustryMin does not show up.

Would it be possible to hide certain values like IndustryMin from the listbox Product? Then I can just get rid of the field Product_Display!

Otherwise, is there a way to let the dashboard user select from Product_Display, and still be able to use the set analysis += {'IndustryMin'} on Product?

Set Analysis - Adding to current selection

swuehl — Fri, 10 Feb 2012 19:49:29 GMT

I think you can use either method,

try something like

= sum (

Time= { ">= $(vminWeek) <= $(vmaxWeek) "},

Product = p(Product) + { 'IndustryMin' },

Product_Display=

Rating)

or use your original expression and in your list box a field expression (an expression is available to enter at the bottom of the field list in general tab of the list box):

=if(Product <> 'IndustryMin', Product)

Set Analysis - Adding to current selection

Fri, 10 Feb 2012 21:23:19 GMT

Hi Swuehl,

That worked like a charm.

I didnt know p() was so useful.

Thanks!