Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

timpoismans
Valued Contributor

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
Valued Contributor II

Re: Set analysis - excluding values

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
Valued Contributor III

Re: Set analysis - excluding values

An Indirect Set Analysis might work to your needs:

Set Analysis Wizard for QlikView | qlikblog.at

jpenuliar
Valued Contributor III

Re: Set analysis - excluding values

Can you share a sample app?

timpoismans
Valued Contributor

Re: Set analysis - excluding values

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
Valued Contributor

Re: Set analysis - excluding values

I'll try the Indirect approach.

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

antoniotiman
Honored Contributor III

Re: Set analysis - excluding values

Why mdmukramali expression doesn't work, since

Super article 2: Product Group BA4 ?

mdmukramali
Valued Contributor II

Re: Set analysis - excluding values

Hi Tim,

still i'm confused.

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

Thanks,

Mukram.

timpoismans
Valued Contributor

Re: Set analysis - excluding values

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
Valued Contributor

Re: Set analysis - excluding values

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.

Community Browser