topic Re: Qlik Sense: Accumulating in combo chart. Descending sorting. in QlikView

Qlik Sense: Accumulating in combo chart. Descending sorting.

rrodriguesrr82 — Fri, 23 Jun 2017 23:00:21 GMT

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

Re: Qlik Sense: Accumulating in combo chart. Descending sorting.

Anil_Babu_Samineni — Mon, 26 Jun 2017 01:33:39 GMT

Will you able to provide sample application?

Re: Qlik Sense: Accumulating in combo chart. Descending sorting.

rrodriguesrr82 — Tue, 27 Jun 2017 01:33:32 GMT

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

Re: Qlik Sense: Accumulating in combo chart. Descending sorting.

Anil_Babu_Samineni — Tue, 27 Jun 2017 16:08:44 GMT

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