AND selection

[#1]

Hi experts,

I want to make a selection for a straight table, so that the rows that have two special attributes are not displayed.

For example:

attribute 1 is A or B

attribute 2 is X or Y

I only want to display the rows, where i do not have the combination of A and X.

(show rows with: AY, BX and BY)

example is attached

Thanks in advance and best ragards

Sebastian

[sivarajs · Accepted solution]

write a calculated dimension as

if(Verbrauch&XYZ<>'AX' ,MATNR)

[er_mohit]

I have attached example for AND selection

see the attached file

[kumarnatarajan]

Hi,

Try this one

Ex:

LOAD

* Where Verbrauch&XYZ<>'AX';
LOAD * INLINE [
    MATNR, Verbrauch, XYZ
    403983, A, X
    405016, B, X
    405017, A, Y
    405946, B, X
    406277, A, X
    407673, B, Y
    407674, A, X
    506873, B, X
    506878, A, Y
    506984, B, X
    507020, A, X
    507053, B, Y
    507080, A, X
    507081, B, X
    507083, A, Y
    507084, B, X
];

find the attached file.

[Gysbert_Wassenaar]

See attached qvw.