topic Re: Can someone help with this please? in QlikView

Can someone help with this please?

Mon, 15 Feb 2016 16:00:09 GMT

Hi everyone,

I have the following script that pulls financial data from a QVD I've already built, I need to strip out any value that's been loaded against the current month.

LOAD SchemeNo,

MonthYear,

FUMValue

FROM

UnisureFUM.qvd (qvd);

Basically I'm trying to load everything prior to Feb-2016 (as this is the current month)

Any suggestions as I'm trying a Where clause with a variable I've created and can't get it to work...

Re: Can someone help with this please?

sunny_talwar — Mon, 15 Feb 2016 16:26:10 GMT

May be this:

LOAD SchemeNo,

MonthYear,

FUMValue

FROM

UnisureFUM.qvd (qvd)

Where Num(MonthYear) < Num(MonthStart(Today()));

Re: Can someone help with this please?

avinashelite — Tue, 16 Feb 2016 05:48:25 GMT

check whether you field and variable date format are same and then use the where clause this should solve your issue.

Try like this :

Let vCurrentmonth=MonthStart(Today());

LOAD SchemeNo,

MonthYear,

FUMValue

FROM

UnisureFUM.qvd (qvd)

where MonthYear< $(vCurrentmonth)

where MonthYear< (vCurrentmonth)

NOTE: Make sure your variable(vCurrentmonth) and the field(MonthYear) are in same format

Re: Can someone help with this please?

Anonymous — Tue, 16 Feb 2016 05:53:44 GMT

may be this?

LOAD SchemeNo,

MonthYear,

FUMValue

FROM

UnisureFUM.qvd (qvd) where Num(MonthYear)<>Num(MonthStart(Today()));