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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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