topic Re: date variable in set analysis qlikview in App Development

date variable in set analysis qlikview

chetanpatel — Tue, 27 Sep 2022 04:13:30 GMT

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)

Lisa_P — Tue, 27 Sep 2022 06:11:28 GMT

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 — Tue, 27 Sep 2022 18:14:50 GMT

Thank you Lisa.