Above function

[alec1982]

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)

[er_mohit]

enclose it with sum

like

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

[#3]

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

[jagan]

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.

[alec1982]

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

[#6]

Hi,

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

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

[alec1982]

Hi,

Thxs for the help but it didnt work too..

[#8]

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

[alec1982]

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

[#10 · Accepted solution]

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