Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this?
Could you please share some pic sample output.
try like this:
In the expression :
sum(A)+Sum(B)
load A,
B,
alt(A,0) + alt(B,0) as A_B
From Table
Now create the expression as
Sum(A_B)
like this you want?
You can simply write sum(A) +Sum(B) or simply A+B as Expression
see the attachment
try this hope its help you
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 .
Hi Anusha,
Attach some sample file and let us know your required output so that it would be easier to provide solution.
Regards,
Jagan.
Please attach .qvw file for more clarification