topic Pls help on Below Question in QlikView

Pls help on Below Question

Fri, 18 Apr 2014 10:45:59 GMT

Hi,

Please help on below question:

Test:

LOAD * INLINE [F1, F2, SALES

A, X, 4

A, Y, 2

A, X, 2

B, Y, 3];

OutPut:

F1, Sales

A,6

B,3

Please exclude A, Y, 2 in Test Table.

Regards

Ravi

Re: Pls help on Below Question

its_anandrjs — Fri, 18 Apr 2014 10:55:49 GMT

Write your load script like

Test:

LOAD *,F1&F2 as Key;

LOAD * INLINE

[

F1, F2, SALES

A, X, 4

A, Y, 2

A, X, 2

B, Y, 3

];

NoConcatenate

Data:

LOAD *

Resident Test Where not Match(Key,'AY');

DROP Table Test;

Then take straight table

Dimension:- F1

Expression:- Sum(SALES)

Re: Pls help on Below Question

Fri, 18 Apr 2014 11:09:17 GMT

Thanks Anand

Re: Pls help on Below Question

its_anandrjs — Fri, 18 Apr 2014 11:12:26 GMT

Another way of doping the same load your table like and add the Key field

Test:

LOAD *,F1&F2 as Key;

LOAD * INLINE

[

F1, F2, SALES

A, X, 4

A, Y, 2

A, X, 2

B, Y, 3

];

And take a straight table

Dimension:-F1

Expression:- Sum({<Key -= {'AY'} >} SALES)