Need Inner Join results in Qlik sense table box based on selections in Alternate states.

[sudheersakamuri]

Dear Qlik Community,

Hope Everyone is doing great !!

Need Help on below requirement. 

Below is the Example input table. Please find the attachment.

Emp Name	Year	Appraisal
Sudheer	2023	Excellent
Sudheer	2022	Very Good
Suresh	2023	Excellent
Suresh	2022	Good
Sudharsh	2023	Excellent
Sudharsh	2022	Very Good
Ramesh	2022	Excellent
Ramesh	2023	Average
Khan	2022	Very Good
Khan	2023	Excellent

Now, in the dashboard I have created Year and Appriasal filters and assigned to Alternate State A.

created another Year and Appriasal filters and assigned to Alternate State B.

For Example, If I select Year 2022 &  Appraisal Very Good in State A and select Year 2023 & Appraisal Excellent in State B, the output table should contain records avaialble in both data sets like below.

	Expected Output Table
Emp Name	Year	Appraisal
Sudheer	2023	Excellent
Sudheer	2022	Very Good
Sudharsh	2023	Excellent
Sudharsh	2022	Very Good
Khan	2022	Very Good
Khan	2023	Excellent

[rwunderlich]

Only({[State A] + [State B]}Appraisal)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[sudheersakamuri]

Dear @rwunderlich 

Thank you very much for the response 🙂.

No results in the output table with this expression.

Expression used: Only({[State A] + [State B]}Appraisal)

I am attaching the .qvf file for the reference.

Kindly do needful.