Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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 ?