topic How to get field values in QlikView

How to get field values

Anonymous — Thu, 10 Dec 2015 06:27:41 GMT

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

Re: How to get field values

prma7799 — Thu, 10 Dec 2015 06:31:07 GMT

Like this?

Re: How to get field values

prma7799 — Thu, 10 Dec 2015 06:31:55 GMT

Could you please share some pic sample output.

Re: How to get field values

avinashelite — Thu, 10 Dec 2015 06:32:57 GMT

try like this:

In the expression :

sum(A)+Sum(B)

Re: How to get field values

Kushal_Chawda — Thu, 10 Dec 2015 06:43:27 GMT

load A,

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

From Table

Now create the expression as

Sum(A_B)

Re: How to get field values

Anonymous — Thu, 10 Dec 2015 06:43:33 GMT

like this you want?

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

see the attachment

Re: How to get field values

ahmar811 — Thu, 10 Dec 2015 06:53:05 GMT

try this hope its help you

Re: How to get field values

Anonymous — Thu, 10 Dec 2015 06:58:06 GMT

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 .

Re: How to get field values

jagan — Thu, 10 Dec 2015 07:15:43 GMT

Hi Anusha,

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

Regards,

Jagan.

Re: How to get field values

ahmar811 — Thu, 10 Dec 2015 09:41:18 GMT

Please attach .qvw file for more clarification