Set analysis - excluding values

[timpoismans]

Hi all.

Consider the following situation:

Every Document Number has Items. Every Item can have multiple Product Groups.

The customer has a number of Products they view as "Super articles". But some Items are built out of more than one "Super article"

For example, Item 27 in the picture. After filtering of the "Super articles" the Item is listed under the 500-584 Product Group, but it's listed under the BA4 Product Group as well.

We only want to see it under the BA4 Product Group, so I thought set analysis like this:

     Sum({<[Product Group] = {">=500<=584"} - {'BA4'}>}

would stop Item 27 from showing in the 500-584 Product Group. But it seems I'm completely wrong, as Item 27 is still showing here.

Any advice would be appreciated,

Thanks in advance!

Kind regards,

Tim Poismans

[mdmukramali]

Hi Tim,

Do you want to show only those items which are under BA4 Product Group?

Can you have try like this,

=Count({<[Product Group]={'BA4'}>}Item)

else can you share sample App.

Thanks,

Mukram.

[jpenuliar]

An Indirect Set Analysis might work to your needs:

Set Analysis Wizard for QlikView | qlikblog.at

[jpenuliar]

Can you share a sample app?

[timpoismans]

Hi Mukram

I'll try to explain the situation a bit better:

We got a number of "Super articles". In this example, we got:

Super article 1: Product Group 500 - 584

Super article 2: Product Group BA4

Item 27 has products that belong to both groups.

But we only want item 27 to be shown under Super article 2.

But if I use the filter:

      Sum({<[Product Group]={">=500<=584"}>}Amount)

to filter out the Items that should be shown under Super article 1, it still shows me Item 27 under Super article 1

I cannot share a sample app, restricted by the client.

[timpoismans]

I'll try the Indirect approach.

Sadly I can't share a sample app, restricted by the client.

[antoniotiman]

Why mdmukramali expression doesn't work, since

Super article 2: Product Group BA4 ?

[mdmukramali]

Hi Tim,

still i'm confused.

can you share dummy data with same format of original and output ?

Thanks,

Mukram.

[timpoismans]

Indirect approach isn't working.

Items can be build up out of two or more super articles.

We only want to see it with one super article, so we put a filter on it. But a filter of "we want to see this" isn't enough as you're not saying "But I don't want to see that".

If that makes any sense.

[timpoismans]

Since that doesn't accomplish what I'm looking for.

Item 27 is build up out of two super articles.

With filters like

     Sum({<[Product Group]={">=500<=584"}>}Amount)

and

     Count({<[Product Group]={'BA4'}>}Item)

Item 27 passes both filters, so is shown under both super articles.

But we only want to show it under 1 super article.

So what I’m trying to find a solution for is:

            I want to see the item when a product has [Product Group]={">=500<=584"}

            But if it also has a product where [Product Group]={'BA4'} I do NOT want to see it.