Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rekha_jv
New Contributor III

Use set expression in a table

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?

6 Replies
OmarBenSalem
Esteemed Contributor

Re: Use set expression in a table

try as follow

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

prat1507
Valued Contributor

Re: Use set expression in a table

maybe this

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

OmarBenSalem
Esteemed Contributor

Re: Use set expression in a table

double quotes must be used (from now on)

Quotes in Set Analysis

rekha_jv
New Contributor III

Re: Use set expression in a table

Thank you so much. It worked.

prat1507
Valued Contributor

Re: Use set expression in a table

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
Honored Contributor III

Re: Use set expression in a table

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 .

May you live in interesting times!
Community Browser