topic Re: After concatenation, existing visualization not showing right results in App Development

After concatenation, existing visualization not showing right results

User2906 — Mon, 05 Dec 2022 20:30:32 GMT

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?

Re: After concatenation, existing visualization not showing right results

vinieme12 — Tue, 06 Dec 2022 07:22:46 GMT

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

Re: After concatenation, existing visualization not showing right results

User2906 — Tue, 06 Dec 2022 16:10:04 GMT

@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 )

Re: After concatenation, existing visualization not showing right results

vinieme12 — Wed, 07 Dec 2022 02:38:55 GMT

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/AggregationFunctions/basic-aggregation-functions.htm))

Re: After concatenation, existing visualization not showing right results

User2906 — Wed, 07 Dec 2022 20:21:10 GMT

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.

Re: After concatenation, existing visualization not showing right results

vinieme12 — Thu, 08 Dec 2022 02:50:13 GMT

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