Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chetanpatel
Contributor III
Contributor III

date variable in set analysis qlikview

Equation giving value for  january and  feb 2022 so whats i am doing wrong here  also want to use vstartdate as  variable for  06/01/2022.

=SUM({<PayPeriod.ServiceDT= { ">=$('6/01/2022')"},PayPeriod.ServiceDT= {'<=$(VEndDate)'} >} PayPeriod.APCWeight)

Labels (2)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

If you are having trouble with this, check what the result is using the Expression editor and look at the bottom to see if there is any errors.

The rules in the set expression  is to search for a range of values needs " " quotes.

Another thing that can sometimes happen is date formatting issue.

Assuming you have a variable containing '06/01/2022'

=SUM({<PayPeriod.ServiceDT= { ">=$(vstartdate)<=$(VEndDate)"} >} PayPeriod.APCWeight

View solution in original post

2 Replies
Lisa_P
Employee
Employee

If you are having trouble with this, check what the result is using the Expression editor and look at the bottom to see if there is any errors.

The rules in the set expression  is to search for a range of values needs " " quotes.

Another thing that can sometimes happen is date formatting issue.

Assuming you have a variable containing '06/01/2022'

=SUM({<PayPeriod.ServiceDT= { ">=$(vstartdate)<=$(VEndDate)"} >} PayPeriod.APCWeight

chetanpatel
Contributor III
Contributor III
Author

Thank you Lisa.