topic HOW TO CHANGE A NUMBER TO A PERCENTAGE VALUE ???? in QlikView

HOW TO CHANGE A NUMBER TO A PERCENTAGE VALUE ????

Fri, 01 Apr 2011 04:30:41 GMT

Hi guys! This is quite a simple question.

Basically, i have a DISCOUNT table, with 3 different DISCOUNT values, namely 0.7, 0.6 & 0.5.

I added this DISCOUNT dimension into a chart. so now what i want is that, when the discount is clicked to 0.7, the value under the DISCOUNT dimension in the chart be changed to 30%.

1)DISCOUNT table click 0.7

2)DISCOUNT dimension in chart, valu is shown as 30%.

is there any formula to make this happen ?

Thanks in advance! =p

HOW TO CHANGE A NUMBER TO A PERCENTAGE VALUE ????

rahulgupta — Fri, 01 Apr 2011 05:10:52 GMT

Hi Nitesh,

You can use in the chart dimension as follows:

if(DISCOUNT<=1,(1-DISCOUNT)*100)

Hence,when you click 0.7 , it will calculate as (1.0-0.7)*100 = 30

Hope,this works..

HOW TO CHANGE A NUMBER TO A PERCENTAGE VALUE ????

Fri, 01 Apr 2011 06:07:13 GMT

Hi Rahul, thanks for the reply!

This solution is not entirely correct, the correct one is,

1) if(DISCOUNT<=1,(1-DISCOUNT))

2) go to NUMBER, choose the DISCOUNT EXPRESSION, click FIXED TO, Under FORMAT PATTERN, type #,##0, then click the SHOW IN PERCENT (%) box.

Thanks!!

And another thing, this works for every value, other than 1.

Can i ask for a help, can you give me an expression which has,

if(DISCOUNT<=1,(1-DISCOUNT))

and also including an expression which is, when Discount = 1, the data displayed would be, NO DISCOUNT.

can this be done ?