Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
apatra87
Contributor III
Contributor III

Fetching data Runtime from QVD file as per user selection into the QlikSense application

Hi Team,

Due to huge data volume for one year only, one of my QlikSense applications the reload time and the performance is not good. I know for one single X. QVD which consists base64 images due to this it's happening.

So my question is it possible to load the X.QVD runtime as per user selection only a selected data will be fetched from the X.QVD?

Thank you in advance.

 

Thanking you,

Br,

Anup

 

 

9 Replies
pedrobergo
Employee
Employee

Hi @apatra87 

To load just small part of your large data volume, after a user filtering some fields, you can use ODAG and Dynamic Views.

Check this video to understand a little bit more https://www.youtube.com/watch?v=Ft3I00-g4H4 and this to implement it https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/mc-administer-odag... 

[],

Pedro

apatra87
Contributor III
Contributor III
Author

Hi Pedro,

 

Thank you for your help!

Let me check with that. But in my application, I have an "On Demand" button to generate the NPrinting report and I think NPrinting is not working in that case.

So is there any other way to fetch a single table that contains some images(base 64 - GCP Data) and showing this image into the extension object run time?

 

Thanking you,

Regards,

Anup

pedrobergo
Employee
Employee

Hi @apatra87 

Well, to display an external image, you can try these options:

- Table with links: Use this extension to show the images inside a table, using a URL. https://developer.qlik.com/garden/567836fd8703093925d91d03 

- Use a MGO Grid extension, that you could be display any number of images, linked by url or local https://developer.qlik.com/garden/56e8f64ee37930b98cf9dea4

- Use GeoAnalytics Map: Create a Background Layer using a variable to set up the image url link. You can Zoom It any images.

All of it will works fine, but not sure about NP.

[],

Pedro

apatra87
Contributor III
Contributor III
Author

Hi Pedro,

Thanks a lot for your help.

In my case, I have to fetch the image directly to GCP(my data source) or QVD, the total no of images is more than 50K, is it possible to do that as per your suggested option?

It will be very helpful if you provide me a demo application.

 

Thanking you,

Regards,

Anup

pedrobergo
Employee
Employee

Hi @apatra87 

I can share you this app example wich explore the NY public library with more than 150k images using MGO Grid extension (v2). The library index was loaded to Qlik memory and then displayed the images using theirs url after user selected some fields like collections or titles. These extension can handle images using a direct url or indirect, using url header parameters. See the extension link to more details.

So, to display images from GCP, you just point to them using the url. I never did that, but i guess you'll need to create shared links to each image, then you can use it. Otherside, to use images "inside" QVD (like a base64 encoded) you'll need to upload it into the memory, and ODAG/Dynamic Views is the best for this.

Notes: To install the extension MGO Grid, see the extension link to detaisl.

[],

Pedro

apatra87
Contributor III
Contributor III
Author

Hi Pedro,

Great!! So helpful.

In my scenario, I have to show one image at a time, not multiple images as a Grid view. Is it possible to show more than 50K images one by one after selected some specific fields? Also, I don't have any URL to fetch the image.

As you suggest to use ODAG/Dynamic Views, but I need to generate an NPrinting report, so I think it's not feasible in that case.

Thanking you,

Regards,

Anup

apatra87
Contributor III
Contributor III
Author

Hi Pedro,

I have checked with the MGO Grid extension but in NPrinting it's not working. As we know NPrinting only support base64 encoded image may be due to this.

Please suggest.

 

Thanking you,

Regards,

Anup

pedrobergo
Employee
Employee

Hi @apatra87 

Today NP doesn't support ODAG applications, maybe you can use a Pixel Perfect with HTML img src tag to point the url of the image, passed by app dimension, but you'll need to test it. Another suggestion is that you export page as PDF or use some extension  like export button to PDF format. 

[],

Pedro

 

apatra87
Contributor III
Contributor III
Author

Hi Pedro,

In my application, I am creating the NPrinting report through the On Demand button extension in PDF/PPT format.

After using your 'MGO Grid extension' I am able to fetch the image from my GCP source, now it's showing into my QlikSense application but when I am trying to create the report through NPrinting then the Reports are getting generated but the Image sheets are blank. So Into the report not getting those images.

Thank you for your help.

 

Regards,.

Anup