4 Replies Latest reply: Nov 8, 2018 3:55 AM by Andrea Gigliotti RSS

    How to create dimension for use pie chart

    Eva de Vin

      Dear all


      Another challenge in my Qlik Sense journey.

      I want to create a pie chart showing which portion of the Budget is allocated vs. what is remaining.

      In my data, I have no 'dimension' for this - as this is embedded in the measures itself (columns).

      Should I solve this via the crosstable function (in script) or is there another easier way to tackle this?


      My data comes like:

      Department, Budget, Budget - allocated, Budget - remaining

      Finance,100, 20, 80


      My pie chart would simply show:

      20 Allocated and 80 Remaining


      Many thanks for your thoughts on this!