Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
As I said don't minus from 100 just minus it from 1
=1 - <your percent expression>
and enable Percent as your number format..
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..
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.
Hi, what is your expression? Can you paste here the example?
As I said don't minus from 100 just minus it from 1
=1 - <your percent expression>
and enable Percent as your number format..
hi,
thanks for the solution, much appreciated.
Solution is working.
Thanks,
Smitha