Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ivan_will
Contributor II

very tricky - calculation based on base KBIs

Hi all,

Here I have

ID- id of KBI

name - name of the KBI

calculation - formula how to calculate the KBI

IDnamecalculation
16a([100017]/[100013])
17b(([100001]+[100002]+[100003])/[100013])
18c([100001]/([100023]*[100004]))
100023d[100023]
100004e[100004]
19f([100023]*[100004])
100018g[100018]
100017h[100017]
100013i[100013]
100001j[100001]
100002k[100002]
100003l[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!

3 Replies
Not applicable

Re: very tricky - calculation based on base KBIs

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

jason_michaelid
Honored Contributor II

Re: very tricky - calculation based on base KBIs

Hi Ivan,

Maybe my response here will help you:

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

Jason

ivan_will
Contributor II

Re: very tricky - calculation based on base KBIs

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)

Community Browser