topic Re: Hi Friends in QlikView

Hi Friends

Mon, 30 Jun 2014 07:28:11 GMT

Hi friends !

i'm having a doubt in applying set analysis for calculating the claims paid of year wise.

Here is my expression

Sum({$<year={">vCurrentYear-2>vCurrentYear-1<vCurrentYear"}>}CE_AMT_LC_1)

my output should be

year ClaimsPaid

2014 324.23

2013 452.12

2012 325.23

Is there any mistake in my expression? please anyone help me out.

Regards

Krsh

Mon, 30 Jun 2014 07:35:18 GMT

Hi Krish

May I know the clear requirement. You want to see the output for past three years claims right?

if u want like above requirement please find the below expression it will helps you

=sum({$<Year={'>=$(VPrevsecondYear)<=$(VMaxYear)'}>}CE_AMT_LC_1)

Variables:

VPrevsecondYear=max(Year(date(Datefield,'DD-MM-YYYY')))-2

VMaxYear=Max(Year(Date(Datefield,'DD-MM-YYYY')))

Hope this will helps you

Gysbert_Wassenaar — Mon, 30 Jun 2014 07:35:29 GMT

Try Sum({$<year={">=$(vCurrentYear)-2<=$(vCurrentYear)"}>}CE_AMT_LC_1)

Anonymous — Mon, 30 Jun 2014 07:38:38 GMT

Hi,

try this

sum({<newyear={'$(=max(newyear)-2)','$(=max(newyear)-1)', '$(=max(newyear))'}>}Sales)

If you are using a variable then replace max(newyear) with it.

HTH

ravi n.