Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
prashanthi_gn
Contributor III
Contributor III

data cleaning/data modeling for SLA's

Hi

i have data with relative SLA's like in below screenshot and can i put each value in new row for the respective jobID and want it in timestamp with AM or PM. can i use a Vlookup kind if i get the new SLA's, then I don't have to  change my data load every time.

prashanthi_gn_0-1616931790363.png

 

Labels (3)
2 Replies
morgankejerhag
Partner
Partner

I am sorry, but I don't understand what you mean. How does SLA and jobID relate to each other? The corresponding function to VLOOKUP in Qlik is applymap(). That function only works in the script though.

prashanthi_gn
Contributor III
Contributor III
Author

hi @morgankejerhag ,

I'm trying to find the ways to get STA_Status in a single record for each sla (Ex:  incase of  6:30 10:30 4:30 18:30,  i need sla status met or failed for ever sla in separate line).

And my sla column need to be cleaned or create some kind of vlookup. if I have to , then how. 

prashanthi_gn_0-1617124839901.png