Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

JobDescriptionJobSequenceRunDateExpectedStartTimeJobStatus
Enlighta Load19-Oct-1210/19/12 8:00COMPLETED ONTIME
Enlighta Sync19-Oct-1210/19/12 10:05START DELAY RUNNING
Enlighta Validation19-Oct-1210/19/12 13:20NOT STARTED
Prism Load19-Oct-1210/19/12 8:00COMPLETED WITH DELAY
Prism Sync19-Oct-1210/19/12 8:00COMPLETED ONTIME
Prism Validation19-Oct-1210/19/12 18:05NOT STARTED
Enlighta Load20-Oct-1210/20/12 8:00NOT STARTED
Enlighta Sync20-Oct-1210/20/12 10:05NOT STARTED
Enlighta Validation20-Oct-1210/20/12 13:20NOT STARTED
Prism Load20-Oct-1210/20/12 8:00NOT STARTED
Prism Sync20-Oct-1210/20/12 8:00NOT STARTED
Prism Validation20-Oct-1210/20/12 18:05NOT STARTED

I have the above table .... When a user select a particular JobSequenceRunDate,say example-19-Oct-12 then based on the selection all my JobDescription should be classified under the respective Hours slot with JobStatus that were scheduled to run on that date.

Output:

Hours slotJobDescriptionJobDescriptionJobDescription
23:00
0:00
1:00
2:00
3:00
4:00
5:00
6:00
7:00
8:00

Enlighta Load

COMPLETED ONTIME

Prism Load

COMPLETED WITH DELAY

Prism Sync

COMPLETED ONTIME

9:00
10:00

Enlighta Sync

START DELAY RUNNING

11:00
12:00
13:00

Enlighta Validation

NOT STARTED

14:00
15:00
16:00
17:00
18:00

Prism Validation

NOT STARTED

19:00
20:00
21:00
22:00

Thanks in Advance...

Message was edited by: deepak_mallick Done some changes as there was a horizontal scollbar coming....Hope its clear to everyone...Waiting for ur valuable responses

1 Solution

Accepted Solutions
Not applicable

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

Hi...Please find the attached file and let me know whether my approach is correct or not? Also can u please send me ur previous reply bcoz i've accidentally deleted it.

9 Replies
whiteline
Honored Contributor II

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

Hi.

I think you could use the same approach as MasterCalendar, but in your case it's more like 'MasterTime' since you need only hours.

Then you could use concat() to show JobDescriptions within the same hour, or you could rearrange your data to have the JobDescription order number as dimension.

Not applicable

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

Thanks whiteline, but can u demonstrate it with an example so dat i can understand?

Not applicable

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

Hi...Please find the attached file and let me know whether my approach is correct or not? Also can u please send me ur previous reply bcoz i've accidentally deleted it.

whiteline
Honored Contributor II

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

You' ve almost done.

Craete a chart with Hour_Min as dimension and =Concat(JobDescription, ', ') as expression.

Not applicable

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

I used the above dimension and expression, but the chart is showing "No data to display"?

whiteline
Honored Contributor II

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

You think I'm  cheating?

Not applicable

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

If a cheater can be helpful, den i'll go dat way....Thanks a lot....u made my day buddy........Cheers

whiteline
Honored Contributor II

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

Did you manage to create that chart or not ?

Not applicable

Re: How-To:Classify different jobs that were scheduled on a particular date under respective time with its Status.

Yes! I did...

Community Browser