topic re-use a calculated colunm in QlikView

re-use a calculated colunm

mohamed_ahid — Mon, 08 Sep 2014 15:40:02 GMT

i want to have a max and min (max evolution and min evolution) value depending on a calculatd colunm (evolution) .

i tried all the expression of evolution in my aggr function and it works . but when i use the name of evolution in my aggr function it returns 0 .

see the sample .

Thx for helping .

Re: re-use a calculated colunm

Mon, 08 Sep 2014 15:50:03 GMT

What are you trying to show as Max evoluution? the largest value of the other columns?

Richard

Re: re-use a calculated colunm

MK_QSL — Mon, 08 Sep 2014 15:50:07 GMT

=Max({1}Aggr((sum({1<week= {">=$(=1)<=$(=9)"}> } value)-sum({1<week= {">=$(=10)<=$(=15)"}> } value))/(sum({1<week= {">=$(=1)<=$(=9)"}> } value)-sum({1<week= {">=$(=10)<=$(=15)"}> } value)),client))

Re: re-use a calculated colunm

mohamed_ahid — Mon, 08 Sep 2014 15:52:56 GMT

but why i can re use simply the colunm evolution ?

Re: re-use a calculated colunm

mohamed_ahid — Mon, 08 Sep 2014 15:55:43 GMT

Thx

in max evolution i should have 1 as value and -1 for min evolution .

my simple is not complete but this will be usefull in other expressions not detailled in this sample

Re: re-use a calculated colunm

MK_QSL — Mon, 08 Sep 2014 15:58:33 GMT

Because here you have to freeze the selection by using 1 in set analysis which you haven't frozen in your evolution expression...

Re: re-use a calculated colunm

Mon, 08 Sep 2014 16:00:01 GMT

I would imagine its because the Evoulution is generated as a result of one set of "set analysis" commands (ie { $ }) , then you are trying to refernece it by another set. ( {1} )

I think there are rules around using Calculated expressions.

the solution provided by Manish is the one I would use.

Richard

Re: re-use a calculated colunm

MK_QSL — Mon, 15 Sep 2014 09:36:18 GMT

Have you check my reply?