Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vicio
Contributor III
Contributor III

Line Chart: running total with multiple dimensions (month, year)

Dimension1: Month

Dimension2: Year

Measure: Eur_commission (amount)

I can calculate running total with 1 dimension only (month) using the formula:

Rangesum( Above(Sum(eur_commission), 0, RowNo()))

Screen Shot 2017-01-05 at 13.50.14.png

If I add the second dimension (Year), the top chart (no running total) is perfect, the bottom chart (running total)

doesn't work anymore.

Screen Shot 2017-01-05 at 13.50.50.png

28 Replies
Anonymous
Not applicable

Hello Vicio Giglio ,

Very nice thread . I am lookinng for line chart with two dimensions.  When i  saw your qvf line  cahrt it has two dimensions.  How do we get two dimensions in Line chart.

i am trying to accomplish   this chart  and opened a question in Qlik comminity

Current month Plus previous half year for current year and Previous Year.

Thanks,

Snigdha

sunny_talwar

You can have a single expression with 2 dimensions or you can have multiple expressions with a single dimension... I hope you are not trying to do 2 or more expressions with 2 dimensions?

Anonymous
Not applicable

Hi Sunny,

I am looking for  2  dimesnions with multiple measures.

Anonymous
Not applicable

Sunny ,

This is the chart i am trying to accomplish

Current month Plus previous half year

sunny_talwar

It seems like it can be done with a single dimension... you just might need to use Dual function in your dimension like this

Dual(Month(MonthYear), MonthYear)

It will show just Month, but the underlying value will be MonthYear...

Anonymous
Not applicable

Hi Sunny,

Dimension is working  but  graph need three lines Budget, Actual for LAST 18 MONTHS A D PRIOR YEAR()2016 HALF YEAR.

PRIOR YEAR ACTUALS LIKE GOING LEFT SIDE  WHILE  BUDGET AND ACTUALS LINES ON RIGHT SIDE

WHICH DOES NOT GIVING GOOD PICTURE TO COMPARE BETWEEN YEARS.

PLEASE LET ME IF THIS IS DOABLE OR NOT

sunny_talwar

Would you be able to share a sample file?

Dipak
Contributor III
Contributor III

I am struggling to implement this. 

my data is ID, Date (daily with some days may be missing), week, value.

i would like to create below table

ID, Week, sum (value) for last weeks

 

K_N34
Contributor
Contributor

Hi,

I had faced a similar problem and this one- Aggr(Rangesum( Above(Sum(measure), 0, RowNo())),dimension 1, (dimension 2, (Numeric, Ascending))) works for me. But would you be able to explain the logic behind this? I am curious to know why including Numeric and Ascending makes the expression work. Thank you for the post anyway.