1 Reply Latest reply: Apr 18, 2018 6:21 AM by Petter Skjolden RSS

    Staircase Effect of data in Qlik Sense

    satish rathod

      Hello All,

      I have the following output that is showing a staircase effect.

      I wanted the output as shown below.

      The values will be checked on the basis of "Billing Document Number"

       

      Capture.JPG

      Thanks in Advance

        • Re: Staircase Effect of data in Qlik Sense
          Petter Skjolden

          You would need to do something like this in your load script:

           

          LOAD

            [Billing Document Number],

            [Material Code],

            [Quantity],

            Only([Invoice Value],

            Sum([Net Value]) AS [Net Value],

            Sum([Special Disc]) AS [Special Disc],

            Num([IGST %],'0%','.',',') AS [IGST %]

          FROM

            "<your-excel-file>.xlsx" (ooxml......)

          GROUP BY

            [Billing Document Number],

            [Material Code],

            [Quantity]

          ;

           

           

          However you can just read the Excel file as it is instead (as an alternative). Then you do the same in the chart as you would do in the load script.In the app you then have to select the three first fields as dimensions and the rest as measures with the expressions kept the same as in the load script above. The dimensions in a chart has an implicit group by so you won't need to specify that as you have to in the load script.

           

          I guess the load script variant is cleaner anyway....