topic Re: calculating the maximal value in QlikView

calculating the maximal value

Anonymous — Wed, 29 Apr 2015 13:56:28 GMT

Hi,

I have a straight table in my application.

It has a dimention = Position

It has an expression which is defined by a variable = $(Reach)

My task is to calculate the maximal Reach in this straight table.

I try to calculate it in a separate text box.

So, I'm trying the following expression:

=max(aggr($(Reach), Position))

But it doesn't work. The result is incorrect.

Could you advise how I can calculate the maximal Reach?

Thank you in advance,

Larisa

Re: calculating the maximal value

sunny_talwar — Wed, 29 Apr 2015 14:08:30 GMT

What is the expression that you are using for your variable??

Re: calculating the maximal value

Agis-Kalogiannis — Wed, 29 Apr 2015 14:10:38 GMT

Your first attempt with the aggr function looks OK.

Some more info would be useful though!

Re: calculating the maximal value

Anonymous — Wed, 29 Apr 2015 14:16:43 GMT

Hi,

you should add Aggr function in your variable directly:

aggr( your_expression, Position)

Then, in the text object: =max($(Reach))

Elena

Re: calculating the maximal value

ramoncova06 — Wed, 29 Apr 2015 14:29:45 GMT

what kind of information does you variable has ?

have tried with the max($(Reach)), aggr has a performance toll so if you can avoid using it

Re: calculating the maximal value

Anonymous — Wed, 29 Apr 2015 14:43:35 GMT

If I do this, I get different results:

Reach1 = aggr(my_expression, Position)

Reach2 = my_expression

Reach1 doesn't equal Reach2.

My expression is like this:

(sum({<[Пол/Возраст] = p([ца_Пол/Возраст]), Доход = p(ца_Доход), Занятость = p(ца_Занятость),

Образование = p(ца_Образование), [Социальный статус] = p([ца_Социальный статус]),

[Население города] = p([ца_Население города])>}

weight*DaysQty)/$(vPeriod))

Re: calculating the maximal value

Anonymous — Wed, 29 Apr 2015 14:44:16 GMT

My expression is like this:

(sum({<[Пол/Возраст] = p([ца_Пол/Возраст]), Доход = p(ца_Доход), Занятость = p(ца_Занятость),

Образование = p(ца_Образование), [Социальный статус] = p([ца_Социальный статус]),

[Население города] = p([ца_Население города])>}

weight*DaysQty)/$(vPeriod))

Re: calculating the maximal value

Anonymous — Wed, 29 Apr 2015 14:47:35 GMT

If I try =max($(Reach)) either directly in a straight table or in a separate text box, I get -.

It isn't calculated.

Re: calculating the maximal value

Anonymous — Wed, 29 Apr 2015 14:51:01 GMT

I tryed with an expression that doesn't contain a variable (while there is one in yours) and it works...

I think, even in vPeriod you have to insert the aggr...

Re: calculating the maximal value

Anonymous — Wed, 29 Apr 2015 15:18:20 GMT

Your original attempt looks correct, I tried with the "sample" script, attached.

Do you get any result in a text box that contains just

$(Reach)

Re: calculating the maximal value

Anonymous — Wed, 29 Apr 2015 17:30:43 GMT

Thanks, everyone, for your answers! It was helpful.

I've found out that Max value was calculated correctly.

It was expression in my straignt table which gave a wrong result.

I changed the expression in my straight table as Elena suggested:

previous: $(Reach)

new: aggr($(Reach), Position)