topic Re: need to put variable on value till today in QlikView

need to put variable on value till today

yadav_anil782 — Fri, 21 Aug 2015 05:49:04 GMT

Dear Comunity,

i have data in table year 2010 to year 2016 but i want to represent data only till sysdate mean till today so i'm puting this script in expresion but its not working plz suggest how to use vtoday variable in this script

=sum(COMPONENT_AMOUNT)<=vtoday

Re: need to put variable on value till today

sunny_talwar — Fri, 21 Aug 2015 05:55:43 GMT

May be this:

If(DatabaseYearFieldName <= Year(Today()), Sum(COMPONENT_AMOUNT))

Re: need to put variable on value till today

Kushal_Chawda — Fri, 21 Aug 2015 06:02:28 GMT

Try with set analysis

=Sum({<Year = {"<=$(=year(today()))"}>}COMPONENT_AMOUNT)

Re: need to put variable on value till today

Anonymous — Fri, 21 Aug 2015 06:23:10 GMT

Anil,

try this one..

=sum({<DateFieldName={"<=$(=date(today(), req format)))"}>} Component_Amount)

Re: need to put variable on value till today

jonathandienst — Fri, 21 Aug 2015 06:25:45 GMT

In script, filter out data withe dates after today as:

LOAD ...

FROM ...

WHERE myDateDateField <= Today();

SQL SELECT ...

FROM ...

WHERE myDateDateField <= '$(vtoday)';

The actual script depends on how vtoday is defined....

In expressions in the front end

Sum(If(myDateField <= '$(vtoday)', amount))

Sum({<myDateField = {"<=$(=vtoday)"}>} amount)

Again, the exact syntax depends on how vtoday is defined.

Re: need to put variable on value till today

jsingh71 — Fri, 21 Aug 2015 06:46:46 GMT

See this

Re: need to put variable on value till today

Fri, 21 Aug 2015 07:02:37 GMT

Try the below expression @Anil

=sum({<Date = {"<=$(=today())"}>}COMPONENT_AMOUNT)

Re: need to put variable on value till today

yadav_anil782 — Fri, 21 Aug 2015 07:09:04 GMT

Thanks Balraj