topic Re: Variable naming x weeks ago in QlikView

Variable naming x weeks ago

annabergendal — Mon, 16 Jan 2017 12:08:01 GMT

I'm looking for proper names I can use for weeks defined as variables.

I have set up variables defining last week, the week before last, the week 3 weeks back etc. For 8 weeks back.

The logic works fine, just looking for a good naming standard.

"vCurrentWeek-1" for last week, "vCurrentWeek-2" for the week before last etc would have been perfect.

But QV doesn't like the "-"

Ideas?

Thanks!

Re: Variable naming x weeks ago

MK_QSL — Mon, 16 Jan 2017 12:10:03 GMT

Try

[vCurrentWeek-1]

[vCurrentWeek-2]

etc

Updated: This will not work.

use vCurrentWeek-1

vCurrentWeek-2

and while using variables.. you need to add [].

So While using these variables.. use [vCurrentWeek-1] and [vCurrentWeek-2] etc

Re: Variable naming x weeks ago

annabergendal — Mon, 16 Jan 2017 12:13:45 GMT

This works fine, thanks!

Re: Variable naming x weeks ago

annabergendal — Mon, 16 Jan 2017 12:19:47 GMT

Actually, it works fine when defining locally in the app, but I'm using Variable Editor in QDF and this doesn't allow me to put in "-", even when I'm using brackets []