3 Replies Latest reply: Jun 27, 2017 12:08 PM by Anil Babu Samineni RSS

    Qlik Sense: Accumulating in combo chart. Descending sorting.

    Rubens Rodrigues

      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