Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you need more help post more information. A qlikview document that demonstrates the problem will be most useful.
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.
Its resolved.. One of my Set Expression was -ve.
I tried -($(=bcmg)+$(=acmg)) and it worked well.
Thanks