New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Global Transformation Awards! Applications are now open. Submit Entry

Who Me Too'd this topic

raceberos
Partner - Contributor III
Partner - Contributor III

rangesum with 2 dimensions

Good Day

i am wondering why my formula is not working properly. i just want to show my data in asset by branch per month,

when i add the month as a dimension everything seems fine,

and this is my formula

=rangesum( above( Sum({<GLHeader= {1}>} GLTOTAL ),0,rowno()))

Rangesum went wrong.JPG

but when i add the banchname as dimension my data went wrong.

Rangesum went wrong part 2.JPG

and i dont know why. can someone help me, any help will be appreciated

thanks

Who Me Too'd this topic