Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

Hi,

what are your variable ?

maybe again :  = before expression in variable definition

regards

Contributor III
Contributor III

which variable?

Contributor III
Contributor III

i have this

=Max(PF_Year)

in vCYear

Specialist II
Specialist II

vCYear for example

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

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

Contributor III
Contributor III

i do this but not working

Specialist II
Specialist II

and other variables ?

Contributor III
Contributor III

i use same condition for all variables

Specialist II
Specialist II

display each variable to see which expression is wrong

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