Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to filter a number of claims but using set analysis formulas. I have read many comments in Qlikvew forum. There is not a definite answer how to use <>,>,<. There should be a simple way to use them. It will be disappointing if not.
What I want is to count the number of claims except the ones that are created in error.
I though this should work Count({$<ClaimCancellationReason<>{'Created In Error'}>}ClaimId) but it didn't. Count({$<ClaimCancellationReason={"<>$('Created In Error')"}>}ClaimId) didn't work either.
I have some difficulties to use > and < as well. For instance Count({$<CreatedDate>{'01/06/2015'}>}ClaimId).
I tried count({$<CreatedDate={">{'01/06/2015'}>}ClaimId) didn't work.
Thank you,
Sara
Is the field value blank or NULL in these cases?
Have you tried what Jerry suggested above, using e() function? Something like
=Count({$<ClaimId = E({<ClaimCancellationReason = {'Created In Error'} >} ClaimId) >} ClaimId)
It did work.
Thank you!
This solves my issue as well.Thank you for nice explanation