Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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.