topic Re: calculation on the bases on current year in QlikView

calculation on the bases on current year

capriconuser — Thu, 12 Jul 2018 06:52:54 GMT

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 ..

ogautier62 — Thu, 12 Jul 2018 07:03:26 GMT

Hi,

what are your variable ?

maybe again : = before expression in variable definition

regards

capriconuser — Thu, 12 Jul 2018 07:13:48 GMT

which variable?

capriconuser — Thu, 12 Jul 2018 07:15:02 GMT

i have this

=Max(PF_Year)

in vCYear

ogautier62 — Thu, 12 Jul 2018 07:15:39 GMT

vCYear for example

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

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

capriconuser — Thu, 12 Jul 2018 07:25:44 GMT

i do this but not working

ogautier62 — Thu, 12 Jul 2018 07:54:54 GMT

and other variables ?

capriconuser — Thu, 12 Jul 2018 08:02:25 GMT

i use same condition for all variables

ogautier62 — Thu, 12 Jul 2018 08:12:14 GMT

display each variable to see which expression is wrong

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