Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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.

View solution in original post

9 Replies
whiteline
Master II
Master II

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
Author

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

Not applicable
Author

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
Master II
Master II

You' ve almost done.

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

Not applicable
Author

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

whiteline
Master II
Master II

You think I'm  cheating?

Not applicable
Author

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

whiteline
Master II
Master II

Did you manage to create that chart or not ?

Not applicable
Author

Yes! I did...