topic AND selection in QlikView

AND selection

Tue, 21 May 2013 09:13:33 GMT

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

Re: AND selection

sivarajs — Tue, 21 May 2013 09:28:54 GMT

write a calculated dimension as

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

Re: AND selection

er_mohit — Tue, 21 May 2013 09:31:23 GMT

I have attached example for AND selection

see the attached file

Re: AND selection

kumarnatarajan — Tue, 21 May 2013 09:37:34 GMT

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.

Re: AND selection

Gysbert_Wassenaar — Tue, 21 May 2013 09:57:35 GMT

See attached qvw.