topic Re: individual row format possible in QlikView

individual row format possible

Anonymous — Fri, 05 Dec 2014 20:58:38 GMT

I have rows

Prev Bal $40

Balance $60
Loss/Gain % 150.00%

I used num((Balance * 100 / PrevBal), '##.00%')

Still I am not getting % format

I appreciate your efforts

its_anandrjs — Fri, 05 Dec 2014 21:05:20 GMT

It is correct only remove * 100 because you all ready use % format as '##.00%'

=num((Balance / [Prev Bal]), '##.00%')

Regards

Anand

Anonymous — Fri, 05 Dec 2014 21:23:27 GMT

Hi Anand

Thanks for prompt reply

But in case of 0.00000004895% I want to see atleast 0.00% which does not happen here.

Still I can see 0

Thanks again

Anonymous — Fri, 05 Dec 2014 21:58:58 GMT

Hi Anand

After your suggestion, I selected 'Expression Default' in Number tab and working perfectly fine.

I appreciate your answer and thanks