Very new to Qlik Sense and basically still evaluating if this is the product for our company.
I have been trying to see if the pie cart in the image is possible. Any ideas on how to do this with Qlik Sense?
The Pie chart represents a summary of accounting age analysis by AGE of our clients by "partner" who's client it is. (Represented as a percentage of total amount outstanding)
The database has the following fields:
d0 (Total amount in current for this client)
d30 (Total amount in 30 days for this client)
d60 (Total amount in 60 days for this client)
d90 (Total amount in 90 days for this client)
d120 (Total amount in 120 days for this client)
d150 (Total amount in 150 days for this client)
d180 (Total amount in 180 days for this client)
I just cannot seem to get this right with Qlik Sense pie chart. I have tried via a pivot, but you cannot get Qlik sense to do a pie chart based of that pivot results?
Is there a way to do this with maybe special expression or some code?
BTW. Maybe it's worth to consider not to use pie chart here? They are effective only in few specific cases.
Hi Andy Weir
I could arrange it that way by maybe using a per-process or maybe on load.
What is your idea if the data is as you ask? Would I then take the days as the expression?
I would do it on load perhaps concatenating a series of loads into the one table so the data looks like this
Partner Id, Client Id , Days, Total Amount
I would then make Days your Dimension and then Sum your Total Amount as a Measure for your Piechart
You can then filter on one or more Partners or clients to get your desired result.
If you need to generate one per client then I think there is a trellis extension in Qlik Branch you can install and use although Ive not used it yet. You should be able to the CLient Id as a dimension then the Days Dimension and Total Amount as a Measure.