topic Re: How to create a pie chart on selecting a name from a list box, using multiple table columns? in QlikView

How to create a pie chart on selecting a name from a list box, using multiple table columns?

Wed, 29 Jul 2015 13:46:29 GMT

Hi. I'm totally new to Qlikview so forgive me if this is a noob question.

I have a csv file which contains various columns, such as UserName, Parameter1,Parameter2, etc. I successfully import the table file and create a list box with the usernames. What I want to do is, if I click on one user, then there should be a pie chart that shows the percentage breakup of that particular user's data in the columns Parameter1, Parameter2, and so on.

I tried making a pie chart on my own but I could only manage to choose a single column for representation (such as Parameter1, say), and then the pie chart would be created for the entire list of users. If I click on one user, then the pie chart changes to just one big circle color coded to that user.

i'll give an example. One column is a list of names. Second column will be "Thriller" and will contain the number of thriller movies a person owns. Next will be "Drama", "RomCom" and so on. Now, if I click on a name from the list box of names, the output needs to be a pie chart depicting that person's movie collection breakup, like 10% thrillers, 50% drama and so on..
Thanks in advance

Re: How to create a pie chart on selecting a name from a list box, using multiple table columns?

awhitfield — Wed, 29 Jul 2015 15:58:21 GMT

Hi,

I may be easy t help if you could upload an example of your data.

Andy

Re: How to create a pie chart on selecting a name from a list box, using multiple table columns?

Thu, 30 Jul 2015 04:21:52 GMT

Hi Andy.

UName2	HoldingAssets	NationalSavings	PremiumBonds	UnitTrusts	PersonalEquityPlans	Shares	OtherInvestments
mr4li	25.80717	9.412963	27.11116	16.07885	18.96625	21.36269	27.38469
anna_af	34.10587	12.52653	35.65249	21.64129	25.47587	29.54573	34.7748
howe_b	38.45089	14.23032	40.54279	24.31741	28.75427	32.70686	40.01242

That's an example of how my data looks like. I want the UName2 field to be available on the list box, and once I click on any user name, I want to be able to have a pie chart that shows the percentage breakdown of that user's Holding Assets, National Savings, Premium Bonds, Unit Trusts, Personal Equity Plans, Shares and Other Investments.

Achyuth

Re: How to create a pie chart on selecting a name from a list box, using multiple table columns?

Digvijay_Singh — Thu, 30 Jul 2015 05:00:49 GMT

Try this - (I copied your data in excel sheet, attaching QVW also.)

Data:

CrossTable(AssetName, Value)

LOAD Name2,

HoldingAssets,

NationalSavings,

[Premium Bonds],

UnitTrusts,

PersonalEquityPlans,

Shares,

OtherInvestments

FROM

prob174522.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: How to create a pie chart on selecting a name from a list box, using multiple table columns?

Thu, 30 Jul 2015 05:09:18 GMT

I'm getting an output, but the percentages all add up to much more the 100%...
Btw, how did you manage to do this? 😮

Re: How to create a pie chart on selecting a name from a list box, using multiple table columns?

Thu, 30 Jul 2015 05:14:28 GMT

Is it a problem with the data itself? That the percentages are coming so awkwardly?

Btw, I'm so excited that I'm seeing the output I wanted. Spent a good week trying to figure this out. Even tried to make a darn extension and failed. Thank you!

Re: How to create a pie chart on selecting a name from a list box, using multiple table columns?

Digvijay_Singh — Thu, 30 Jul 2015 06:03:43 GMT

Sorry, My fault. Please change the expression to - Sum(Value)/Sum(Total Value).

I understood your data having cross table format, Qlik helps us to convert it in the form it can be evaluated as we want.

Can you mark it correct, if it solves the purpose. Thanks.

Re: How to create a pie chart on selecting a name from a list box, using multiple table columns?

Thu, 30 Jul 2015 06:16:21 GMT

It worked.

Thanks a million, Digvijay