topic Qlik Sense | Set Analysis Help for summing across dimensions from different table in App Development

Qlik Sense | Set Analysis Help for summing across dimensions from different table

AnkitMadhukar — Mon, 20 Dec 2021 21:08:46 GMT

Hi Everyone ,

Can I get your help with this use case

There are two tables associated on LOCID.

Table A

LOCID	Amount	Date
1	20	1/1/2020
2	30	1/2/2020
3	10	1/3/2020
4	20	1/4/2020

Table B

LOCID	NAME
2	A
3	B

I want to write a set analysis that gives me sum(amount) for only those LOCIDs that are present in Table B.
So in this case the sum should be 40 (for LOCID 2 and 3)

I did try the P() function but to no avail.

Thank you
Ankit

Re: Qlik Sense | Set Analysis Help for summing across dimensions from different table

PriyankaShivhare — Tue, 22 Dec 2020 08:51:39 GMT

In the load Script:

Map_TableBLOCID:

Mapping load LOCID,

Resident Table B

Table A:

LOCID,

Amount,

Date,

Applymap('Map_TableBLOCID',LOCID,0) as LOCID_FLAG;

Load * Inline[

LOCID,Amount,Date
1,20,1/1/2020
2,30,1/2/2020
3,10,1/3/2020
4,20,1/4/2020

];

In the FrontEnd:

Expression:

sum({<LOCID_FLAG={1}>}Amount)

Thanks,

Priyanka

Re: Qlik Sense | Set Analysis Help for summing across dimensions from different table

agigliotti — Tue, 22 Dec 2020 09:47:39 GMT

Hi @AnkitMadhukar ,

maybe this:

sum( {< NAME = {"*"} >} Amount )

I hope it can help.

Best Regards
Andrea