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: 
timpoismans
Specialist
Specialist

Set analysis - excluding values

Hi all.

Consider the following situation:

Superartikel issue.PNG

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

26 Replies
mdmukramali
Specialist III
Specialist III

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

An Indirect Set Analysis might work to your needs:

Set Analysis Wizard for QlikView | qlikblog.at

jpenuliar
Partner - Specialist III
Partner - Specialist III

Can you share a sample app?

timpoismans
Specialist
Specialist
Author

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

I'll try the Indirect approach.

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

antoniotiman
Master III
Master III

Why mdmukramali expression doesn't work, since

Super article 2: Product Group BA4 ?

mdmukramali
Specialist III
Specialist III

Hi Tim,

still i'm confused.

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

Thanks,

Mukram.

timpoismans
Specialist
Specialist
Author

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

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.