Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
JustJoshin
Contributor
Contributor

Issues editing a load script from JSD API to include whether on not the ticket SLA was breached

Hi,

I recently took over a pre-existing Qlikview file for monitoring our Jira Service Desk performance and am trying to modify the load file so that the SLA for each ticket and whether or not it was breached or resolved before being breached to put into a table view. 

I would feel confident about doing this strictly through sequel but I'm not used to writing the LOAD calls to the API as such and all of my experimentation run into issues trying to add the appropriate fields. 

If someone knows of a resource I could utilize to specifically learn this better I would appreciate. I've attached the portion of the load script for this if anyone is able to take a look and tell me what I should be adding. 

Labels (4)
1 Reply
Brett_Bleess
Support (Former)
Support (Former)

Joshua, you can use straight SQL calls provided the ODBC/OLE DB provider you are using will translate things for you back to the source DB...  There is no need to use our script syntax and Load statement unless you want to do further modifications on things.  

Here is a link to our training area, there are some free things out there that might help a little, but it may be better if you can swing doing the Developer course, as I think that would be the most help to you at this point.

https://www.qlik.com/us/services/training

Other than that, here is a link to a very useful area of the Community, the Design Blog area, there are hundreds of posts out here with examples on specific use cases related to specific functionality in the product.  I am going to give you the base URL and let you search on your own, I usually do a single word first and see what pops up there and then use other words from those results to try to find things more focused...

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Sorry I am not more direct help here, but hopefully this may get you further along.  Others may be able to help if you can attach an app with what you have etc. and a picture of what you want, that is generally the most helpful for development questions.  Oh, if you are worried about confidential data, use the Settings\Document Properties\Scrambling tab in the Desktop/Developer client to scramble those fields before you post things...  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.