topic Date Range in Set Expressions in QlikView

Date Range in Set Expressions

Tue, 08 Apr 2014 09:07:52 GMT

I have a variable defined

SET vPE_date = date#('31/Oct/2013');

Now I am trying to use it in set expression and I am trying as follows:

Sum({$<ISSUEDT= {'<= $(vPE_date)'}>} NET_CLAIM_PAID)

However this is not working.

Can someone guide me why.

Thanks.

MK_QSL — Tue, 08 Apr 2014 09:12:05 GMT

Try to Define Your variable as below

Let vPE_date = Date(Date#('31/Oct/2013','DD/MMM/YYYY'));

Use

Sum({$<ISSUEDT= {"<=$(=vPE_date)"}>} NET_CLAIM_PAID)

its_anandrjs — Tue, 08 Apr 2014 09:17:25 GMT

You have to make change in script it is not SET it would be LET

LET vPE_date = Date(Date#('31/Oct/2013','DD/MMM/YYYY'),'DD/MM/YYYY');

and in expression

Sum({$<ISSUEDT= {"<= $(vPE_date)"}>} NET_CLAIM_PAID)

sushil353 — Tue, 08 Apr 2014 09:17:51 GMT

Hi,

Try below:

LET vPE_date = Date(date#('31/Oct/2013').'DD/MMM/YYYY');

Sum({$<ISSUEDT= {"<= $(vPE_date)"}>} NET_CLAIM_PAID)

Make sure that ISSEDT should have DD/MMM/YYYY format.. if not then change the format of variable vPE_date accordingly

HTH

Sushil

Tue, 08 Apr 2014 09:18:31 GMT

Thanks it worked. Don't know why but it worked