topic Join several tables in App Development

Join several tables

ecabanas — Sat, 16 Nov 2024 04:25:52 GMT

Hi, I extract data from different tables and the result for

How to do that:

Thanks

Counter_754: LOAD SalesId, COUNT(ItemId) AS 'Cerveza_754', sum(Import_Brut) as 'Importe_754' RESIDENT Salesline WHERE Catlevel2='754' and wildmatch(SalesId,'PV0*') GROUP BY SalesId; Counter_758: LOAD SalesId, COUNT(ItemId) AS 'Cerveza_758', sum(Import_Brut) as 'Importe_758' RESIDENT Salesline WHERE Catlevel2='758' and wildmatch(SalesId,'PV0*') GROUP BY SalesId;

Re: Join several tables

dplr-rn — Wed, 09 Oct 2019 13:43:24 GMT

Its not clear what the issue is. What are you trying to achieve?
but on face value it seems wrong doing it in script. the count and sum you mentioned can be done on front end using Set Analysis

Re: Join several tables

ecabanas — Wed, 09 Oct 2019 14:00:46 GMT

I want to join all tables in only One. I don't want to do it in set analisys

Thank's

Re: Join several tables

dplr-rn — Wed, 09 Oct 2019 14:04:35 GMT

joining is just.

table1:

load ....

from xyz;

left join (Table1)

load ...

from abc;

the kind of join depends you your requirement. check this

https://community.qlik.com/t5/QlikView-Creating-Analytics/Understanding-Join-Keep-and-Concatenate/td-p/328379