Select Query

[farolito20]

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]

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

[jagan]

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.