Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

farolito20
New Contributor III

Select Query

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'

2 Replies
farolito20
New Contributor III

Re: Select Query

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

MVP & Luminary
MVP & Luminary

Re: Select Query

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.