Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

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.

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

Highlighted
easternfish
New Contributor III

Re: Multiple records in one expression

Thank you for all your help!