Bar Chart from Static Data

Thu, 30 May 2013 10:55:55 GMT

Hi,

callref	groupid	repid	udid	udindex	udtype	Updatetime	updatetxt	count(cust_name)
								1
195722	SERVICE DESK	willmq	1130675	0	3329	18/04/2013	Logged From Inbound Email (Mailbox: Group Services I.T. Service Desk,	1
195722	IT SUPPORT	cookaz	1130711	1	1	18/04/2013	Call assigned to the IT SUPPORT group by cookaz (switched in group context)	1
195722	IT SUPPORT	aliaz	1130729	2	1	18/04/2013	Call was accepted by aliaz and the response time was acknowledged and achieved.	1
195722	IT SUPPORT	aliaz	1130895	3	1	18/04/2013	Hi Asif, Still can't get in after resetting my password to tipton123 on Samba which Colin did for me. See if yiu can try or will have to wait until Dave S is back in	1
195722	IT SUPPORT	aliaz	1130896	4	514	18/04/2013	The Username on samba whitcb.docx file has been added to the call by aliaz	1
195722	IT SUPPORT	aliaz	1132721	5	1025	23/04/2013	I have advised user to map the share by putting the following logon format Username: cyborg61\whitcb and then the password for that server which is now working fine, Chris to further action this call and have requested to pass this call to him.	1
195722	SERVICE DESK	willmq	1132722	6	1	23/04/2013	Call assigned to whitcb by willmq	1
195722	FINANCIAL SYSTEMS	whitcb	1132867	7	1	23/04/2013	Call accepted by whitcb	1
195722	FINANCIAL SYSTEMS	whitcb	1132868	8	1	23/04/2013	chris tested it works at Green Lane	1
195722	FINANCIAL SYSTEMS	whitcb	1132869	9	1	23/04/2013	have arranged for this to be made available for Chantelle next week.	1

The above table is a copy of all the information that occurred on a specific call (call refL 195722). In the updatetxt field we have information that user has not input such as call accepted by, call assigned to etc. We need to create a chart that counts the call ref (in this case 1), and then enters into a Bar Chart the month in which the call was accepted or assigned. However as we the above call on the 18/04/2013 under udindex no2 the call was accepted, however it was then accepted again on 23/04/2013. If we were running the report on the 30/04/2013, we would like this to show that the call has been accepted. Is this possible?

Re: Bar Chart from Static Data

sivarajs — Thu, 30 May 2013 11:20:37 GMT

Create a flag to find Call Assigned/Call Accepted then use this field in the bar chart

if(wildmatch(upper(updatetxt) ,'*CALL ASSIGNED*'),'Call Assigned',

if(wildmatch(upper(updatetxt) ,'*CALL ACCEPTED*'),'Call Accepted')) as Flag

topic Re: Bar Chart from Static Data in QlikView

Bar Chart from Static Data

Re: Bar Chart from Static Data