This content has been marked as final. Show 4 replies
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!