After concatenation, existing visualization not showing right results

[User2906]

Hi all,

I concatenated two sources, and the existing visuals show me 2 rows of data one for each source, but when I create the exact same visual from scratch, I get the aggregated row (combination of the 2 rows) . What could be the Issue

Is there a way to resolve this?

[vinieme12]

Charts will automatically aggregate based on dimension values, you need to add a field to your visualisation that differentiates between these two sources

example

Table:
load *,'Source1' as Source inline [
ID,party_id,amount
1002,101,1000000
1004,101,20000
1005,105,1150
2001,201,30000
2002,201,22500000
2003,201,400000
];

Concatenate(Table)
load *,'Source2' as Source inline [
ID,party_id,amount
1002,101,1000000
1004,101,20000
1005,105,1150
2001,201,30000
2002,201,22500000
2003,201,400000
];

Then in charts add the field "Source" to see the separate rows

[User2906]

@vinieme12 Thank you for your reply. Yes that is the procedure I have followed and assumed that the tables would automatically aggregate based on the Dimensions. But that's not the case, I am doing a day level aggregation and I get separate rows for each day for the 2 different sources even though I have not added a source.

These tables were already existing . If I create a new table they do automatically aggregate. 

Please refer screenshot below. ( the field covered up is common for all rows so it won't cause a  prob )

[vinieme12]

those are showing in separate rows because you have different dimension values 

different timestamp, highlighted below

also aggregate your measure field using an aggregation function 

(https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/Aggrega...))

[User2906 · Accepted solution]

I got it resolved. It was because one of the measure was wrongly added as a Dimension and hence it was not Aggregating. Thank you for your help as your reply made it apparent that the issue was with the visual and not the modelling.

[vinieme12]

great, can you close the thread by marking a response as a solution