topic Re: set Expression in QlikView

set Expression

upaliwije — Fri, 14 Feb 2014 15:26:05 GMT

Sorry I attched wrong file Pls see the correct file

I have Created the following expression

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

But It is not working. I attach herewith the file. What I really need is the following calculation

When User Select R_Year=2013 and R_Month=Jan

The Result should be To_Year=R_Year+1(2014)

To_Month=R_Month(Jan)

Type+'F'

and sum of Premium

Please help me to write the correct Expression

Re: set Expression

Gysbert_Wassenaar — Fri, 14 Feb 2014 15:47:38 GMT

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

Re: set Expression

upaliwije — Fri, 14 Feb 2014 16:08:28 GMT

Hi Gysbert

Thanks very much

it is working fine. I want one more modification to be done. That is I want to exclude records from the above expression where R_Year=2013 and R_Month=Jan (Records relating user selected Year and Month). Pls Help.

Thanks In Advance

Re: set Expression

MK_QSL — Fri, 14 Feb 2014 16:09:34 GMT

Remove below from your expression

R_YEAR=, R_MONTH=,

Re: set Expression

upaliwije — Fri, 14 Feb 2014 16:17:57 GMT

Then only the records relating to that particular period remains

T_DATE	R_DATE	PERIOD_TO	Col 1
2013-01-22	2013-01-22	2014-01-21	-862
2013-01-21	2013-01-21	2014-01-05	-23,127
2013-01-17	2013-01-17	2014-01-04	-7,615
2013-01-29	2013-01-29	2014-01-06	-24,505
2013-01-11	2013-01-13	2014-01-12	-8,352
2013-01-31	2013-01-31	2014-01-01	-40,055
2013-01-11	2013-01-11	2014-01-06	-882
2013-01-18	2013-01-18	2014-01-16	-6,768
2013-01-30	2013-01-30	2014-01-28	-19,324
2013-01-10	2013-01-10	2014-01-09	-16,554
2013-01-30	2013-01-30	2014-01-27	-19,784

But in fact what I want is to exclude above records and to other records to remain