Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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 ?