Bring Percentage in the normal value column

[kalyandg]

Hi All,

I have a requirement from Customer,  I need to build the report as per the excel format.

I had brought the format as per the excel, but I cant able to bring the percentage in middle of the normal value column.

Format in Excel:

Gross Profit	915
Gross Profit as % Net Sales	32%
T&W (Supply Chain)	(203)
T&W as % Net Sales	-7%

As per above I need to bring the same in Qlikview, is it possible to do in Qlikview?

If yes please help me to build the report.

Thanks in Advance,

Best Regards,

Kalyan.D

[preminqlik]

hi,

yes you can..send sample excell...

[kalyandg]

hi Prem,

Format is attached

[amit_saini]

Hi Kalyan,

This very much possible in Qlikview, Taking your above mentioned example . Here you can implement new field called

Rowno( which will be having number like1,2,3......)  From your above example you want to implement % t row number 2 & 4.

So here you can give a condition in expression that is :

=if(match(rowno, '2','4','Num(Field,'##.##%')',''Field)

In this case against rowno 2 and 4 you will be getting your numbers in % format.

Thanks,

AMIT

[kalyandg]

hi Amit,

Thanks for your reply.

But till I am not clear about your comments.

Can you please go through the attached excel?

Thanks,

Kalyan.D

[Peter_Cammaert]

This is sort of an extended P&L. I don't know how you'll manage to display the different P&L items, but usually an artificial dimension is created that lists the different P&L items to be displayed. Add a flag field to that list of items and set it to PERC when a percentage should be shown, and something else (or just nothing) when the regular value should be displayed.

Your expression will become somthing like:

  =IF(PNLFlag = 'PERC', num(sum(Values) / sum(TOTAL NetSales), '##0%'), sum(Values))

Of course the expression itself may require some tuning as you didn't supply details about the actual data.

Best,

Peter

[stevedark]

The thing you also need to watch here is that you need to set the Number format to Expression Default as you are setting the number format in the expression with the Num function.  Any number format set on the chart will overwrite that which is set in the expression.

- Steve