Diving a Variable using Expression

[Anonymous]

Hi All,

I have a variable as 'vVol' with expression as -

sum({$<$(vFlag)= {'1'}>}vol1) + sum({$<$(vFlag)={'1'}>}vol2)

When I try to divide above variable with some expression, I am not getting the expected value for example -

($(vVol)

/(sum({$<$(vFlagP)= {'1'}>}vol1) + sum({$<$(vFlagP)={'1'}>}vol2)))-1

Can anyone pls assist.

Regards,

MK

[sunilkumarqv]

Create a variable like below

vVol=(sum({$<$(vFlag)= {'1'}>}vol1) + sum({$<$(vFlag)={'1'}>}vol2))

can you share sample App so we can work on that

[jonathandienst]

vVol has two terms, so you need to wrap it in an extra pair of brackets, otherwise only the 2nd term is being divided:

(($(vVol)) / (sum({$<$(vFlagP) = {'1'}>}vol1) + sum({$<$(vFlagP) = {'1'}>} vol2)))-1

[Kushal_Chawda]

Are you getting wrong values or nothing?

[Anonymous]

I am getting null values.

[Kushal_Chawda]

may be try below in variable

rangesum(sum({$<$(vFlag)= {'1'}>}vol1) )+ rangesum(sum({$<$(vFlag)={'1'}>}vol2))

[qlikmsg4u]

(sum({$<$(vFlag)= {'1'}>}vol1) + sum({$<$(vFlag)={'1'}>}vol2))/((sum({$<$(vFlagP)= {'1'}>}vol1) + sum({$<$(vFlagP)={'1'}>}vol2)))-1)

try the above one, if that works fine

do like this

($(vVol))/((sum({$<$(vFlagP)= {'1'}>}vol1) + sum({$<$(vFlagP)={'1'}>}vol2)))-1)

[sasiparupudi1]

you have the same expression in the variable and in the denominator??

put this in a text object sum({$<$(vFlagP)= {'1'}>}vol1) + sum({$<$(vFlagP)={'1'}>}vol2))) and see if returns a valid value

[Anonymous]

not working...

[sasiparupudi1]

you can not use the expression like this

sum({$<$(vFlagP)= {'1'}>}vol1)

try changing it as follows

sum({$<YourDimension={1}>}Vol1)+sum({$<YourDimension={1}>}Vol2)