topic Re: What is this called...? in QlikView

What is this called...?

Wed, 26 Nov 2014 23:33:33 GMT

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.

Re: What is this called...?

simenkg — Wed, 26 Nov 2014 23:37:56 GMT

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)

Re: What is this called...?

Wed, 26 Nov 2014 23:45:39 GMT

What expression would I use to get something like:

Avg Time per Transfer

Re: What is this called...?

simenkg — Wed, 26 Nov 2014 23:54:00 GMT

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)

Re: Re: What is this called...?

MarcoWedel — Wed, 26 Nov 2014 23:59:58 GMT

For the line break a

='Text'&chr(10)&value

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

hope this helps

regards

Marco

Re: Re: What is this called...?

simenkg — Thu, 27 Nov 2014 00:13:28 GMT

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

='Text

'&value

Re: What is this called...?

Thu, 27 Nov 2014 00:17:37 GMT

Another question, what is this object?

Re: What is this called...?

MarcoWedel — Thu, 27 Nov 2014 00:21:27 GMT

chart type pivot table

Re: What is this called...?

MarcoWedel — Thu, 27 Nov 2014 00:23:53 GMT

try to open new threads for independent questions though

thanks

regards

Marco

Re: What is this called...?

nagaiank — Thu, 27 Nov 2014 01:32:51 GMT

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

Re: What is this called...?

jpenuliar — Thu, 27 Nov 2014 11:27:02 GMT

Hi,

Have you got access to the original qvw file your said you are trying to recreate? how are you able to take the screenshots?

If in case you have, you can right click on the object and find out, what type it is, and any onther details like expressions involve in that object

Re: What is this called...?

Anonymous — Thu, 27 Nov 2014 11:29:30 GMT

Hi,

Its text & Value

Re: What is this called...?

Thu, 27 Nov 2014 12:18:33 GMT

Hi,

That is text object

looks like the expression like this

='Average Time per Machine'&chr(10)&avg(machinetime)