Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to get multiple excel columns in one pie chart

Hi,

I've got a question for you guys.

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

My data is:

StandardRedYellowGreen
AA01123
AA02231
AA03026
AA04300

With a filter I want to select the Standard.

Hope you can help me

Tags (2)
1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: How to get multiple excel columns in one pie chart

Hi Bas,

As variant, may be as in attached file.

Regards,

Andrey

5 Replies
ahaahaaha
Honored Contributor

Re: How to get multiple excel columns in one pie chart

Hi Bas,

As variant, may be as in attached file.

Regards,

Andrey

beck110979
Valued Contributor III

Re: How to get multiple excel columns in one pie chart

Hi Bas,

pleas check my attached example,

i hope that helps

Beck

beck110979
Valued Contributor III

Re: How to get multiple excel columns in one pie chart

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

Not applicable

Re: How to get multiple excel columns in one pie chart

Thanks Andrey that is what I needed.

Did you reform the data to get it?

Because I have in total 300 standards

Not applicable

Re: How to get multiple excel columns in one pie chart

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?

screenshot.png

Regards Bas

Community Browser