Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.