topic Re: Multiple records in one expression in QlikView

Multiple records in one expression

easternfish — Mon, 23 Apr 2018 17:28:21 GMT

Hi,

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

Exp:

this is how my reports looks

this is how I want it to look.

ID	Description	Total
A-B	Item 1	$300.00

please let me know how this can be achieve.

thank you so much in advance!

sunny_talwar — Mon, 23 Apr 2018 17:40:56 GMT

In the script or in the chart?

Gysbert_Wassenaar — Mon, 23 Apr 2018 17:42:45 GMT

Perhaps like this:

LOAD

concat(ID, '-') as ID,

Description,

sum(Total) as Total

FROM

...source_table...

GROUP BY

Description

;

easternfish — Mon, 23 Apr 2018 18:01:25 GMT

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

easternfish — Mon, 23 Apr 2018 18:29:42 GMT

I was trying it in the chart originally.

sunny_talwar — Mon, 23 Apr 2018 18:31:43 GMT

Then try it like this

Dimensions

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

Description

Expression

Sum(Total)

easternfish — Mon, 23 Apr 2018 18:38:34 GMT

Thank you for all your help!