topic Re: Variables in an expression! HELP !! in QlikView

Variables in an expression! HELP !!

karina89 — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone!

I need to get the data from a previous day to my initial date, which have a variable (vFechaInicial).

The following expression runs but when I have a field (FechaInformacion):

Max ({<FechaInformación = { "<$ (= max (FechaInformación))"}>} FechaInformación)

But when I try to get my Variable I get error:

Anyone know where I'm wrong, or if I need to add something?

I appreciate very much your help and your answers!

Re: Variables in an expression! HELP !!

sunny_talwar — Wed, 20 Jul 2016 19:33:26 GMT

What is your variable containing? If it is a field name, then regardless of any error, you should get expected output. But if it is an expression, this may or may not work.

Best,

Sunny

Re: Variables in an expression! HELP !!

maksim_senin — Wed, 20 Jul 2016 23:17:45 GMT

Hi Karina,

It's hard to help without a sample. In case you expect to have different prev. dates for each row this will hardly work since (a.f.a.i.u.) set analysis applies to a chart in a whole and cannot vary its outcome from row to row.

Best regards,

Maxim

Re: Variables in an expression! HELP !!

karina89 — Tue, 26 Jul 2016 18:10:19 GMT

Hello!!

What I want is to get the day before, to the day I have stored in my variable ( vFechaInicial )
That means if my variables have stored the following date: 19/02/2016 What I Get serious : 02/18/2016

I need an expression to help me get that result Using variables In it , I had thought to put so :

But I make a mistake and I do not need to add or correct .

Or if anyone knows that otherwise could get what I want I would greatly appreciate your support

Re: Variables in an expression! HELP !!

bertinabel — Tue, 26 Jul 2016 18:53:03 GMT

If not achieve understand what you need.

already you tried the following?

= Date (vFechaInicial-1, 'DD / MM / YYYY')

in this case defined the vFechaInicial variable with the value 02/19/2016

- - -

No se si logre entender bien lo que necesitas.

ya intentaste lo siguiente?

=Date(vFechaInicial-1,'DD/MM/YYYY')

en este caso defini la variable vFechaInicial con el valor de 19/02/2016

Note: English translation provided by a Community Moderator as a courtesy. Please post in English while in main forums.

Re: Variables in an expression! HELP !!

karina89 — Wed, 03 Aug 2016 15:47:37 GMT

Thank you very much, if I run, just one more question.

If you would like to take the year or the month before my date, as might represent?

Muucho appreciate your help!

- - -

Muchas gracias, si me funciono , solo una pregunta mas.
Si quisiera tomar el año o el mes anterior a mi fecha, Como podría representarlo?

Agradezco muucho tu ayuda!

Note: English translation provided by a Community Moderator as a courtesy. Please post in English while in main forums.

Re: Variables in an expression! HELP !!

bertinabel — Wed, 03 Aug 2016 17:12:42 GMT

Hi, Karina.

For the previous month :

=Date (Addmonths(vFechaInicial,-1), 'DD/MM/YYYY')

For the previous year.

=Date (AddYears(vFechaInicial,-1), 'DD/MM/YYYY')

Regards.