topic Re: variable in QlikView

variable

Sat, 15 Jun 2013 15:31:05 GMT

I created two variable:

Month1: it is current month
Month2: it is descrive a specific month

Month1= Text(Month(max(PER_RIF)))& Text(Year(max(PER_RIF)))

Month2= Text(Month(max(PER_RIF-1)))& Text(Year(max(PER_RIF-1)))

Now, I want to do some sum.

I try to use:

=sum({<{per_rif=$(date(Month1))}>} [Incassato_Altro _nel _periodo])

But when I try to set the sum it fails.

I can’t selection nothing because I want to automatizaren all things.

What Am I doing wrong ?

Thanks in advance.

Re: variable

Sat, 15 Jun 2013 17:14:20 GMT

I think your set analysis is incorrect, but also I suspect your variables are wrong.

According yo your variables, you get the month and the year from the same field: PER_RIF. Does PER_RIF has date values? If it's so... then you could do something like this:

=sum({<{PER_RIF={">=$(=MonthStart(Max(PER_RIF)))<=$(=MonthEnd(Max(PER_RIF)))"}>} [Incassato_Altro _nel _periodo])

That would give you the sum of [Incassato_Altro _nel _periodo] values for the max MonthYear selected or available (the 30 or 31 days included in the Month).

I think this example from Steve Dark may hel you a lot to learn about playing with Dates in Set Analysis.

http://community.qlik.com/docs/DOC-4313

Regards!

Re: variable

Sat, 15 Jun 2013 17:46:47 GMT

Hi Carlos,

thanks for the reply. But if I use your script in my object the result is: "-".

The PER_RIF field has a date value. I read your suggestion article by Steve Dark but i don't understand where i need to use that script in my own one. Follow a screenshot that i hope will help you to better understant my issue.

Thanks in advance.

Re: variable

swuehl — Sat, 15 Jun 2013 18:03:28 GMT

Check your curly brackets (i.e. { and } )

I believe you have put one opening curly bracket too much into your expression directly before the field name PER_RIF. Remove this one.

Re: variable

Sat, 15 Jun 2013 18:06:46 GMT

I'm sorry, I forgot to erase some characters from your formula that were wrong... try:

=sum({$<PER_RIF={">=$(=MonthStart(Max(PER_RIF)))<=$(=MonthEnd(Max(PER_RIF)))"}>} [Incassato_Altro _nel _periodo])

Re: variable

Sat, 15 Jun 2013 18:06:51 GMT

thanks thanks!!!!!!!!

it's right!!!!!!!

thanks you

Re: variable

Sat, 15 Jun 2013 18:07:35 GMT

it's right!!!!!!!

thanks you!

Regards!

Re: variable

Sun, 16 Jun 2013 07:33:38 GMT

Hi, sorry, I have the same problems but for precedetent month.

How can i do this?

My date are simililar of ciroscar's date.

Thanks in advance.

Re: variable

Sun, 16 Jun 2013 08:39:08 GMT

sorry, I'm finding solution in article by Steve Dark.

thanks a lot