Script modification for P&L

Thu, 10 Apr 2014 07:44:41 GMT

Hi all,

I'm trying to create a QV report for SAP data txt file in order to get a qvd file.

The material thus needs to be modified to get the data in better format.

Here is an examle of the script (each field is segregated for one column data txt file):

@18:21 as Year,

@22:25 as CompanyID,

@26:27 as LedgerType,

@28:37 as CostCenterNro,

@38:47 as AccountNro,

@48:60 as AmountJan,

@61:61 as Mark1,

Problem1:

Mark1 specifies the sign (+/-) for values for AmountJan (January). How can I modify this in script, so that I get the values strait with proper sign?

Problem 2:

The values in AmountJan for example carries two decimals in the value. How can I add comma to get correct value?

Example: 761686 --> 7 616,86

As you might notice, I'm fairly new with Qlikview. Hopefully you can help me with this too.

Thank you in advance,

Joni

Re: Script modification for P&L

preminqlik — Thu, 10 Apr 2014 08:07:28 GMT

HI THERE TRY THIS

lOAD *,

(Mark1&AmountJan) /100 as Amount

resident orginal;

drop table orginal;