topic Re: Chart Expression in QlikView

Chart Expression

Thu, 26 Jun 2014 06:39:33 GMT

Hello Everyone,

As in following Chart for Jan column i need to show for ex (1323/3421) for critical Request and (2168/3491) for Grievance,count 1323 i am getting from count(callid) ,callid is unique field .In case of more clarification please reply.

Re: Chart Expression

its_anandrjs — Thu, 26 Jun 2014 06:44:19 GMT

You can try

count(callid) / count(TOTAL callid)

And how comes 3421

Re: Chart Expression

Thu, 26 Jun 2014 06:45:47 GMT

=count(callid) & '/' & count(total callid)

Re: Chart Expression

Thu, 26 Jun 2014 06:56:03 GMT

hi anand ,

3421 is total of callid for Jan month for critical request and grievance as shown in image

and count(callid) / count(TOTAL callid) is giving 0.039 where as it should come 1323/3421 =0.38,, count (total callid)

is giving me total count 33413 not the total count for month Jan 3421?

Re: Chart Expression

Thu, 26 Jun 2014 06:56:17 GMT

count(callid) / count(TOTAL callid) is giving 0.039 where as it should come 1323/3421 =0.38,, count (total callid)

is giving me total count 33413 not the total count for month Jan 3421?

Re: Chart Expression

Thu, 26 Jun 2014 08:09:09 GMT

guys kindly reply.

Re: Chart Expression

PradeepReddy — Thu, 26 Jun 2014 08:12:20 GMT

can you please attach the sample .qvw file?. So that it will be easy to understand the issue.

Re: Chart Expression

johanlindell — Thu, 26 Jun 2014 08:59:56 GMT

Hi,

You need to state the field in which to do the Total. I'm a bit unsure bot is should either be

count(callid) / count(TOTAL <CallCategory> callid)

count(callid) / count(TOTAL <Month> callid)

Try it and you will find which it is.

If you do not state which field to sum on, you will get the sum of acc CallCategories and all Months.

Brgds, Johan

Re: Chart Expression

Thu, 26 Jun 2014 09:38:25 GMT

Hi johan

Thank you soo much its working i needed to do total for Month field.Thanx

Re: Chart Expression

johanlindell — Thu, 26 Jun 2014 09:54:46 GMT

Hi Robit!

Good that works. Please set the thread to answered.

Johan