Creating bar charts with 5 fields

[#1]

Hi QlikView Masters,

I want to create barchart here are the conditions:-

1.It has 5 fields

2.Take average of each field.

3.Display bar for each field. Basically 5 bars.

There is a filter country for this bar chart as well. What will be the

dimension when we are displaying 5 bars for each field?

Regards,

Jani

[#2]

Hi Jani,

in act if you always have 5 fields, you may create barchart with 5 expressions and without dimensions.

You may also create island table with 5 rows (1 row for each bar) and use pick() in expression.

regards

Darek