Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
oxiofrt
Partner
Partner

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

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

Not applicable

Hi,

Check whether attached application would help...?

- Sridhar

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

You did it !

GREAT !

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

View solution in original post

oxiofrt
Partner
Partner
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 ?