Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
vinayvishwanath
New Contributor III

How to Apply Rangesum function with 2 dimensions (Year and Month)

Dear All,

I am trying to create bar chart with 2 dimensions (Month and Year) wherein the measure is rangesum of employees.

Rangesum should work in such a way that it accumulates the values of Employees monthly and in the chart x-axis should be month and values should show on accumulation basis...If you look into the below table, if the user selects 2018 then bars should be visible with Months showing accumulated values like Jan - 15, Feb - 26, Mar - 44....

Please help me to resolve this issue

 20182019
Jan1513
Feb1110
Mar1823
April3116
June1922
July28
 9692
1 Solution

Accepted Solutions
Partner
Partner

Re: How to Apply Rangesum function with 2 dimensions (Year and Month)

Hi,

 

try to see the file attached

View solution in original post

2 Replies
Partner
Partner

Re: How to Apply Rangesum function with 2 dimensions (Year and Month)

Hi,

 

try to see the file attached

View solution in original post

Highlighted
vinayvishwanath
New Contributor III

Re: How to Apply Rangesum function with 2 dimensions (Year and Month)

Hi,

I was able to achieve that by adding script in the backend and then using if condition in the frontend.. Thanks for the help in providing the solution for the same