Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Anyone out there who knows how to accumulate a measure in a chart object in Qlik Sense. In QlikView I used to choose "Full accumulation" on the expressions tab, but there's no such feature in Qlik Sense, from what I can see...
Thanks
Pedro
This video explains it.
How to produce a cumulating bar chart/line chart in Qlik Sense - YouTube
Regards,
Nico
Thanks you! It's works.
Great Work ,
Small Question on Extension to this Question ,
What if we have 2 Expression and 2 Dimension vas well, i am trying using aggr funtion in Qlik Sense it is Not working .
Can you please help me out of this .
I am Trying like this but not working
=Max( Aggr( rangesum( above( Sum(Aggr(sum({<No = {10}>} Expression),Filed-1,Field-2)),0,RowNo())),
Filed-1,Field-2))
Thanks in advance ,
Harish
Hi,
What if we want to have all line on the same chart?
Two dimension:
1) Year
2) Fieldname
Two mesures:
--> Sum per fieldname over the year -> Sum(FieldName)
--> Total sales over the year. --> RangeSum(Above(Sum(FieldName),0,rowno()))
But standard line chart only accept one mesure. How can I solve this?
Hi,
This is working fine.. but what If I am restricting my dimension to say top 5. in this scenario its not giving proper numbers.
Saniya.