topic Re: Select Query in QlikView

Select Query

farolito20 — Thu, 13 Dec 2012 17:53:21 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'

farolito20 — Tue, 18 Dec 2012 14:16:35 GMT

The load statement don't work in expressions in a sheet

jagan — Wed, 19 Dec 2012 08:29:05 GMT

Hi,

Try like this

First create variables

vStartDate = valid start date with same format as ModifiedDate

vEndDate = valid end date with same format as ModifiedDate

Now use this variables in expression

=Sum({<ModifiedDate={'>$(=vStartDate)<$(=vEndDate)'}>} Sales)

Hope thie helps you.

Regards,

Jagan.