Use set expression in a table

[Anonymous]

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?

[OmarBenSalem]

try as follow

=Only({$<[Received Date]={"$(=vYesdate)"}>}[Case id])

[prat1507]

maybe this

=Only({$<[Received Date]={'$(vYesdate)'}>}[Case id (or Claim id)])

[OmarBenSalem]

double quotes must be used (from now on)

Quotes in Set Analysis

[Anonymous]

Thank you so much. It worked.

[prat1507]

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

[oknotsen]

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 .