Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

calculation on the bases on current year

i try to do some calucation and want values current year values i do this

($(CPaid) + $(COS) + $(vINew))/

(Sum{<PF_Year={'$(vCYear)'},PFMonth=,PFQuarter=>}

($(vEDuration)/ (PEDate - PEDate + 1)* GPREMIUM))

but this shows not exact value want i want ...  the vaue is 23% and this shows 1.77 something ..

8 Replies
ogautier62
Specialist II
Specialist II

Hi,

what are your variable ?

maybe again :  = before expression in variable definition

regards

capriconuser
Creator
Creator
Author

which variable?

capriconuser
Creator
Creator
Author

i have this

=Max(PF_Year)

in vCYear

ogautier62
Specialist II
Specialist II

vCYear for example

if it's :  max('a field date')

it should be :   = max('field date')

capriconuser
Creator
Creator
Author

i do this but not working

ogautier62
Specialist II
Specialist II

and other variables ?

capriconuser
Creator
Creator
Author

i use same condition for all variables

ogautier62
Specialist II
Specialist II

display each variable to see which expression is wrong

PEDate - PEDate + 1 = 1, what is it ?