topic Help in script in QlikView

Help in script

Tue, 08 Apr 2014 08:11:33 GMT

Good morning All,

I have the following script:

[FY2013 NL TRANS]:LOAD CostCentre,
    ExpenseCode,
    Suffix,
    Date(PostingDate)                    as Date,
    Month(PostingDate)                   as Month,
    Year(PostingDate)                    as Year,
    Narrative,
    BaseValue                            as [FY13 Value],
    CompanyKey
    where ExpenseCode >='8000'
    and (CompanyKey ='01' or CompanyKey ='20' or CompanyKey ='25' or CompanyKey ='29' or CompanyKey ='32' or CompanyKey ='36');SQL SELECT CostCentre,
    ExpenseCode,
    Suffix,
    PostingDate,
    Narrative,
    BaseValue,
    CompanyKey
FROM "EIE_DW".dbo."NL_00_OTRAN";

The data that pulls through are for 2012 and 2013, I only want to work with 2013 data.

How can I specify this in my script?

Thanks

*R*

Re: Help in script

MK_QSL — Tue, 08 Apr 2014 08:20:39 GMT

FY2013 NL TRANS]:

LOAD CostCentre,
    ExpenseCode,
    Suffix,
    Date(PostingDate)                    as Date,
    Month(PostingDate)                   as Month,
    Year(PostingDate)                    as Year,
    Narrative,
    BaseValue                            as [FY13 Value],
    CompanyKey;

SQL SELECT CostCentre,
    ExpenseCode,
    Suffix,
    PostingDate,
    Narrative,
    BaseValue,
    CompanyKey
FROM "EIE_DW".dbo."NL_00_OTRAN"

Where CompanyKey in ('01','20','25','29','32','36' and ExpenseCode >='8000' and

PostingDate >= '2013-01-01' and PostingDate <= '2013-12-31'

You can change Date as per your System Date...

Re: Help in script

ThornOfCrowns — Tue, 08 Apr 2014 08:23:17 GMT

PostingDate >= '2013-01-01' and PostingDate <= '2013-12-31'

will only pull 2013 data.

Re: Help in script

its_anandrjs — Tue, 08 Apr 2014 08:29:47 GMT

Change in load script like

[FY2013 NL TRANS]:LOAD CostCentre,
    ExpenseCode,
    Suffix,
    Date(PostingDate)                    as Date,
    Month(PostingDate)                   as Month,
    Year(PostingDate)                    as Year,
    Narrative,
    BaseValue                            as [FY13 Value],
    CompanyKey
    where ExpenseCode >='8000'
    and (CompanyKey ='01' or CompanyKey ='20' or CompanyKey ='25' or CompanyKey ='29' orCompanyKey ='32' or CompanyKey ='36') and Year(PostingDate) = '2013' ;SQL SELECT CostCentre,
    ExpenseCode,
    Suffix,
    PostingDate,
    Narrative,
    BaseValue,
    CompanyKey
FROM "EIE_DW".dbo."NL_00_OTRAN";

Re: Help in script

senpradip007 — Tue, 08 Apr 2014 08:31:39 GMT

PostingDate Between '2013-01-01' and '2013-12-31'

will load 2013 data.

Re: Help in script

Tue, 08 Apr 2014 08:47:56 GMT

Thank Anand,

It works!