topic Re: Sum - Select - Year less then in QlikView

Sum - Select - Year less then

Wed, 04 Feb 2015 13:21:33 GMT

Hello.

I Have a table:

Year	Value
2001	1
2002	2
2003	3
2004	4
2005	5
2006	6
2007	7
2008	8
2009	9
2010	10

I must create a bar chart, include only 5 years: 2001, 2002, ..., 2006.

I use a sum with select: sum({<Year={XXX}>}Value)

What i must insert instead XXX?

<=2006 not work

Thank you.

Re: Sum - Select - Year less then

alexandros17 — Wed, 04 Feb 2015 13:26:43 GMT

If year is even a dimension then write in dimension

If(Year<=2006, year, null())

and check the box "Hide null values"

let me know

Re: Sum - Select - Year less then

Wed, 04 Feb 2015 13:31:01 GMT

Thank you, but i have a another formula in my app and "IF" don't work.

Original formula:

sum({<measureName={Opex, Expenditure}, budgetName={"Approved"}, Year={less then needed year}>}quantity)

Re: Sum - Select - Year less then

alexandros17 — Wed, 04 Feb 2015 13:34:02 GMT

Now it's clear:

write this:

sum({<measureName={Opex, Expenditure}, budgetName={"Approved"}, Year={'<=2006'}>}quantity)

let me know

Re: Sum - Select - Year less then

maternmi — Wed, 04 Feb 2015 13:34:24 GMT

Hi,

maybe that helps

sum({<Year={'2001','2002','2003','2004','2005','2006'}>}Value)

Michael

Re: Sum - Select - Year less then

Wed, 04 Feb 2015 13:37:49 GMT

"Error in set modifier ad hoc element list"

Re: Sum - Select - Year less then

Anonymous — Wed, 04 Feb 2015 13:38:02 GMT

Use single quotes '<=2006'

=sum({<Year={'<=2006'}>}Value)

It will work.

Re: Sum - Select - Year less then

Anonymous — Wed, 04 Feb 2015 13:39:05 GMT

Hi,

Try:

Sum({$<Year = {"<=$(=max(Year))"}>} Value)

Re: Sum - Select - Year less then

Wed, 04 Feb 2015 13:46:42 GMT

Sorry. It's work.

Thank you.

Re: Sum - Select - Year less then

alexandros17 — Wed, 04 Feb 2015 13:48:12 GMT

Could you mark the answer please?

Re: Sum - Select - Year less then

Wed, 04 Feb 2015 13:55:41 GMT

Alessandro,

for example, I create variable: SetYearMax

How i can insert this variable in the formula?

Re: Sum - Select - Year less then

alexandros17 — Wed, 04 Feb 2015 13:57:06 GMT

sum({<measureName={Opex, Expenditure}, budgetName={"Approved"}, Year={'<=$(SetYearMax)}>}quantity)

let me know

Re: Sum - Select - Year less then

Wed, 04 Feb 2015 13:59:52 GMT

Great!

Thank you very much

Re: Sum - Select - Year less then

Thu, 05 Feb 2015 08:29:06 GMT

Allesandro, one more question.

Where is I do mistake?

sum({<measureName={Opex, Expenditure}, budgetName={"Approved"}, Year={'<=$(SetYearMax)'}, Year={'>=$(SetYearMin)'}>}quantity).

I want create interval. From year 2002 to 2008 or another.

Re: Sum - Select - Year less then

alexandros17 — Thu, 05 Feb 2015 08:33:40 GMT

sum({<measureName={'Opex', 'Expenditure'}, budgetName={'Approved'}, Year={'>=$(SetYearMin)<=$(SetYearMax)'}>}quantity)

Re: Sum - Select - Year less then

Thu, 05 Feb 2015 08:39:03 GMT

O! I understand. Thank you very much.

I try in first: Year={'>=$(SetYearMin)', '<=$(SetYearMax)'}.