topic Re: Using variable in Set Expression in QlikView

Using variable in Set Expression

Wed, 03 Apr 2013 11:36:26 GMT

Hi all, I'm trying to create the following expression which contains a variable but I'm getting syntax error

Sum({$<Fecha = {"<=Today()-"$(vNumDias)}> Ventas)

What is the correct way to include the variable?

Thanks

kaushiknsolanki — Wed, 03 Apr 2013 11:58:23 GMT

Hi,

Try this

Sum({$<Fecha = {"<=$(=Today())-$(vNumDias)"}> Ventas)

Regards,

Kaushik Solanki

Wed, 03 Apr 2013 12:07:15 GMT

It does not work

sushil353 — Wed, 03 Apr 2013 12:13:45 GMT

Try this:

Sum({$<Fecha = {"<=(Today()-$(vNumDias))"}> Ventas)

HTH

Sushil

kaushiknsolanki — Wed, 03 Apr 2013 13:13:07 GMT

Hi,

What is the format of date in Fecha field?

if its DD/MM/YYYY then try below expression.

Sum({$<Fecha = {"<=$(=date(Today()-$(vNumDias),'DD/MM/YYYY'))"}> Ventas)

Regards,

Kaushik Solanki

Wed, 03 Apr 2013 13:53:16 GMT

Thanks a lot for your answers although unfortunately they didn't work,, I'm attaching qvw

fdelacal — Wed, 03 Apr 2013 14:40:48 GMT

Prueba con esto.

Sum({$<Fecha = {"$(='<='&DATE(Today()-$(vNumDias),'DD/MM/YYYY')"}> Ventas)

Saludos

kaushiknsolanki — Wed, 03 Apr 2013 18:25:43 GMT

Hi,

Have a look at the attached application.

Regards,

Kaushik Solanki