Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rrodriguesrr82
New Contributor

Qlik Sense: Accumulating in combo chart. Descending sorting.

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

Tags (1)
3 Replies

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

Will you able to provide sample application?

rrodriguesrr82
New Contributor

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

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.

JanuaryFebruaryMarchAprilMayJune
102030405060

  • To be: I want a descending sorting:

JuneMayAprilMarchFebruaryJanuary
605040302010

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.

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

Community Browser