Divide Value of two colums in qliksense table

[Aspiring_Developer]

Hello All,

I have below scenario:-

Chart:-

Product | Allocated target| Achieved Target 

A| 20| 30 

B|50|100

My requirement is to create a measure for each row named %Achieved like below

A| 20/30--this new measure should show the percentage .

I tried using column()/Column() function but it didn't worked as it gives me blank values.

Please help.

Thanks.

[Taoufiq_Zarra]

@Aspiring_Developer  do you mean column() function ?

to use it you must have two measure

like sum([Allocated target]) and sum([Achieved Target]) in measure

and Product in Dimension

to use this function

see this output:

Dimension: Product

Measures:

1-sum([Allocated target])

2-sum([Achieved Target])

3-Column(1)/Column(2)

output:

[Aspiring_Developer]

Thank You @Taoufiq_Zarra 

However, i do not want to take the sum of  Allocated target and achieved target.

I just want them to be the dimension and then take then divide

allocated target/ achieved target == result in new column for each row for each product.

[Taoufiq_Zarra]

@Aspiring_Developer  if I understood correctly

in dimension product, allocated target and achieved target

in measure ([Allocated target])/([Achieved Target])

output: