topic Above function in QlikView

Above function

alec1982 — Mon, 25 Nov 2013 06:31:02 GMT

hi,

I'm trying to use above function in a bar chart but it is giving me null..

here is the table i'm using:

QR	Key1	Revenue
4/2013	0	1085.00000000000
1/2014	1	1089.00000000000
2/2014	2	1107.00000000000
3/2014	3	1096.00000000000
4/2014	4	1172.00000000000
1/2015	5	-
2/2015	6	-
3/2015	7	-

and in the chart the dim is QR and EXP=

if( Key1>4 , above(Revenue) *2 ,Revenue)

Re: Above function

er_mohit — Mon, 25 Nov 2013 07:01:21 GMT

enclose it with sum

if( Key1>4 , above(sum(Revenue)) *2 ,sum(Revenue))

Re: Above function

Mon, 25 Nov 2013 07:07:36 GMT

Hi,

you can done this in load script also.

try this,

LOAD

QR,

Key1,

Revenue,

If(Key1 > 4, Peek('NewRevenue') * 2, Revenue) As NewRevenue

From table.

I hope this helps you

Regards,

Ashutosh

Re: Above function

jagan — Mon, 25 Nov 2013 07:15:12 GMT

Hi,

Try this in script it is easier and efficient

LOAD

If(Key1 > 4, Peek('NewRevenue') * 2, Revenue) AS NewRevenue

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Above function

alec1982 — Mon, 25 Nov 2013 14:26:52 GMT

Hi,

Inclose with Sum didn't help.

I cannot do in script because the actual expression is if( Key1>4 , above(Revenue) *$(vHC) ,Revenue)

where vHC is a variable entered by the user.. so it needs to be on the expression..

Thxs,

Alec

Re: Above function

Mon, 25 Nov 2013 14:40:57 GMT

Hi,

Name your expression as Revenue1 and use the following expression in chart

if( Key1>4 , Above(Revenue1) *2 ,Revenue)

Re: Above function

alec1982 — Mon, 25 Nov 2013 15:10:46 GMT

Hi,

Thxs for the help but it didnt work too..

Re: Above function

Mon, 25 Nov 2013 15:13:12 GMT

can you attached sample file or an JPG image what you want to achieve when it is null.

Re: Above function

alec1982 — Mon, 25 Nov 2013 15:17:35 GMT

The source data is as shown above ..very simple table and the expression and dim are defined above too.

the result table should look like:

QR	Key1	Revenue
4/2013	0	1085.00000000000
1/2014	1	1089.00000000000
2/2014	2	1107.00000000000
3/2014	3	1096.00000000000
4/2014	4	1172.00000000000
1/2015	5	2344
2/2015	6	4688
3/2015	7	9376

Thxs for all your help

Re: Above function

Mon, 25 Nov 2013 15:23:26 GMT

hi,

Label you expression as Rev1

and use the following Expression

if( Key1>4 , Above(Rev1) *2 ,Revenue)

As it is wrking on my side

Re: Above function

alec1982 — Mon, 25 Nov 2013 15:28:49 GMT

Hi,

Thxs again.. Can you please attach a sample .. it returns Nulls on my side..

Thxs,

Alec

Re: Above function

Mon, 25 Nov 2013 15:39:13 GMT

try this expression

Label you expression as Rev1

and use the following Expression

if( Key1>4 , above(TOTAL Rev1) *2 ,Revenue)