Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to Qlik Sense and trying to use set expression in a table
=Only({$<[Received Date]={vYesdate}>}[Case id (or Claim id)]) as new measure in a table
Where variable in load editor is
Let vYesdate = Date(Today()-1,'YYYY-MM-DD')
Could any one help me please?
try as follow
=Only({$<[Received Date]={"$(=vYesdate)"}>}[Case id])
maybe this
=Only({$<[Received Date]={'$(vYesdate)'}>}[Case id (or Claim id)])
double quotes must be used (from now on)
Thank you so much. It worked.
It's not a must, it's necessary only when you've a conditional statement inside your set analysis. Though it is safe to use.
Anyways thanks for pointing it out to me. omarbensalem
Regards
Pratyush
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .