topic Re: Variable in % calculate expression giving wrong value in Archived Groups

Variable in % calculate expression giving wrong value

Wed, 23 Jul 2025 14:48:52 GMT

Dear Team,

My Variable $(acmg) and $(bcmg) are giving correct values.

Burt for % expression when i use it as below expression it is showing wrong value.

-1+($(=acmg)/$(=bcmg))

Please suggest solution.

Shiv

Re: Variable in % calculate expression giving wrong value

Gysbert_Wassenaar — Thu, 05 Mar 2015 09:05:43 GMT

If you need more help post more information. A qlikview document that demonstrates the problem will be most useful.

Re: Variable in % calculate expression giving wrong value

Thu, 05 Mar 2015 09:29:43 GMT

First i added variables asale, adir etc. All are showing correct values. They are SET Analysis expressions.

Then another variables -

SET acmg = -$(asale)- $(adir)- $(aidrt);

SET bcmg = $(bsale)-$(bdir)-$(bidrt);

This also showing correct values as shown below in pic. But even when i tried to subtract each other its showing wrong figure - It should show - -2213658.5.

Rest I finally need -1+($(acmg)/$(bcmg)) as to show 31.3 %. I can upload sense document cos of its size.

Re: Variable in % calculate expression giving wrong value

Thu, 05 Mar 2015 10:08:07 GMT

Its resolved.. One of my Set Expression was -ve.

I tried -($(=bcmg)+$(=acmg)) and it worked well.

Thanks