topic Re: Evaluation Measurements for a bar chart in QlikView

Evaluation Measurements for a bar chart

Fri, 17 Apr 2015 15:16:21 GMT

Evaluation Measurements for a bar chart

I have a list of measurements from various sensors to be displayed in a barchart. At the X achse I like to arrange the Sensor names. At the y achse I like to display the average value of the 10 measurements for each sensor.

Mears. Sens1 Sens2 Sens3

1 1200 3400 4500

2 1200 3400 4500

3 1200 3400 4500

4 1200 3400 4500

5 1200 3400 4500

6 1200 _3400 4500

7 1200 3400 4500

8 1200 3400 4500

9 1200 3400 4500

10 1200 3400 4500

I defind Sens1-3 for the dimension. But I can't find the rigt expression for the formular. The Amount of sensors may vary. What is the correct setting for the formular?

Thanks an best regards

Re: Evaluation Measurements for a bar chart

Anonymous — Tue, 21 Apr 2015 06:43:39 GMT

Hi Ludger

i am trying to understand your question but failing would u kindly ellaborate further probably with an example of expected results

Re: Evaluation Measurements for a bar chart

Tue, 21 Apr 2015 20:29:51 GMT

Re: Evaluation Measurements for a bar chart

Anonymous — Tue, 28 Apr 2015 13:32:50 GMT

Hi,

if you insert a coloumn with the number of measurements, you can use the crosstable syntax.

In this way you can create your bar chart, where the number of items in the dimension is dynamic.

Find some attachements.

KR,

Elena