Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kicchu465
Creator
Creator

Data Vizualisation

Hi All,

I have requirement to represent the data in better way.

The data as below.

        

CountryProcessPriorityIssue IDIssue DescriptionDeadlineOverdueOpen Since
INTCMHighRM - India-7522-3/31/2017-27-05-2016 15:12
INTCMHighRM - India-7651-3/31/2017-30-01-2017 06:24
INTCMLowRM - India-7576-3/31/2017-11-08-2016 08:43
INTCMMediumRM - India-7466-3/31/2017-10-03-2016 12:18
INTCMMediumRM - India-7589-TBC153 Days02-09-2016 14:28
INTAXMediumRM - India-7542-1/31/20172 Days13-07-2016 17:03
INTAXMediumRM - India-7543-3/1/2017-13-07-2016 17:08
INTAXMediumRM - India-7544-1/31/20172 Days13-07-2016 17:15
INTAXMediumRM - India-7545-1/31/20172 Days13-07-2016 17:18
INTAXMediumRM - India-7546-1/31/20172 Days13-07-2016 17:35
INTAXMediumRM - India-7551-1/31/20172 Days29-07-2016 13:13
INTAXMediumRM - India-7552-1/31/20172 Days29-07-2016 13:15
INTAXMediumRM - India-7553-1/31/20172 Days29-07-2016 13:19
INTAXMediumRM - India-7554-1/31/20172 Days29-07-2016 13:21
INTAXMediumRM - India-7555-1/31/20172 Days29-07-2016 13:23
INTAXMediumRM - India-7556-1/31/20172 Days29-07-2016 13:34
INTAXMediumRM - India-7557-1/31/20172 Days29-07-2016 13:36
INRtRMediumRM - India-7399-7/31/2016186 Days09-02-2016 06:41
INPtPMediumRM - India-7483-12/31/201633 Days09-11-2016 10:22
INMDMMediumRM - India-7586-9/10/2016145 Days29-08-2016 11:46
INMDMMediumRM - India-7587-9/15/2016140 Days29-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

Sk

1 Solution

Accepted Solutions
shiveshsingh
Master
Master

please promote bucket dimension, i forgot to promote

View solution in original post

5 Replies
shiveshsingh
Master
Master

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?

kicchu465
Creator
Creator
Author

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.

shiveshsingh
Master
Master

Capture.JPG

May be this?

shiveshsingh
Master
Master

Capture.JPG

shiveshsingh
Master
Master

please promote bucket dimension, i forgot to promote