Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

Hi,

what are your variable ?

maybe again :  = before expression in variable definition

regards

Highlighted
Contributor III
Contributor III

which variable?

Highlighted
Contributor III
Contributor III

i have this

=Max(PF_Year)

in vCYear

Highlighted
Specialist II
Specialist II

vCYear for example

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

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

Highlighted
Contributor III
Contributor III

i do this but not working

Highlighted
Specialist II
Specialist II

and other variables ?

Highlighted
Contributor III
Contributor III

i use same condition for all variables

Highlighted
Specialist II
Specialist II

display each variable to see which expression is wrong

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