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: 
easternfish
Contributor III
Contributor III

Multiple records in one expression

Hi,

I'm trying to combine multiple record that are related into same line.

Exp:

this is how my reports looks

   

IDDescriptionTotal
AItem 1$200.00
B

Item 1

$100.00

this is how I want it to look.

   

IDDescriptionTotal
A-BItem 1$300.00

please let me know how this can be achieve.

thank you so much in advance!

1 Solution

Accepted Solutions
sunny_talwar

Then try it like this

Dimensions

Aggr(Concat(DISTINCT ID, '-'), Description)

Description

Expression

Sum(Total)

View solution in original post

6 Replies
sunny_talwar

In the script or in the chart?

Gysbert_Wassenaar

Perhaps like this:

LOAD

     concat(ID, '-') as ID,

     Description,

     sum(Total) as Total

FROM

     ...source_table...

GROUP BY

     Description    

     ;


talk is cheap, supply exceeds demand
easternfish
Contributor III
Contributor III
Author

how would that work if the ID comes from a different Source Table and linked by description?

easternfish
Contributor III
Contributor III
Author

I was trying it in the chart originally.

sunny_talwar

Then try it like this

Dimensions

Aggr(Concat(DISTINCT ID, '-'), Description)

Description

Expression

Sum(Total)

easternfish
Contributor III
Contributor III
Author

Thank you for all your help!