topic Re: Match with numbers in QlikView

Match with numbers

fkeuroglian — Fri, 31 Oct 2014 13:09:14 GMT

Hi expert,

i am using the function match with numbers(or dates) and not respond, if i try using text work ok

i want to load information only for some specific dates that i will pass in a .txt later

thank you a lot , i attached a qvw and an excel where i try

Fernando

MK_QSL — Fri, 31 Oct 2014 13:13:25 GMT

Directory;

LOAD Id,

[Compra 1] as Compra,

FROM

[Gastos - Copy.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Match(Date(Id),Date('13/05/2007'),'DD/MM/YYYY');

maleksafa — Fri, 31 Oct 2014 13:16:32 GMT

just change the where condition to the below

where MATCH(date(Id),date('13/05/2007'));

fkeuroglian — Fri, 31 Oct 2014 13:32:16 GMT

Perfect, thank you Malek

if i wan to put more than one value? or a list that i have in a variable?

where MATCH(date(Id),date('13/05/2007','14/05/2007'));

how would be? thank you a lot!

fkeuroglian — Fri, 31 Oct 2014 13:32:27 GMT

Perfect, thank you Manish

if i wan to put more than one value? or a list that i have in a variable?

where MATCH(date(Id),date('13/05/2007','14/05/2007'));

how would be? thank you a lot!

maleksafa — Fri, 31 Oct 2014 13:36:01 GMT

simply add them like that

where MATCH(date(Id),date('13/05/2007'),date('14/05/2007'));

in the match function the first parameter is the lookup value and all the other parameters from 1 to N are the values to search for.