Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
oxiofrt
Partner - Creator
Partner - Creator

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
Partner - Creator
Partner - Creator
Author

You did it !

GREAT !

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

View solution in original post

8 Replies
oxiofrt
Partner - Creator
Partner - Creator
Author

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

Thanks a lot for your hep

Not applicable

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

- Sridhar

oxiofrt
Partner - Creator
Partner - Creator
Author

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

Not applicable

Hi,

Check whether attached application would help...?

- Sridhar

oxiofrt
Partner - Creator
Partner - Creator
Author

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

Hi,

Check the attachment.

- Sridhar

oxiofrt
Partner - Creator
Partner - Creator
Author

You did it !

GREAT !

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

oxiofrt
Partner - Creator
Partner - Creator
Author

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 ?