What is this called...?

[#1]

Hi,

I'm trying to recreate a QlikView app as someone else has done.

I'm about 0.5 days into this software.

What is the object entitled "Average Time per Machine?"

I initially thought it was statistics box, but I can't seem to find a way to get average time PER MACHINE the best I can do is to get average time per Transfer - which is not what I need currently.

Any help would be much appreciated.

[simenkg]

It is probably a text box with an expression.

Create a new text box. In the "text" field write something like

=sum(Time)/Count(Machine)

[#3]

What expression would I use to get something like:

"

Avg Time per Transfer

6

"

[simenkg]

I can't give you specifics without knowing about your data, but any average Dimension1 per Dimension2 is defined as
Sum(Dimension1)/Count(Dimension2)

So Avg Time per Transfer would be Sum(Time)/Count(Transfer)

[MarcoWedel]

For the line break a

='Text'&chr(10)&value

will do.in a text box (chr(13) also).

hope this helps

regards

Marco

[simenkg]

Or you can just do a line break inside the quotes:

='Text

'&value

[#7]

Another question, what is this object?

[MarcoWedel]

chart type pivot table

[MarcoWedel]

try to open new threads for independent questions though

thanks

regards

Marco

[nagaiank]

You need to create two text box object, one with the text and another with the number, as these have two different font sizes.