topic Re: Month before the selected one in QlikView

Month before the selected one

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

Hello guys. I need help again.

I have the down table with the date fields and last month's variable (vMesRef).

vMesRef => PerID = {$(=Max(PerID))}

I need a variable that brings me the "MêsAno" before the selected one. I tried the variable "vMesRefAnt", but it does not work.

vMesRefAnt => PerID = {$(=Max(PerID)-1)}

Can someone help me?

Re: Month before the selected one

sunny_talwar — Tue, 10 Oct 2017 18:48:22 GMT

This is just saying that the syntax editor doesn't understand your expression, but if this works or not can be checked by clicking okay to see if the result is what you expected to see. The reason for the error is use of the variable. Since, expression editor doesn't know what the variable is going to be evaluated to, it throws an error. It happens a lot of the time and most of the time, I don't even pay attention to this error unless I am not seeing the result I am expected to see

Re: Month before the selected one

carolinne88 — Tue, 10 Oct 2017 18:56:06 GMT

Hello, Sunny!

In the object it does not recognize the expression. I do not understand why.
The first object (with the number 52) is the expression "= Count ({<$ (vMesRef)>} Natureza_Jurídica").

The second object is the expression "= Count ({<$ (vMesRefAnt)>} Natureza_Jurídica").

Re: Month before the selected one

pradosh_thakur — Tue, 10 Oct 2017 19:34:18 GMT

Try changing this in the variable

vMesRef => PerID = {"$(=Max(PerID))"}

vMesRefAnt => PerID = {"$(=Max(PerID)-1)"}

regards

Pradosh

Re: Month before the selected one

carolinne88 — Tue, 10 Oct 2017 19:39:54 GMT

Hi, Pradosh!

I tried, but it's still the same. =/

Re: Month before the selected one

lorenzoconforti — Tue, 10 Oct 2017 19:44:34 GMT

Try single quotes

vMesRef => PerID = {'$(=Max(PerID))'}

vMesRefAnt => PerID = {'$(=Max(PerID)-1)'}

Re: Month before the selected one

carolinne88 — Tue, 10 Oct 2017 19:49:30 GMT

Nothing.. =(

Re: Month before the selected one

sunny_talwar — Tue, 10 Oct 2017 19:51:57 GMT

Can you try this

=Count({<$(=vMesRefAnt)>} Natureza_Jurídica)

Re: Month before the selected one

MK9885 — Tue, 10 Oct 2017 19:53:00 GMT

Maybe this?

vMesRef => PerID = {"=$(Max(PerID)"}

vMesRefAnt => PerID = {"=$(Max(PerID)-1)}

Re: Month before the selected one

lorenzoconforti — Tue, 10 Oct 2017 19:54:57 GMT

can you post your application?

Re: Month before the selected one

carolinne88 — Tue, 10 Oct 2017 19:57:01 GMT

None of the options solved.. =/

Re: Month before the selected one

carolinne88 — Tue, 10 Oct 2017 19:58:41 GMT

I can not because I can not disclose the uploaded data.

Re: Month before the selected one

pradosh_thakur — Tue, 10 Oct 2017 19:59:50 GMT

Try changing this in the variable

vMesRef => PerID = {"$(=Max(PerID))"}

vMesRefAnt => PerID = {"$(=Max(PerID)-1)"}

and

expression

The first object (with the number 52) is the expression =Count ({<vMesRef>} Natureza_Jurídica)

The second object is the expression =Count ({<vMesRefAnt>} Natureza_Jurídica)

please note : I have removed $() as variable is going to replace the modifier.

regards

Pradosh

Re: Month before the selected one

MK9885 — Tue, 10 Oct 2017 20:01:50 GMT

Count(<{PerID= {$(=Max(PerID))}>} Natureza_Jurídica)

Re: Month before the selected one

lorenzoconforti — Tue, 10 Oct 2017 20:21:17 GMT

vMesRefAnt => PerID = {"=$(num(Max(PerID),'0')-1)}

Re: Month before the selected one

carolinne88 — Wed, 11 Oct 2017 16:32:19 GMT

I tested all the options given and none serves.

Re: Month before the selected one

lorenzoconforti — Wed, 11 Oct 2017 16:40:28 GMT

Could you please create two text boxes with the following and paste the results?

Textbox1:

=Max(PerID)

Textbox2:

=Max(PerID)-1

Re: Month before the selected one

carolinne88 — Wed, 11 Oct 2017 16:47:48 GMT

Re: Month before the selected one

jonvitale — Wed, 11 Oct 2017 19:43:26 GMT

Hi Carolinne,

I have been trying to play around with your issue, and your code works for me on a made-up set of data.

I wonder if it has something to do with the way the PerId variable is represented. Why don't you try this.

In the data load, wherever you are loading this table, use a preceding load line like this:

Num(Month(data)) as PerId_DateNum

The PerId_DateNum field should *look* the same on the table, but perhaps it's represented in a better way beneath the surface.

Then use the same variables with the new fields:

vMesRef => PerID_DateNum = {$(=Max(PerID_DateNum))}

vMesRefAnt => PerID_DateNum = {$(=Max(PerID_DateNum)-1)}

Re: Month before the selected one

lorenzoconforti — Thu, 12 Oct 2017 07:59:45 GMT

To me it looks like then there shouldn't be anything wrong with your variable and set expression. The problem might be somewhere else

Can you please post what is the exact code behind the text box you have mentioned above in the post? Please copy and paste the whole code (I think what you pasted before was just a part of it)