Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Variation % between months with other dimension

I'm having a problem building a line chart It was supposed to mirror the variation between the months of the year, being the first month 0% and then the difference to the previous one.


The problem is when I add another dimension, for example store dimension


(Sum (sales)) / Aggr (RANGESUM (Above (sales)), [Date.autoCalendar.YearMonth]))


Was not supposed to work?

2 Replies
ahaahaaha
Honored Contributor

Re: Variation % between months with other dimension

Hi,

From the description of the function Above() ( Above - chart function ‒ Qlik Sense ‌)

If the table or table equivalent has multiple vertical dimensions, the current column segment will include only rows with the same values as the current row in all dimension columns, except for the column showing the last dimension in the inter-field sort order.


May be to change the order of the fields in sorting?


Regards,

Andrey

ahaahaaha
Honored Contributor

Re: Variation % between months with other dimension

A small example in the attached file. You can see the changes if you change the order of the fields [Score] and [Month] in the sort.