How to write percentage equation in the set expression

[#1]

Hi All,

As per the requirement, i need to show the value in the percentage.

Brief description of the requirement,

Percentage Sales of a product=92%

I want to show 100-92% in the set expression.

Qlikview takes 100 as a numeric value,which should be a percentage value.

Let me know if you need any more information.

thanks in advance,

Smitha

[phaneendra_kunc]

You meant you want to see "100-92%" as your output, if the expression out put is 92% ?

or you want to see the difference 100-92 % which is 8% then you have to go with this expression...

=1 - <your percent expression>

and enable Percent as your number format..

[#3]

hi,

you got the requirement,

I want to display 8% as output.

My expression result is 92%, now i need to show 100-92%= 8%,

How do i subtract 100-92%?? , where 100 is numeral, how to display in percentage value.

could you please come up with the set expression.

thanks in advance,

Smitha.

[#4]

Hi, what is your expression? Can you paste here the example?

[phaneendra_kunc · Accepted solution]

As I said don't minus from 100 just minus it from 1

=1 - <your percent expression>

and enable Percent as your number format..

[#6]

hi,

thanks for the solution, much appreciated.

Solution is working.

Thanks,

Smitha