topic Re: Multiple format for expression in pivot table in QlikView

Multiple format for expression in pivot table

Tue, 01 Jul 2014 16:49:16 GMT

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.

Re: Multiple format for expression in pivot table

vgutkovsky — Tue, 01 Jul 2014 16:55:52 GMT

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

Re: Multiple format for expression in pivot table

sasikanth — Tue, 01 Jul 2014 17:44:18 GMT

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