# Qlik Sense App Development

New Contributor III

## Rangesum() funktion with a specific year

Hi Folks,

my Expression of rangesum looks like:

rangesum( above( sum(Sales),0,rowno())) and it works.

But I want to integrate the year information: When I change my expression in the following one, the datastream disappears and the chart is empty.

rangesum( above( sum({<year={"<=\$(vActJahr) >=\$(=\$(vActJahr)-1)"},month={"=\$(=vActMonat)"}>}Sales),0,rowno()))

What I am doing wrong?

Thanks a lot,
Tim

1 Solution

Accepted Solutions
New Contributor III

## Re: Rangesum() funktion with a specific year

maybe try this...

rangesum(above( sum({<year={">=\$(=\$(vActJahr)-1) <=\$(=\$(vActJahr))"},month={"=\$(=vActMonat)"}>}Sales),0,rowno()))

4 Replies

## Re: Rangesum() funktion with a specific year

Possibly this: month={"=\$(=vActMonat)"}.

Try month={\$(vActMonat)} or month={'\$(vActMonat)'}

btw, if you limit month to one value you'll get only results for that one month.

talk is cheap, supply exceeds demand
New Contributor III

## Re: Rangesum() funktion with a specific year

Thank you for your suggestion. I thought it would work, but unfortunately not.

Can you explain me more detailed abut your btw... Do you mean I should deleate the month={"=\$(=vActMonat)"} part?

## Re: Rangesum() funktion with a specific year

I'm pretty sure it won't do anything useful now. What do you expect it to do?

talk is cheap, supply exceeds demand
New Contributor III

## Re: Rangesum() funktion with a specific year

maybe try this...

rangesum(above( sum({<year={">=\$(=\$(vActJahr)-1) <=\$(=\$(vActJahr))"},month={"=\$(=vActMonat)"}>}Sales),0,rowno()))