How to get multiple excel columns in one pie chart

[#1]

Hi,

I've got a question for you guys.

I want to have multiple excel columns in one pie chart.

My data is:

Standard	Red	Yellow	Green
AA01	1	2	3
AA02	2	3	1
AA03	0	2	6
AA04	3	0	0

With a filter I want to select the Standard.

Hope you can help me

[ahaahaaha · Accepted solution]

Hi Bas,

As variant, may be as in attached file.

Regards,

Andrey

[beck_bakytbek]

Hi Bas,

pleas check my attached example,

i hope that helps

Beck

[beck_bakytbek]

Bags,

check this:

1.https://www.youtube.com/watch?v=xkBFyNys1LI

2.Cross Table in QlikView - YouTube

it is about function in script: CrossTable, with that you can resolve such problems

i hope that helps

Beck

[#5]

Thanks Andrey that is what I needed.

Did you reform the data to get it?

Because I have in total 300 standards

[#6]

Hi Andrey,

I fixed my first problem with your solution.

But it created a new one. I also have pie charts for the standards and total assesment.

Is their a function where it filters the STD back to one? something like distinct?

Regards Bas