topic Re: Select Query in QlikView

Select Query

farolito20 — Thu, 13 Dec 2012 17:28:48 GMT

How I can do this query in an expression in QlikView?

SELECT *

FROM Person.Password

WHERE ModifiedDate>'1996/07/23' and ModifiedDate<'1997/03/20'

Thu, 13 Dec 2012 18:00:34 GMT

If you read a QVD, you can read the table and put a where.

select *

from QVD.TABLE

Where ModifiedDate> 'date1' and ModifiedDate < 'data2'

farolito20 — Thu, 13 Dec 2012 18:02:02 GMT

Yes, but the select doesn't work in expressions 😕

farolito20 — Thu, 13 Dec 2012 18:05:11 GMT

I wanna put that condition in a text object

Thu, 13 Dec 2012 18:44:05 GMT

if so use the expression to return the values in the object.

= if (ModifiedDate> 'date1' and ModifiedDate <'data2', 'Field Object)

farolito20 — Thu, 13 Dec 2012 20:48:34 GMT

Thanks

Fri, 14 Dec 2012 11:01:30 GMT

Good morning,

Did it work? So mark my answer as correct, please!

farolito20 — Fri, 14 Dec 2012 14:12:00 GMT

I didn't use your answer, but that gave me an a good idea