Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
cavetroll
Contributor III
Contributor III

Qlik App New Data

I'm been asked to create an app to monitor all apps for new data. I have a method I plan to use for this, but it's a bit tedious. I wanted to know if there is anything already in place on the QMC I am not aware of, or if there are fields ect that I could use to do this instead.

There is an issue that we cannot always validate if an application has updated, or even if the data load ran, we cannot tell if there are new rows.

What we want is something like:
App Name | Table Name | Last Number or Rows | Current Number of Rows | Load Date |
 

My formal question: Is there already something built in I should read up on?

-Cavetroll
2 Solutions

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I imagine you can get what you need from the https://community.qlik.com/t5/Qlik-Monitoring-Administration/Sense-App-Metadata-Analyzer/gpm-p/15921....  If not, you can get some ideas about how to get what you want using the QRS API. 

-Rob

View solution in original post

cavetroll
Contributor III
Contributor III
Author

That's kind of what I was thinking of in my process, I just felt there had to be a better way. I was going to do an include directed to some sub routines and use them to load append and restore the QVD each time our load process is ran. Then I could load the QVD with the stats into an app and use that to monitor, however I thought that perhaps something like Rob posted would be available, I just didn't know where to look. 

-Cavetroll

View solution in original post

3 Replies
ajaykakkar93
Specialist III
Specialist III

While making all the qvd for all your app you can make a inline table below all qvd n concat it together

Your inline script will have the columns you/your team requires for monitoring the qvd.

After your qvd stage is done before exit you can concat & store it to final qvd date wise or standalone qvd.

Lode the set of qvds/qvd in a custom app 

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I imagine you can get what you need from the https://community.qlik.com/t5/Qlik-Monitoring-Administration/Sense-App-Metadata-Analyzer/gpm-p/15921....  If not, you can get some ideas about how to get what you want using the QRS API. 

-Rob

cavetroll
Contributor III
Contributor III
Author

That's kind of what I was thinking of in my process, I just felt there had to be a better way. I was going to do an include directed to some sub routines and use them to load append and restore the QVD each time our load process is ran. Then I could load the QVD with the stats into an app and use that to monitor, however I thought that perhaps something like Rob posted would be available, I just didn't know where to look. 

-Cavetroll