Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

timorbit
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
hdbucher
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
timorbit
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
hdbucher
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()))


Community Browser