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

[vicio]

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

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

doesn't work anymore.

[Anonymous]

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]

Hi Sunny,

I am looking for  2  dimesnions with multiple measures.

[Anonymous]

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]

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]

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]

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.