Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable in % calculate expression giving wrong value

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

Labels (4)
3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
Not applicable
Author

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.

Not applicable
Author

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

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

Thanks