Qlik Sense: Accumulating in combo chart. Descending sorting.

[rrodriguesrr82]

Hi folks,

I have a combo chart (lines model) with 1 dimension (Period) and 3 measures.

I'm accumulating the values through the following expression structure:

Rangesum(Above(Count({< FIELD = {'ACTIVE'}, [Year]=, [Month]= >} [CODE_ID]), 0, RowNo()))

It works if the sorting of the dimension is ascending.

However, I need a descending sorting of the Period dimension, but when I do it, the values are not represented as expected.

Hope you can help me with it.

Thanks,

Rubens Rodrigues

[Anil_Babu_Samineni]

Will you able to provide sample application?

[rrodriguesrr82]

Hi Anil,

I want the following (I will demonstrate using a table, but it's actually a combo chart.

• Current scenario: Accumulating Month ascending.It works with my expression.

January	February	March	April	May	June
10	20	30	40	50	60

• To be: I want a descending sorting:

June	May	April	March	February	January
60	50	40	30	20	10

My expression does not work in the case above. The chart shows the month in descending order, but the values are wrong, i.e, it shows 10 for June and so forth.

Thanks,

Rubens

[Anil_Babu_Samineni]

Do we expect any mock qvf file from you, Because technical is different rather than functional. If so, Please create dummy data and choose combo chart then share with us with scramble only because community helpers won't ask you to share real data any more