topic Re: Help in QlikView

Help

Wed, 03 Jun 2015 11:13:32 GMT

Input

A, 12

B, 13

C, 14

D, 15

Output

AB 25

CD 29

Re: Help

swuehl — Wed, 03 Jun 2015 15:37:59 GMT

You want a front end solution?

Create a straight table chart, with a calculated dimension

=if( Match(DimField,'A','B'), 'AB','CD')

and as expression

=sum(NumberField)

Re: Help

maxgro — Wed, 03 Jun 2015 21:54:44 GMT

source:

load *, div(rowno()+1,2) as field3 inline [

f1,f2

A, 12

B, 13

C, 14

D, 15

E,10

F,20

];

final: NoConcatenate load concat(f1) as f1, sum(f2) as f2 resident source group by field3;

DROP Table source;

Re: Help

MarcoWedel — Wed, 03 Jun 2015 23:35:19 GMT

what's the rationale of the letter groups?

Re: Help

Thu, 04 Jun 2015 04:10:09 GMT

Hi Lalit,

Have a look into the qvw file.

Hope it helps.

Regards,

Jemimah

Re: Help

jagan — Thu, 04 Jun 2015 05:17:36 GMT

Hi Lalit,

On what basis and AB and CD should be grouped? what if E, F, G, H available? Is there any logic to group?

Regards,

jagan.

Re: Help

Anonymous — Thu, 04 Jun 2015 05:27:22 GMT

Can you tell the grouping logic,

for your example you can use straight table with calculated dimension =pick(match(Col1,'A','B','C','D'),'AB','AB','CD','CD')

then in expression sum (Col2)

Thanks

BKC