topic Re: Pie chart and cyclic group in QlikView

Pie chart and cyclic group

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

Based on a simple table like this:

Year, Value1, Value2

2010, 1, 4

2011, 2, 5

2012, 3, 6

Is it possible to create a pie chart that shows the relationship between value1 and value2 for a year, and then cycle the years with a cyclic group? I guess the first question is if it is possible to use cyclic groups for rows rather than columns.

If I transpose the table I can create the cyclic group, but then how do I write the expression to show the both values (now rows) in the pie chart?

All replies are appreciated!

Re: Pie chart and cyclic group

Gysbert_Wassenaar — Thu, 19 Nov 2015 10:47:33 GMT

You can use an expression group if you create three expressions, one for each year. But why not add the Year field to a listbox and let users select the year in there. You could set the listbox to Always One Selected Value so that a user can select only one year at a time.

Re: Pie chart and cyclic group

Thu, 19 Nov 2015 13:08:22 GMT

Thank you for your rapid reply.

The listbox would take up more space (tight design), but I can make it work. I tried it, but can't seem to get the expression right. Could you please show me how to do it? Also, it would be very interesting to see an example of your expression group solution .

I have attached a test document.

Re: Pie chart and cyclic group

Gysbert_Wassenaar — Thu, 19 Nov 2015 13:56:44 GMT

See attached example. And if you think a listbox is taking up too much space then get rid of the pie charts and use for example bar charts or inline charts in a straigth table that take up far less space.

Re: Pie chart and cyclic group

effinty2112 — Thu, 19 Nov 2015 14:15:52 GMT

If I understand you right you want to have a pie chart showing the ratio of Value1 to Value2 for each year. If so you need to re-organise your data in the load statement like this:

Data:

LOAD * INLINE [

Year, Value1, Value2

2010, 1, 4

2011, 2, 5

2012, 3, 6

];

CrossData:

CrossTable(Dim, Values)

LOAD

Resident Data;

Drop table Data;

Turning

Year, Value1, Value2

2010, 1, 4

2011, 2, 5

2012, 3, 6

into

Year	Dim	Values
2010	Value1	1
2010	Value2	4
2011	Value1	2
2011	Value2	5
2012	Value1	3
2012	Value2	6

The labels don't make much sense here.

Now you can make your pie chart.

Re: Pie chart and cyclic group

Thu, 19 Nov 2015 14:24:04 GMT

Thank you for the advice. I can't find any examples in your previous post though, did you forget to attach it?

Re: Pie chart and cyclic group

effinty2112 — Thu, 19 Nov 2015 15:49:07 GMT

Hi Hakon,

Please find attachment. I hope I've understood what you are wanting, if not let me know.

Cheers

Andrew

Re: Pie chart and cyclic group

Gysbert_Wassenaar — Thu, 19 Nov 2015 18:47:49 GMT

Hmm, I guess I did forget. Attached now.

Re: Pie chart and cyclic group

Fri, 20 Nov 2015 07:47:59 GMT

Thank you, great examples!

Re: Pie chart and cyclic group

Fri, 20 Nov 2015 08:06:38 GMT

Thank you for your reply Andrew! Great tip, a crosstable was indeed the solution to my problems (combined with Gysbert's expression groups).