Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
The load statement don't work in expressions in a sheet
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.