topic Re: Pls Help on Below Question in QlikView

Pls Help on Below Question

Fri, 18 Apr 2014 10:47:38 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 Required:

F1, Sales

A,6

B,3

Please exclude A, Y, 2 in Test Table.

Regards

Ravi

Re: Pls Help on Below Question

kushalthakral — Fri, 18 Apr 2014 10:51:43 GMT

Hi Ravi

Simply use Dimension

and in expression use sum(Sales)

Re: Pls Help on Below Question

Fri, 18 Apr 2014 10:54:00 GMT

Hi kushal,

Please check what out put required.

Regards

Ravi Gupta

Re: Pls Help on Below Question

swuehl — Fri, 18 Apr 2014 10:55:21 GMT

Maybe like this:

Output:

LOAD F1,

sum(SALES) as Sales

RESIDENT Test

where F2 <> 'Y' or F1 <> 'A' group by F1;

Re: Pls Help on Below Question

its_anandrjs — Fri, 18 Apr 2014 10:57:46 GMT

Write a 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 F1,F2,SALES

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

DROP Table Test;

And take straight table

Dimension:- F1

Expression:- Sum(SALES)

Re: Pls Help on Below Question

amit_saini — Fri, 18 Apr 2014 10:59:40 GMT

Hi Ravi,

Please see the attachment.

Thanks,

Re: Pls Help on Below Question

maxgro — Fri, 18 Apr 2014 11:00:42 GMT

in a chart

dim F1

exp sum(if(F1&F2<>'AY', SALES))

in a script

Test:

LOAD * INLINE [F1, F2, SALES

A, X, 4

A, Y, 2

A, X, 2

B, Y, 3];

Result:

NoConcatenate

load

F1,

sum(SALES) as SALES

resident Test

where F1 & F2 <>'AY'

group by F1;

drop table Test;

Re: Pls Help on Below Question

amit_saini — Fri, 18 Apr 2014 11:04:52 GMT

Hi Ravi,

Please follow this one.

Thanks,

Re: Pls Help on Below Question

MK_QSL — Fri, 18 Apr 2014 11:07:15 GMT

Script

=============

Test:

LOAD

IF(F1&F2='AY',1,0) as Flag

INLINE

[

F1, F2, SALES

A, X, 4

A, Y, 2

A, X, 2

B, Y, 3

];

========================

Create a straight table

Dimension

Expression

SUM({<Flag = {0}>}SALES)

Re: Pls Help on Below Question

kushalthakral — Fri, 18 Apr 2014 11:09:27 GMT

Hi Ravi

Try this in script

Test:

LOAD * INLINE [F1, F2, SALES

A, X, 4

A, Y, 2

A, X, 2

B, Y, 3];

load F1&F2 as Key,

F1 as F11,

F2 as F22,

SALES as SALES1

Resident Test where F1&F2<>'AY';

and then use F11 as Dimension and

sum(SALES1) as expression

in straight table

You will get ur result

Re: Pls Help on Below Question

its_anandrjs — Fri, 18 Apr 2014 11:09:57 GMT

There is another way of doing this like load normal table and add 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 in straight table

Dimension:-F1

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

Re: Pls Help on Below Question

Fri, 18 Apr 2014 14:53:00 GMT

hi,

he can take your response Massimo and he remove "noconcatenate" no ?

I tried it without "noconcatenate" and it works

regards

Re: Pls Help on Below Question

its_anandrjs — Fri, 18 Apr 2014 14:59:13 GMT

Hi Ravi,

If you got correct answer from the thread so mark the thread as Correct / Helpful.

Regards