Thank you Krishna! I applied the expression and it resulted in the dimension providing "Certified" or "Missing" text. It did not hide the rows with "Certified" as the expression result.
Did you try this and it worked? I used it in my third dimension and it removed the Certification name and replaced with "Certified" or "Missing" in the Dimension Column.
Thank you so much for trying to assist me!
So you want to see only the rows which got a status of 'missing'. iF so
Then Please add the calculated dimension
Aggr(MinString(If(CertTypeName = CertTypeRequired, 'Certified', 'Missing')),RankAbbrev,FULLNAME,CertTypeRequired) <> 'Certified',
Aggr(MinString(If(CertTypeName = CertTypeRequired, 'Certified', 'Missing')),RankAbbrev,FULLNAME,CertTypeRequired),
and check 'Suppress when value is null' for the calculated dimension.
then you would having something like below screenshots.
If you are expecting the same result then let me know,
i Can edit your chart expression and will attach the file.
Sorry to take so long to respond, but I got locked out of Qlik Community until they fixed my account.
Thank you so much! That did work.
Just as an FYI and I'll try to follow up...but, when we publish my app to the Accesspoint we use, we cannot see these two tables! I will be posting on that issue separately (now that I can log in again!)
Thank you again!!