Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help

Input

A, 12

B, 13

C, 14

D, 15

Output

AB  25

CD 29

6 Replies
swuehl
MVP
MVP

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)

maxgro
MVP
MVP

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;

MarcoWedel

what's the rationale of the letter groups?

Not applicable
Author

Hi Lalit,

Have a look into the qvw file.

Hope it helps.

Regards,

Jemimah

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

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