topic Re: very tricky - calculation based on base KBIs in QlikView

very tricky - calculation based on base KBIs

ivan_will — Fri, 15 Nov 2013 10:52:18 GMT

Hi all,

Here I have

ID- id of KBI

name - name of the KBI

calculation - formula how to calculate the KBI

ID	name	calculation
16	a	([100017]/[100013])
17	b	(([100001]+[100002]+[100003])/[100013])
18	c	([100001]/([100023]*[100004]))
100023	d	[100023]
100004	e	[100004]
19	f	([100023]*[100004])
100018	g	[100018]
100017	h	[100017]
100013	i	[100013]
100001	j	[100001]
100002	k	[100002]
100003	l	[100003]

Now I want to calculate kbi-s 16,17,18, 19 using the formula in 'calculation' field. This calculation has to be in the layout because every base kbi - ID filed - has in the Database its Numerator and Denominator that's why I have to calc all the kbis in the layout

Any suggestions how to do it?

Thanks in advance!

Re: very tricky - calculation based on base KBIs

Fri, 15 Nov 2013 11:18:17 GMT

Hi Ivan,

you can use a mapping table in the script to map ID as calculation

Then use applymap('MapTableName', ID) as Expr

And use Expr in calculation field

best regards

christian

Re: very tricky - calculation based on base KBIs

Jason_Michaelides — Fri, 15 Nov 2013 11:28:27 GMT

Hi Ivan,

Maybe my response here will help you:

http://community.qlik.com/thread/99094

Jason

Re: very tricky - calculation based on base KBIs

ivan_will — Fri, 15 Nov 2013 12:26:02 GMT

Hi Jason, Chris,

the problem here is much more complicated, but the mistake is mine as I didn't say it in a more detailed way.

Every base KBI comes from BW with Numerator and Denominator - there is not only one Field as a Value. So you have to divide by the denominator , other cases also occur ...

However thanks, I will try to figure out this case with my own forces. I have developed a lot so the last 5% are waiting to be done (but the hardest)