topic Re. :Re: Re. :AVG WITH MANY EXPRESSIONS in QlikView

AVG WITH MANY EXPRESSIONS

Fri, 13 Aug 2010 15:02:13 GMT

Hy,

I´m using this variable

V_Contagem_Tempo=if(TEMPO_PROCESSO.CD_TIPO_TEMPO_PROCESSO=30,'CHAMADA','ATENDIMENTO')

In the expression of a chart I do this expression

IF(V_Contagem_Tempo='CHAMADA', MIN(TEMPO_PROCESSO.DH_PROCESSO)-ATENDIME.DH_PRE_ATENDIMENTO_FIM, MIN(PREST_USER_DOCUMENTOS.DT_REGISTRO_DOC)-ATENDIME.DH_PRE_ATENDIMENTO_FIM)

How can I put an AVG function with this expression

AVG(MIN(TEMPO_PROCESSO.DH_PROCESSO)-ATENDIME.DH_PRE_ATENDIMENTO_FIM, MIN)

DON´T WORK....

Any Idea?

Thanks for the help.

Re. :AVG WITH MANY EXPRESSIONS

martin59 — Fri, 13 Aug 2010 15:09:29 GMT

Hi,

Is that you want :

rangeavg(MIN(TEMPO_PROCESSO.DH_PROCESSO)-ATENDIME.DH_PRE_ATENDIMENTO_FIM,MIN(PREST_USER_DOCUMENTOS.DT_REGISTRO_DOC)-ATENDIME.DH_PRE_ATENDIMENTO_FIM))

Re. :AVG WITH MANY EXPRESSIONS

Fri, 13 Aug 2010 15:33:03 GMT

Thank you... but don´t work...

I´m not using a range of values.

I´m using a conditional expression.

But if you help me to do a AVG with the expression bellow it´s fine.

MIN

(PREST_USER_DOCUMENTOS.DT_REGISTRO_DOC)-ATENDIME.DH_PRE_ATENDIMENTO_FIM)

Sorry for my english.....

Thanks

Re. :AVG WITH MANY EXPRESSIONS

martin59 — Fri, 13 Aug 2010 15:37:32 GMT

are you using a straight table ?

Re. :AVG WITH MANY EXPRESSIONS

Fri, 13 Aug 2010 15:49:28 GMT

No, i´m using a gauge chart.

Re. :Re: Re. :AVG WITH MANY EXPRESSIONS

martin59 — Fri, 13 Aug 2010 16:01:40 GMT

I don't understand what you want, why do you want to do an avg if you do a min ?

if you really want to do an avg, you must have a dimension that you have to use with aggr() function like this :

avg(aggr(YourExpression, Dimension))

Re. :Re: Re. :AVG WITH MANY EXPRESSIONS

Fri, 13 Aug 2010 16:35:10 GMT

Let me explain..

I have a select that bring´s me this

cd_triag, cd_document, dh_document

1:n

But in a lot of times the same cd_atend have a lot of documents (this is ok)

I have another table that contains

cd_atend, dh_atend

1:1

I need to calculate de time between the first document by dh(date hour) of document and the dh(data hour) atend for this I use.

min(dh_document) - dh_atend

But I have a lot of values on database that have 450 GB of data, and a need to make a average of the expression above.

The logical is to do a gauge chart that´s represents the average time in a selected date and show if the time is ok, our not ok. Depending on criterias.

Again, sorry for my english.

And thank you for the help.

Re. :Re: Re. :AVG WITH MANY EXPRESSIONS

martin59 — Mon, 16 Aug 2010 09:11:51 GMT

Ok,

If I were you, I will calculate the expression in the load script, like this :

interval(min(dh_doc) - dh_atend) as dh_interval

Maybe, you should be transform your datas to attempt this formula...

After that, you have to use this field for your average :

avg(dh_interval)

Re. :Re: Re. :AVG WITH MANY EXPRESSIONS

Mon, 16 Aug 2010 12:45:47 GMT

The problem is how to count the first register of table, only the first register must be calculated.

Re. :Re: Re. :Re: Re. :AVG WITH MANY EXPRESSIONS

martin59 — Mon, 16 Aug 2010 13:43:08 GMT

Sorry, but I don't understand what you want...