Qlik Relationship between Challenge and Descriptive dashboards

[Mouni09]

Hello All, I'm trying to write a Qlik script to show the relationship b/w Challenge and Descriptive dashboards
For challenge I have type id = 25, for verbal it's 1
But in both tables, we have Student ID, Certification ID, Class name, similar
But for 25 Type ID, we won't have some certificates that presnet for Type ID 1. There will be status selection different for both Challenge and Descriptive
Challenge will be having 8 different sttaus like- Pass, fail, retry, not submitted, pending review, Invite sent etc. Descriptive will have - Pass, Fail, Retry and Invite send
Here the problem I'm facing is If i select any Descriptive status showing everything 0 in challenge and same in challenge also if I select any challenge name or challege status Descriptive is showing zero
But these 2 challege and Decsriptive will have same Certification ID, Class ID, user ID for the certificates common in both

Wwant to see like this, please help we with ways

[Kaushik2020]

Hi @Mouni09 , Please share a sample dataset for this. seems we need to do some data cleaning to ensure when the user select the status, the data is filtered properly. 

[Mouni09]

Hey, below is the data. We can have other status in challenge and  verbal as I mentioned above and content_id, user_id is my key to join both tables
Descriptive:

Student Name Certification Name Class Name Score Descriptive  Status Aaliyah Hunter Funding A - Invitation Sent Abner Castro Funding A - Invitation Sent Adam Dogole Funding B - Invitation Sent Adam Dogole Funding A - Invitation Sent Adrian Ibarra Funding A - Invitation Sent Alex Coven Funding A - Invitation Sent Alexander Gonzalez Funding A - Invitation Sent Angel Correa Funding A - Invitation Sent Ann BradenStudent Funding B - Invitation Sent Anthony Heredia Funding A - Invitation Sent Anthony Santana Funding A - Invitation Sent Antonio Cummings Funding A - Invitation Sent Anupam Das Funding C - Invitation Sent ariel zinger Funding B 100.0000 Pass

Challenge:

Student Name Student ID Class Name Certification Name Challenge Name Challenge Status Comments Start Date Aaliyah Hunter 83679 A Funding Breach Not Submitted - - Abner Castro 84515 A Funding Breach Not Submitted - - Adam Dogole 84156 B Funding Breach Not Submitted - - Adam Dogole 84156 A Funding Breach Not Submitted - - Adrian Ibarra 84605 A Funding Breach Not Submitted - - Alex Coven 84598 A Funding Breach Not Submitted - - Alexander Gonzalez 84228 A Funding Breach Not Submitted - - Angel Correa 84547 A Funding Breach Not Submitted - - Ann Braden 84192 B Funding Breach Not Submitted - - Anthony Heredia 82856 A Funding Breach Not Submitted - - Anthony Santana 73256 A Funding Breach Not Submitted - - Antonio Cummings 82065 A Funding Breach Not Submitted - - Anupam Das 84614 C Funding Breach Not Submitted - - ariel zinger 81111 A Funding Breach Awaiting Review - 7-27-2025 13:36:41  TT Austin Mcgrane 84281 B Funding Breach Not Submitted - -

[Kaushik2020]

thanks for the message, if you be great to have it in excel so that i can check the modelling. also if you have multiple tables, paste that in multiple sheets.