topic Re: using variable in expression in QlikView

using variable in expression

hopkinsc — Tue, 15 Apr 2014 08:34:46 GMT

Hi all,

I can't seem to get an expression working. I have a variable

vWeekIndex

which has the following definition...

=[Current Week Index]

which just returns the week index of a selected date.

I am trying to write an expression to reference this variable but add 1 also. so..

Sum({<[Current Week Index]={'$(vWeekIndex)+1'}>}[Room Revenue])

I have tried different variations but just can't seem to get it to work.

Any ideas?

Re: using variable in expression

its_anandrjs — Tue, 15 Apr 2014 08:37:50 GMT

Try like

Sum({<[Current Week Index] = {"$(vWeekIndex)+1"}>}[Room Revenue])

Re: using variable in expression

its_anandrjs — Tue, 15 Apr 2014 08:38:36 GMT

Or you can try

Sum({<[Current Week Index] = {'$(vWeekIndex+1)'}>}[Room Revenue])

Re: using variable in expression

arsal_90 — Tue, 15 Apr 2014 08:51:59 GMT

Check This

Sum({<[Current Week Index]={$(=$(vWeekIndex)+1)}>}[Room Revenue])

Re: using variable in expression

arsal_90 — Tue, 15 Apr 2014 08:53:34 GMT

Check Also this

Sum({<[Current Week Index] = {$(vWeekIndex)+1)}>}[Room Revenue])

Re: using variable in expression

Tue, 15 Apr 2014 08:59:25 GMT

Use this

vWeekIndex = [Current Week Index]+1

Exp:

=Sum({<[Current Week Index] = {'$(vWeekIndex)'}>}[Room Revenue])

Re: using variable in expression

hopkinsc — Tue, 15 Apr 2014 09:00:10 GMT

Thanks all, but i can't get any of them to work.

I have attached a sample.

Re: using variable in expression

hopkinsc — Tue, 15 Apr 2014 09:02:14 GMT

thanks Ravi,. I have already tried this option (which works) but i would prefer to use the +1 in the expression as i have to do 30+ expressions using +1, +2, +3 etc. i don't want to use 30+ variables

Re: using variable in expression

SergeyMak — Tue, 15 Apr 2014 09:08:15 GMT

It works for me

sum({$<[Current Week Index]={$(=vWeekIndex+1)},Date>}[Room Revenue])

You need to clear selection of the Date field

Re: using variable in expression

jagan — Tue, 15 Apr 2014 10:14:50 GMT

Hi,

Try like this

vWeekIndex = Max([Current Week Index])

Expression = sum({<[Current Week Index]={$(=vWeekIndex+1)}>}[Room Revenue])

Regards,

Jagan.