topic Date based on Variable in QlikView

Date based on Variable

Wed, 15 Sep 2010 19:53:17 GMT

I am trying to create an SLA_Date in my load script using the order_date plus the SLA_Days which is a variable called vSLA. It's value is currently = 3. I tried this script:

Date(Order_Date + vSLA) As SLA_Date

but this failed. Any suggestions? Thank you.

Don

Date based on Variable

johnw — Wed, 15 Sep 2010 20:09:13 GMT

Date(Order_Date + $(vSLA)) As SLA_Date

Date based on Variable

Wed, 15 Sep 2010 20:20:22 GMT

Thanks John. That worked. Just a question. Why do you include the $ if this is a load script? I'm still learning the scripting language.

Date based on Variable

johnw — Wed, 15 Sep 2010 20:24:07 GMT

Heh, to be honest, because it didn't work without it. I haven't really nailed down the rules for when I just state the variable and when I need to put $() around it. I'm sure they're simple, but so far it's been trivial for me to do it one way, and if it doesn't work, do it the other way. After five years, you'd think I'd have learned something as simple as this, but no. *chuckle*

Date based on Variable

Wed, 15 Sep 2010 20:29:53 GMT

Well your a very kind and patient man for helping all these newbies like me. Take care.