Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
ecak2105
Contributor III
Contributor III

Return yes if two values are identical (even when empty)

Hi,

I am currently facing an issue with identical values.
My goal was to return value Y when two are identical and return N when not identical.

However:
if both are empty it also returns N instead of Y.

My code:
=if(aggr(distinct date(B_DATE_PRE_ASSEMBLY_F),ID) = aggr(distinct date(BXTERMIN_VM),ID), 'J' ,'N')

How do I include a case for Empty values?
I have already included Null values in configuration.

Thanks in advance

Labels (2)
0 Replies