Set Analysis to Show Un Associated Records In Qlik Sense

[h_prakash]

Hi I have a Requirement  in the Qlik Sense

I have two tables

Project Details:

Project	Standar Year
1	2015
2	2016
3	2017

Amount Details:

Project	Amount Year	Amount
1	2016	10
1	2017	20
1	2018	30
2	2016	40

I have a  Amount Year Filter where user will select as 2017

He wants a  table to like this

Project	Amount
1	20
3	0

He Wants 3 Project as Standard Year equals to Amount year with Amount as 0.

Please help in this regard.

Thanks

Hari

[srishsum2017]

Hi,

I am sharing 2 files with you, there are 2 methods to do this on front end and backend.

Please find the attached file for the reference.

Thanks & Regards,

Sumit Kumar Srivastava

[h_prakash]

Hi Ruben Thank you for the response. In the File you have provided it is working and helped me in understanding the logic and I really appreciate that. but When I Apply the same logic in the Qlik Sense Amount columns are showing nulls. More over if I select any other selections in the filters it is showing nulls as well.