Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Expression problem

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 %

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

Send me your expression ...

even if it should be something like:

1 - Sum(a) / Sum(b)

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Send me your expression ...

even if it should be something like:

1 - Sum(a) / Sum(b)

ramoncova06
Specialist III
Specialist III

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