topic Re: How do I get data from my web environment through an iframe into qlik sheet? in App Development

How do I get data from my web environment through an iframe into qlik sheet?

mchrenka — Thu, 28 Sep 2023 17:15:52 GMT

In Embedding analytics onto our site using iframes.....I need to be able to pass a piece of data such as a company id from my web environment into qlik so that I can use that piece of data in set analysis. i.e. The report values might be different for different people viewing the same worksheet depending on which company id is logged into our site.

I figured out how to pass in values as selections which is a bit hacky and also breaks when the suer clears the filters.

Surely there is a way to get something like an "id" into an iframe to be used in a variable or some other way?

Any solutions?

Re: How do I get data from my web environment through an iframe into qlik sheet?

rwunderlich — Sat, 30 Sep 2023 17:11:38 GMT

You could make that selection against a field with "Always one selected" set and then it would not clear when the user cleared selections. Make it a hidden field so it doesn't show up in the current selections.

Another idea would be to add the value as a query parm to the url like

?companyId=123

Then you would need to write a small extension that read the companyId from window.location and saved the value in a qlik variable for use in expressions.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: How do I get data from my web environment through an iframe into qlik sheet?

mchrenka — Mon, 02 Oct 2023 18:40:33 GMT

Great Tips!

I got this working as a "Visualization" extension but from what I can tell I need to actually drag the visualization onto the sheet which takes up real estate.

Do you know of a way to make this an app (or sheet) wide extension without needing to add a chart visualization to the sheet?