topic Re: Not Match Function_ Problem in QlikView

Not Match Function_ Problem

Mon, 24 Nov 2014 10:47:22 GMT

Hi All,

I want to eliminate data on basis of NOT Match function but i am not getting expected results.

Lets say my code is

LET Var1 = Today()- 1;

Load * from XYZ.QVD

Where Not mact (Date1, '$(Var1)')

But still I am getting Today()- 1 data.

Even if write like:

Load * from XYZ.QVD

Where Not mact (Date1, '11/23/2014').

Still I am getting 11/23/2014 data.

The way I am eliminating With Not match is correct? or is there an another way?

BR ,

Neehu

Gysbert_Wassenaar — Mon, 24 Nov 2014 10:49:55 GMT

Try this:

LET Var1 = num(Today() - 1);

Load * from XYZ.QVD

Where num(Date1) <> $(Var1);

Mon, 24 Nov 2014 10:53:18 GMT

HI Gysbet,

WHat if I want to eliminate two dates with two variables?

Gysbert_Wassenaar — Mon, 24 Nov 2014 10:58:52 GMT

Use two clauses: Where ...condition1... or ...condition2...

Mon, 24 Nov 2014 11:02:03 GMT

Cant I use like this:?

LET Var1 = NUm(Today()- 1);

LET Var2 = Num(Today()- 2);

Load * from XYZ.QVD

Where Not match (Date1, '$(Var1)', '$(Var2)')

rubenmarin — Mon, 24 Nov 2014 11:02:12 GMT

Hi, are you sure about the date format stored in xyz.qvd?

If it's not MM/DD/YYYY (maybe Date1 also has the time part?) you can try:

Load * from XYZ.QVD

Where Not match (Date(Date1, 'MM/DD/YYYY'), '11/23/2014').

Gysbert_Wassenaar — Mon, 24 Nov 2014 11:10:20 GMT

Maybe. It depends on the format of the Date1 field. You may have to use the date function as Ruben Marin says above.