Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
easternfish
New 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
Highlighted

Re: Multiple records in one expression

Then try it like this

Dimensions

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

Description

Expression

Sum(Total)

View solution in original post

6 Replies

Re: Multiple records in one expression

In the script or in the chart?

MVP & Luminary
MVP & Luminary

Re: Multiple records in one expression

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
New Contributor III

Re: Multiple records in one expression

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

easternfish
New Contributor III

Re: Multiple records in one expression

I was trying it in the chart originally.

Highlighted

Re: Multiple records in one expression

Then try it like this

Dimensions

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

Description

Expression

Sum(Total)

View solution in original post

easternfish
New Contributor III

Re: Multiple records in one expression

Thank you for all your help!