Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I write the expression in qlikview :
I have a the value 65 % . I want the result as 35
eg,
Says, val = 65 %
100 - 65 %
Send me your expression ...
even if it should be something like:
1 - Sum(a) / Sum(b)
Send me your expression ...
even if it should be something like:
1 - Sum(a) / Sum(b)
is it 100 or 100%
if it is 100 then you can do 100-(65%*100)
if it is 100% just multiply the result by 100 (100%-65%)*100