How to get field values

[Anonymous]

I have two fields like

A,B

100,1

200,2

300,3

400,4

500,5

I want to add the B , A in bar chart expression like 100+1=101,200+2=202,300+3=303.How to get this .

Please any one help me.

Thanks in advance

Thanks,

Anusha K

[prma7799]

Like this?

[prma7799]

Could you please share some pic sample output.

[avinashelite]

try like this:

In the expression :

sum(A)+Sum(B)

[Kushal_Chawda]

load A,

       B,

      alt(A,0) + alt(B,0) as A_B

From Table

Now create the expression as

Sum(A_B)

[Anonymous]

like this you want?

You can simply write sum(A) +Sum(B) or simply A+B as Expression

see the attachment

[ahmar811]

try this hope its help you

[Anonymous]

sorry I want to correct my question  field 'A' having string values. I am giving my expression used in my bar chart. In this expression i am giving 'B' field values manually

Pick( Match(if(X='N',A),

,'App  Not Entered and Backlog SLA Exceeded'

,'App Entered Not Quoted and Backlog SLA Exceeded'
  ),
count(DISTINCT IF(if(X='N' AND DT <= 0 and C='Application' and CL='PLI' and CL'LPL' ,date#(RDT,'YYYYMMDD')+1) < NUM(TODay()) AND PDT =0,Key)) ,
count(DISTINCT IF(IF(X='N' AND  DT <= 0 and RDT = 0 and DT = 0 ,if(DT > 0, date#(RDT,'YYYYMMDD')+2)) < NUM(TODAY()) AND RDT = 0,Key))

here I am adding +1 and +2 manually .

[jagan]

Hi Anusha,

Attach some sample file and let us know your required output so that it would be easier to provide solution.

Regards,

Jagan.

[ahmar811]

Please attach .qvw file for more clarification