topic Re: Diving a Variable using Expression in QlikView

Diving a Variable using Expression

Anonymous — Wed, 26 Aug 2015 11:44:23 GMT

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,

sunilkumarqv — Wed, 26 Aug 2015 11:49:34 GMT

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 — Wed, 26 Aug 2015 11:52:48 GMT

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 — Wed, 26 Aug 2015 11:56:11 GMT

Are you getting wrong values or nothing?

Anonymous — Wed, 26 Aug 2015 12:01:09 GMT

I am getting null values.

Kushal_Chawda — Wed, 26 Aug 2015 12:03:20 GMT

may be try below in variable

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

qlikmsg4u — Wed, 26 Aug 2015 12:03:43 GMT

(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 — Wed, 26 Aug 2015 12:16:46 GMT

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 — Wed, 26 Aug 2015 13:13:43 GMT

not working...

sasiparupudi1 — Wed, 26 Aug 2015 13:21:43 GMT

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)