Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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 ?