topic Re: Re: Above Function in QlikView

Above Function

soha1902 — Fri, 27 Jun 2014 07:53:17 GMT

Hi All,

Please correct my expression.

I am using Sum(Sales - Above(Sales)), it shaowing error. whats wron in this expression.

Please suggest.

Re: Above Function

MK_QSL — Fri, 27 Jun 2014 07:55:09 GMT

Sum(Sales) - Above(Sum(Sales))

Sum(Sales) - Above(Sales)

Re: Above Function

its_anandrjs — Fri, 27 Jun 2014 07:57:47 GMT

Expression is wrong you have to try

Sum(Sales) - Above(Sales)

Re: Re: Above Function

soha1902 — Fri, 27 Jun 2014 08:09:04 GMT

I tried but now its showing nothing.

Please find attached sample app.

Re: Above Function

MK_QSL — Fri, 27 Jun 2014 08:13:02 GMT

What you want to achieve?

You have to select something to get output in text file or use aggr function like below

=Max(Aggr(Sum(Sales) - Above(Sum(Sales)),Sales))

Re: Above Function

Fri, 27 Jun 2014 08:16:42 GMT

Hi Soha,

Try using Sum(Aggr(Sum(Sales) - Above(Sum(Sales)),Sales)) for your requirement.

Regards,

Sabal

Re: Above Function

its_anandrjs — Fri, 27 Jun 2014 08:40:59 GMT

In chart expression you have to use

Sum(Sales) - Above(Sales)

But in text object why you use Sum(Sales) - Above(Sales) it is not good practice what ever you can use this expression will give correct result but sales value not used in aggregation expression some other dimensions are used.

=Max( Aggr( Sum(Sales) - Above(Sum(Sales)),Sales))

Re: Above Function

hic — Fri, 27 Jun 2014 09:11:28 GMT

No, no, no... !!!!

This is a typical case when you don't need the Aggr() function - and probably shouldn't use it. Instead you should just use normal aggregation functions. And note that Above() is not an aggregation function. The correct way to write it is:

Sum(Sales) - Above(Sum(Sales))

or, if you want to avoid the problem with NULL values:

RangeSum( Sum(Sales), -Above(Sum(Sales)) )

HIC