Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
kicchu465
Contributor

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
Honored Contributor

Re: Data Vizualisation

please promote bucket dimension, i forgot to promote

5 Replies
shiveshsingh
Honored Contributor

Re: Data Vizualisation

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
Contributor

Re: Data Vizualisation

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
Honored Contributor

Re: Data Vizualisation

Capture.JPG

May be this?

shiveshsingh
Honored Contributor

Re: Data Vizualisation

Capture.JPG

shiveshsingh
Honored Contributor

Re: Data Vizualisation

please promote bucket dimension, i forgot to promote