topic How to write percentage equation in the set expression in QlikView

How to write percentage equation in the set expression

Tue, 28 Jan 2014 03:32:15 GMT

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 — Tue, 28 Jan 2014 03:44:22 GMT

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..

Tue, 28 Jan 2014 04:57:34 GMT

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.

Tue, 28 Jan 2014 05:06:08 GMT

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

phaneendra_kunc — Tue, 28 Jan 2014 05:26:55 GMT

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

=1 - <your percent expression>

and enable Percent as your number format..

Tue, 28 Jan 2014 06:09:50 GMT

hi,

thanks for the solution, much appreciated.

Solution is working.

Thanks,

Smitha