Double restriction in a query

[#1]

Hi experts,

My situation is the next:

I have to make one query with a double filter; a filter within a filter. I explain it in a simple case:

CHARACTERISTIC 1--> 0MATERIAL. I have values from 0001 till 9999

CHARACTERISTIC 2--> ZCOLOUR. I have 5 values: A (red), B (green), C (blue), D ( yelow), E (black).

Now I have to create a query and I need materials 0001 (with all the colours) and 0002 (with ZCOULOUR DIFFERENT THAN E(BLACK) )

Is it possible to make this kind of double restriction?

I hope my explanation is clear...

Many thanks in advanced!!

Jordi

[former_member418141 · Accepted solution]

Hi Jordi

could using restricted keyfigures solve your problem?

regrads

tom

[Former Member · Accepted solution]

Could be, but the question is: How??

If I restrict the KF with Material and values 0001, 0002 and then in ZCOLOUR I exclude E (Black), then the group of materials 0001 black wouldnt be selected. And I just want to excude E (black) for the group of materials 0002.

Thanks for your answer.

Jordi

[FCI · Accepted solution]

Yes, but if you create 2 restricted KF, you can filter the first on material 001 for all colours and the second on the material 002 excluding the black color.

So with 4 variables, you can handle this kind of situation but it's quite limited (limited number of combinations).

Pb is that BW doesn't support filter on combinations of characterics.

Regards,

FCI

[former_member418141 · Accepted solution]

Hi Jordi

I think this is only possible using 2 resticted key-figures.

1. restriction only to materieal 0001

2. restriction to materieal 0002 and excluding 'black'

add the values to anonther calculated key-figure and set the both restricted ones to "not displayed"

the query should show you the values needed.

regards

tom

[Former Member · Accepted solution]

Many thanks for your responses!

I think the solution is quite limited, but I don't think there's any other possibility.

Thanks for the idea. I can consider my issue as solved.

Regards,

Jordi

[Former Member]

you can create two seperate Restricted Key Figures for 0001 and 0002 respectively.