Multiple format for expression in pivot table

[#1]

I have a pivot table with one expression, where some numbers are whole number and some are needed to be in percentage format. Is there anyway we can do this? In excel it is easy as we choose only cells that needed to be in percentage can be done so by right clicking and format cell but I don't know how to do this in QlikView. When I go to properties and Number to change the format, it changes each and every format to percentage. Any help will be really appreciated.

Thanks.

[vgutkovsky]

In the Number tab, leave it at "Expression Default." In the expression itself, you can use the num() function to format.

The format for integer would be num(_____,'#,##0')

The format for decimal would be num(_____,'#,##0.00%')

Hope this helps!

Vlad

[sasikanth]

Hi

Try some thing like below

if(Exp1>value1,num(exp,,'#,##0.00%'),num(exp,'#,##0'))

i am not sure about it,but

May be help full