Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

oxiofrt
Contributor

Using AGGR fonction to retrieve same value on each line of a table ?

Hi,

my pivot table has 2 dimensions (A & B in screen capture hereafter).

"Délai route moyen" is a calculated expression with a syntax like : sum( integers) / count(distinct dimensions).
I would like to be able to fit next column ("Délai route moyen appel1") with the value of "Délai route moyen" located on the line where A=B.

In the example hereafter, value should be 6.
Line where A=B may not be the first one.

error loading image

Formula I tried is something like :
max( total A aggr(if(A=B, formula of "Délai route moyen",0) ,A)
Infact what is the matter is that I need first to calculate the formula of "Délai route moyen" (which is containing agregate functions) and then keep only the right line...

Please help................[*-)]

1 Solution

Accepted Solutions
oxiofrt
Contributor

Using AGGR fonction to retrieve same value on each line of a table ?

You did it !

GREAT !

Hope to be helpful for you next time, really thanks Big Smile

8 Replies
oxiofrt
Contributor

Using AGGR fonction to retrieve same value on each line of a table ?

MMM still no answer (what is unusual :-), is it that difficult ?

Thanks a lot for your hep

Not applicable

Using AGGR fonction to retrieve same value on each line of a table ?

Would it be possible to post a sample data with the application explaining your prob`s..?

- Sridhar

oxiofrt
Contributor

Using AGGR fonction to retrieve same value on each line of a table ?

Thanks for your answer. Herejoined is an application detailing the matter.

Not applicable

Using AGGR fonction to retrieve same value on each line of a table ?

Hi,

Check whether attached application would help...?

- Sridhar

oxiofrt
Contributor

Using AGGR fonction to retrieve same value on each line of a table ?

Not really...

I would like to have this value repeated on each line. It would be used to calculate on each line in a third column the difference between "Delai moyen route" and "New column".

it should look like screencapture (modified with photoshop... ) hereafter and completed by another column which would calculate the difference between "Délai moyen route" and "New Column"

Thanks for your help

Not applicable

Using AGGR fonction to retrieve same value on each line of a table ?

Hi,

Check the attachment.

- Sridhar

oxiofrt
Contributor

Using AGGR fonction to retrieve same value on each line of a table ?

You did it !

GREAT !

Hope to be helpful for you next time, really thanks Big Smile

oxiofrt
Contributor

Using AGGR fonction to retrieve same value on each line of a table ?

Last thing if you have one more second...

I have a strange behaviour while trying to order the table on the expression "Delai moyen route" descending. It is mostly ok but sometimes false ?

Community Browser