topic Re: Set Analysis Question in QlikView

Set Analysis Question

kclayton1 — Wed, 12 Feb 2014 20:38:34 GMT

I am trying to use a variable to calculate the sum of payments for Services Dates that are less than or equal to the Variable Date with Payment Dates greater than the Variable Date. I have listed the formula I using below. I have not been able to get this to work. Currently, the Variable Date is setup in a Slider Object. Let me know how I should can adjust this formula to work.

=sum({$<ServiceDate={"<=$(vVariableDate)"},PaymentDate={">$(vVariableDate)"}>} PaymentAmt)

Thanks.

Kevin

Re: Set Analysis Question

Wed, 12 Feb 2014 20:52:29 GMT

Does this work?

=sum({$<ServiceDate={"<=$(=vVariableDate)"},PaymentDate={">$(=vVariableDate)"}>} PaymentAmt)

Re: Set Analysis Question

swuehl — Wed, 12 Feb 2014 20:54:03 GMT

"..not been able to get this to work" is not a good issue description. Please describe what you get and what you see as best as you can. Posting a small sample application greatly helps us to help you, too.

If you want to debug a set expression using dollar sign expansion, it's good to see the expression with variables expanded. To see it expanded, create a straight table chart and copy your expression in. Leave the expression label empty. Close the property dialog.

Then, when hovering over the expression label in your chart, you should see the expression with variables expanded.

How does this look like? Does the format of your expanded vVariableDate matches the format of both your date fields?