Automate calculation in Qlikview

[kushalthakral]

Dear All

i have some requirement where i would like to automate the calculations like below:

Below is the table

Models	Value	Bif
L	100	16.67
P	200	33.33
Pa	0
L/ P	50

where i am getting Values from System like for Model L its 100

now there are some materials which are commonly used for L and P model shown as L/ P

So Value 50 has to be bifurcated among Model L and P like

for L Model:

(50/(100+200))*100

Thanks

Kushal Thakral

[kushalthakral · Accepted solution]

Well Found out the solution