topic set Expression in QlikView

set Expression

upaliwije — Wed, 05 Feb 2014 16:18:24 GMT

sum( {$<[TO_YEAR] = {2014},[TO_MONTH]={'JAN'}>} [PREMIUM] )

The above expression is not working properly Can some one let me know whether any thing is incorrect with this expression

Re: set Expression

Wed, 05 Feb 2014 16:23:44 GMT

Please, be more explicit. What does it mean "not properly" ?

Check the fields (low case, upper case) that they are written correctly. QV is case sensitive.

Fabrice

Re: set Expression

luis_pimentel — Wed, 05 Feb 2014 16:25:58 GMT

Did you try '2014' with single quotes, like:

sum( {$<[TO_YEAR] = {'2014'},[TO_MONTH]={'JAN'}>} [PREMIUM] )

Re: set Expression

upaliwije — Wed, 05 Feb 2014 16:31:48 GMT

Although I select Year as 2014 results shown are for the year 2015

Re: set Expression

Wed, 05 Feb 2014 16:36:33 GMT

TO_YEAR and TO_MONTH are two dimensions?

Re: set Expression

upaliwije — Wed, 05 Feb 2014 16:40:30 GMT

Yea two dimensions

Re: set Expression

atsushi_saijo — Wed, 05 Feb 2014 16:43:22 GMT

I also have struggled in Dates. Even 'January' connotates 'January of 2013' if we handle it only with DATE([datefield],'MMM'). In my cautious loading script, I have created in such tools so that we would be ready for using any date range:

	DATEFIELD AS H.DT.O,
	IF(DATEFIELD>0,DATE(DATE#(DATEFIELD,'YYYYMMDD'),'(WWW) DDMMMYYYY')) AS H.DT,
	IF(DATEFIELD>0,'W'&WEEK(DATE#(DATEFIELD,'YYYYMMDD'))) AS H.DT.W,
	IF(DATEFIELD>0,'Q'&CEIL(MONTH(DATE#(DATEFIELD,'YYYYMMDD'))/3)) AS H.DT.Q,
	IF(DATEFIELD>0,MONTHEND(DATE#(DATEFIELD,'YYYYMMDD'),0)) AS H.ME,
	IF(DATEFIELD>0,MONTH(DATE#(DATEFIELD,'YYYYMMDD'))) AS H.MT,
	IF(DATEFIELD>0,YEAR(DATE#(DATEFIELD,'YYYYMMDD'))) AS H.YR,

In such case, January means January of 1984......2014. Q1 means .... and so forth.

Please advise if this works for you.

Re: set Expression

Anonymous — Wed, 05 Feb 2014 16:46:45 GMT

The expression looks fine by itself. Can you upload a sample of your application?