topic Re: above function in QlikView

above function

Thu, 08 Aug 2013 10:30:41 GMT

Hi,

Pls help,

Id	ITD
1	2
2	4
3	6
4	3
5	1
6	7
7	5

my table look like this above and I want a result like this..

Id	ITD	Expression
1	2	-
2	4	2
3	6	4
4	3	6
5	1	6
6	7	6
7	5	7

what expression suits here..?I tried for =Above(Max(ITD)) but its not considering above previous values whether there is any other function apart from above..?

Re: above function

swuehl — Thu, 08 Aug 2013 10:32:55 GMT

You are using two dimensions, right?

Then you need to use the total qualifier, to get around the column segments:

=Above(TOTAL Max(ITD))

Re: above function

Thu, 08 Aug 2013 10:46:18 GMT

Hi Thanks for your replyb but answer is not coming for the above expression.....

Re: above function

swuehl — Thu, 08 Aug 2013 10:50:55 GMT

Seems to work for me.

Please post a small sample that demonstrates your issue.

Re: above function

Tue, 13 Aug 2013 12:55:35 GMT

Hi swuehl,

So I have a similar issue: I have two dimensions and a rangesum(above ...) expression. I use the TOTAL statement so that it takes care of the multiple dimension problem.

I get the pivot table to work as wanted and the figures are correct!

Now to my problem: I want to display the output in a line-chart, in fact convert the pivot to a line chart to rather disply it graphically as two lines plotted, one for each dimension (in my case plotted on time dimension, and the time dimension must be the first sorted dimension).

I do not get this to work ....... Do you have any suggestions??

Thank you!

David

Re: above function

Wed, 14 Aug 2013 07:38:03 GMT

Hi sathiyanc,

Please see if the attached app resolves your issue.

Kind Regards,

Footsie