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: 
Ramya
Contributor III
Contributor III

How to get the back ground color based on last ran time stamp in the pivot table

Hi ,

I have one pivot table with the background color logic as below

if(Coordinator_latest_status='SUCCEEDED',Green(255),if(Coordinator_latest_status='FAILED',Red(255),if(Coordinator_latest_status='WAITING',Yellow(255),Blue(255))))

But it is not working as expected .

I need to get the same logic based on the last ran time(time stamp) of job_Started_ts because some of the jobs will run multiple times in the same day. It should be based on the last refresh of the app like as below

Coordinator_job_nameCoordinator_latest_statusjob_Started_tsjob_Ended_ts
ClickSteamMappingSUCCEEDEDSUCCEEDED12/18/2019 3:0012/18/2019 3:02
ClickSteamMappingSUCCEEDEDSUCCEEDED12/18/2019 11:0012/18/2019 11:03
ClickSteamMappingSUCCEEDEDSUCCEEDED12/18/2019 12:0012/18/2019 12:01

 In the above example it has the latest date with time stamp as 3:00 pm when the app refreshes at 3 pm then it should show as green as the status is succeeded if not it should show as per the above logic.

Here i am attaching the  qvf and sample data for reference.

Can anyone help me on this.

Thanks,

Ramya.

 

 

 

 

 

1 Reply
mayuringale25
Partner - Creator
Partner - Creator

HI @Ramya 

Please provide sample data.

Thanks and Regards
Mayur Ingale