topic Re: Set Expression in QlikView

Set Expression

upaliwije — Wed, 12 Feb 2014 10:25:45 GMT

sum( {<[To_YEAR] = {'$(=max([R_YEAR]+1))'},POL_TYPE={'R'}>} [PREMIUM] )

I have two date fields in my module To_Year and R_Year. When I select R_Year and apply above expression calculation is done correctly. That is To_Year=2013 Selected R_year=2012

But if modify the above expression to add 2 years to R_year It does not work

sum( {<[To_YEAR] = {'$(=max([R_YEAR]+2))'},POL_TYPE={'R'}>} [PREMIUM] )

Please help me solve the above problem

Re: Set Expression

Wed, 12 Feb 2014 10:43:52 GMT

Are To_Year and R_YEAR related (through data or any table ) ?

Is it possible that you have data with To_Year=2012 and R_YEAR = 2010 ?

Did you meet the maximum of To_Year (is it a valid value) ?

Fabrice

Re: Set Expression

whiteline — Wed, 12 Feb 2014 10:45:12 GMT

Hi.

Does the [To_YEAR] contains the corresponding years ?

It seems that for +2 you should select 2011.

Re: Set Expression

agilos_mla — Wed, 12 Feb 2014 10:52:43 GMT

Hi,

If you select R_Year=2012 then the set analysis return To_Year = 2014. If 2014 is not present in your dataset, it won't work.

Michael

Re: Set Expression

upaliwije — Wed, 12 Feb 2014 10:53:40 GMT

To_Year and R_Year are from two Master Calenders and relates to Data

Re: Set Expression

upaliwije — Wed, 12 Feb 2014 11:12:20 GMT

All years are present in my data set Even if I select 2010 as R _year it is not working

Re: Set Expression

whiteline — Wed, 12 Feb 2014 18:20:45 GMT

Hi.

Is there any relation between the years fields ?

It's possible that for example R_YEAR=2011 selection cuts the dataset so that there is no any To_YEAR=2013 records, but there are To_YEAR=2012.

You can try this:

sum( {<[To_YEAR] = {'$(=max([R_YEAR]+2))'},POL_TYPE={'R'},[R_YEAR]=>} [PREMIUM] )