topic Re: match in QlikView

match

Thu, 26 Nov 2015 09:24:40 GMT

Hi,

I have variables as follows:

vCurrentYear=Year(Today())

vPreviousYear=Year(Today())-1

The script as:

LOAD	Distinct
	[Year Count] as [Year],
	[From Month],
	[From Month No],

FROM Calender_Dimension.qvd(qvd)

where Match(year([Calendar Date]),'$(vCurrentYear)','$(vPreviousYear)');

when i reload it is throwing error.

can any 1 tell y?

Re: match

mohamed_ahid — Thu, 26 Nov 2015 09:27:45 GMT

from where came [Calendar Date] used in match function ?

Re: match

tresB — Thu, 26 Nov 2015 09:28:33 GMT

What is the error message you get? Here, in your share script couple of errors are there. Missing semi colons after variable declaration; unwanted comma after last field in load...are they typo?

Re: match

buzzy996 — Thu, 26 Nov 2015 09:28:41 GMT

pls share ur error with app?

"Calendar Date" is there in ur Calender_Dimension.qvd(qvd)?

Re: match

Thu, 26 Nov 2015 09:28:58 GMT

from Calender_Dimension

Re: match

Thu, 26 Nov 2015 09:29:17 GMT

yes

Re: match

Mark_Little — Thu, 26 Nov 2015 09:29:55 GMT

Hi,

First thing i would check your variables are being populated correctly.

Add a Trace after you populate them.

Trace $(vCurrentYear):

Trace $(vPreviousYear);

Mark

Re: match

Anonymous — Thu, 26 Nov 2015 09:33:10 GMT

Hi, try with this:

let vCurrentYear=Year(Today());
let vPreviousYear=Year(Today())-1;

LOAD	Distinct
	[Year Count] as [Year],
	[From Month],
	[From Month No],

FROM Calender_Dimension.qvd(qvd)

where Match([Year Count],'$(vCurrentYear)','$(vPreviousYear)');

Elena

Re: match

buzzy996 — Thu, 26 Nov 2015 09:33:11 GMT

can u share ur .qvw?

Re: match

jagan — Thu, 26 Nov 2015 09:33:37 GMT

Hi,

Try like this

Data:

LOAD	Distinct
	[Year Count] as [Year],
	[From Month],
	[From Month No],

FROM Calender_Dimension.qvd(qvd)

where year([Calendar Date]) >= Year(Today() - 1);

Hope this helps you.

Regards,

jagan.

Re: match

mohamed_ahid — Thu, 26 Nov 2015 09:33:41 GMT

you schould add Match(year([Calendar Date]),'$(vCurrentYear)','$(vPreviousYear)')=1 or 2 .depending on which year you want to filter data .

check help (F1) for more explication nabout match function .

Re: match

Thu, 26 Nov 2015 09:52:39 GMT

s they r typo graphical errors

Re: match

Thu, 26 Nov 2015 09:53:51 GMT

i have years from 1980 to 2020 i cant use >= and <= i have to use match.

Re: match

buzzy996 — Thu, 26 Nov 2015 10:00:24 GMT

r u tried tis way,

Match(year([Calendar Date]),Year(Today() ),Year(Today() - 1)) --some how work around.

the problem with ur match function syntax.

Re: match

Anonymous — Thu, 26 Nov 2015 10:04:18 GMT

Hi,

can you modify your script by this one?:

LOAD Distinct Year Count] as [Year],

[From Month],

[From Month No]

from Calender_Dimension.qvd(qvd)

where year([Calendar Date]) >= $(vPreviousYear) and year([Calendar Date]) <= $(vCurrentYear)

**Notice that I removed the comma after the [From Month No] field, it could be the main error

**Also i removed the single quote of the variables

Please, check it and modify what you need, but I think this is the way

Re: match

tamilarasu — Thu, 26 Nov 2015 10:19:16 GMT

Hi Prudvi,

Check the below script,

vCurrentYear=Year(Today());
vPreviousYear=Year(Today())-1;

LOAD Distinct
    [Year Count] as [Year],
    [From Month],
    [From Month No]
FROM Calender_Dimension.qvd(qvd)
where Match(year([Calendar Date]),'$(vCurrentYear)','$(vPreviousYear)');

Re: match

effinty2112 — Thu, 26 Nov 2015 12:17:09 GMT

You could use this variable

vFromDate=YearStart(Year(Today())-1);

With this Where clause

FROM Calender_Dimension.qvd(qvd)

where [Calendar Date] >= $(vFromDate);

Re: match

Fri, 27 Nov 2015 09:15:12 GMT

Hi all, i tried in the same way for which i marked as correct answer ; the only wrong was that my file was a corrupted one.....

I made it new n its working fine.

once again thanks to this huge response:)