Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Contributor III
Contributor III

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
Contributor III
Contributor III

which variable?

capriconuser
Contributor III
Contributor III

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
Contributor III
Contributor III

i do this but not working

ogautier62
Specialist II
Specialist II

and other variables ?

capriconuser
Contributor III
Contributor III

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 ?