Data Vizualisation

kicchu465 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have requirement to represent the data in better way.

The data as below.

Country	Process	Priority	Issue ID	Issue Description	Deadline	Overdue	Open Since
IN	TCM	High	RM - India-7522	-	3/31/2017	-	27-05-2016 15:12
IN	TCM	High	RM - India-7651	-	3/31/2017	-	30-01-2017 06:24
IN	TCM	Low	RM - India-7576	-	3/31/2017	-	11-08-2016 08:43
IN	TCM	Medium	RM - India-7466	-	3/31/2017	-	10-03-2016 12:18
IN	TCM	Medium	RM - India-7589	-	TBC	153 Days	02-09-2016 14:28
IN	TAX	Medium	RM - India-7542	-	1/31/2017	2 Days	13-07-2016 17:03
IN	TAX	Medium	RM - India-7543	-	3/1/2017	-	13-07-2016 17:08
IN	TAX	Medium	RM - India-7544	-	1/31/2017	2 Days	13-07-2016 17:15
IN	TAX	Medium	RM - India-7545	-	1/31/2017	2 Days	13-07-2016 17:18
IN	TAX	Medium	RM - India-7546	-	1/31/2017	2 Days	13-07-2016 17:35
IN	TAX	Medium	RM - India-7551	-	1/31/2017	2 Days	29-07-2016 13:13
IN	TAX	Medium	RM - India-7552	-	1/31/2017	2 Days	29-07-2016 13:15
IN	TAX	Medium	RM - India-7553	-	1/31/2017	2 Days	29-07-2016 13:19
IN	TAX	Medium	RM - India-7554	-	1/31/2017	2 Days	29-07-2016 13:21
IN	TAX	Medium	RM - India-7555	-	1/31/2017	2 Days	29-07-2016 13:23
IN	TAX	Medium	RM - India-7556	-	1/31/2017	2 Days	29-07-2016 13:34
IN	TAX	Medium	RM - India-7557	-	1/31/2017	2 Days	29-07-2016 13:36
IN	RtR	Medium	RM - India-7399	-	7/31/2016	186 Days	09-02-2016 06:41
IN	PtP	Medium	RM - India-7483	-	12/31/2016	33 Days	09-11-2016 10:22
IN	MDM	Medium	RM - India-7586	-	9/10/2016	145 Days	29-08-2016 11:46
IN	MDM	Medium	RM - India-7587	-	9/15/2016	140 Days	29-08-2016 14:37

Requiremnet as below:

1.We need to count the no .of issues based on Country/Process and out of total number issues we need to show how may are of them are of High/Medium/Low priority and from the subset we need to show how many issues have met the deadline.

For example:

For Country IN:

Issues are 21

and there are 3 Unique Process

Out of 21 issues

High 2 and all these Issues have met the deadline

Low 1 and all these Issues have met the deadline

Medium 18 out of which 2 Issues have met the Deadline and 16 issues not met the dead line.

Also if you can show the Bucket for the issues which have not met the deadline like Issues which have met the dead line =1 day to 10 and >10days to <=20 days and so on.

I need to show the above requirement in chart.

Awaiting for reply.

Thanks

Re: Data Vizualisation

shiveshsingh — Mon, 12 Feb 2018 16:09:39 GMT

SO in final chart, you need to show how many meet the deadlines and bucket column?

Which column is indicating that the deadline is met in your sample data?

Re: Data Vizualisation

kicchu465 — Mon, 12 Feb 2018 16:16:31 GMT

Hi,

Actually Yes.

The column will be overdue.

If overdue is Null then the issue has met the dead line and if not based on the bucket we have to represent the data.

Re: Data Vizualisation

shiveshsingh — Mon, 12 Feb 2018 17:11:13 GMT

May be this?

Re: Data Vizualisation

shiveshsingh — Mon, 12 Feb 2018 17:12:39 GMT

Re: Data Vizualisation

shiveshsingh — Mon, 12 Feb 2018 17:15:23 GMT

please promote bucket dimension, i forgot to promote

topic Re: Data Vizualisation in QlikView

Data Vizualisation

Re: Data Vizualisation

Re: Data Vizualisation

Re: Data Vizualisation

Re: Data Vizualisation

Re: Data Vizualisation