topic Re: Creating a piechart based on Count() in QlikView

Creating a piechart based on Count()

jolienjansen — Sat, 16 Nov 2024 20:21:15 GMT

Hey everyone,

I have created a table that shows the totals of certain variables. I have calculated this table by using count()

The table looks something like this:

Total assignments	Executed assignments(sum)	Planned assignments(sum)	Future assignments(sum)
650	340	70	250

I would like to create a piechart that is based on these numbers (so a pie chart with 3 pieces). However, since these sums are based on other variables, I cannot just select "executed assignments" as a variable for the piechart. In the programs I am used to I would probably change the table format into a long table. However, I am still new to qlikview, and I have no idea how to solve it.

Thanks for your help!

Greetings, Jolien

Re: Creating a piechart based on Count()

hallquist_nate — Wed, 31 Jul 2019 18:39:58 GMT

I don't have an app or example of this readily available, but I think using a ValueList() is a good solution here. I have used this in the past in situations like this and have had a lot of success.

This is the link to the ValueList help section.

Let us know if this doesn't meet your needs,

Nate

Re: Creating a piechart based on Count()

jolienjansen — Thu, 01 Aug 2019 11:19:55 GMT

Thanks Nate, that indeed did the trick! Needed some time to figure out the exact working of the function, but it's working fine now.