topic Re: Sending or Viewing QVW across servers in QlikView

Sending or Viewing QVW across servers

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlikies !

Could you possibly throw some light on how to view or send QVW document from one server to another server.

The Current set up in our environment is as follows

The information comes from Linux server and delivered to Other Network server

Requirement:

We have to figure out how to automate and refresh QVW documents within Linux Server and send it to another server for display on large screen tv’s in factories (Multiple Locations)

If possible kindly provide step by step instructions

Thanks,

--Ajay

Re: Sending or Viewing QVW across servers

Anonymous — Mon, 21 Nov 2016 14:14:28 GMT

I am waiting eagerly for a reply from this community.. Please feed me with some inputs as soon as possible

Re: Sending or Viewing QVW across servers

adamdavi3s — Mon, 21 Nov 2016 14:16:56 GMT

Do you have a Qlikview Server License?

The simplest way would be to have a Qlikview Server and a Web Server accessible across your network.

Re: Sending or Viewing QVW across servers

Anonymous — Mon, 21 Nov 2016 14:21:36 GMT

Hello Adam,

Thanks a ton for your swift reply !

Yes we do have Qlikview Server .. you mean create the QVWs the actual dashboard within Linux server and access them via Access Point(Web Interface) on another server?

Re: Sending or Viewing QVW across servers

adamdavi3s — Mon, 21 Nov 2016 14:26:23 GMT

I am not quite sure where your linux server fits in... are you running your Qlikview Server on linux?

But regardless, you can split your web server away from your qlikview server.

We found this a LOT easier to do with Qlikview Web Server rather than IIS.

Our setup is that we have the server running inside our internal network so it is protected, then our web server is in our DMZ (along with a read copy of our active directory for user authentication)

This means that our documents are available online to our remote users, as long as they have proper domain credentials.

I think that is what you are suggesting you want to achieve?

Re: Sending or Viewing QVW across servers

Anonymous — Mon, 21 Nov 2016 14:45:26 GMT

Adam,

Yes Precisely ! The current requirement is we need to capture hourly down time of factory machines on which Data collection Modules are installed and real time data is captured onto Linux Server. We have SQL Server installed on the same server to which we make connection via Qlikview. We develop the Dashboards required for each plant with plant specific data and then need to supply this information to TV display supplier(http://rmgnetworks.com/) which is located on another server. Can this be achieved via Access point with auto refresh and enable story telling feature ?

Thanks in Advance

--Ajay

Re: Sending or Viewing QVW across servers

ramasaisaksoft — Tue, 22 Nov 2016 06:44:19 GMT

Hi Ajay,

As per my Knowledge,

QV server/Desktop doesn't supports Linux .

QlikView 11.2 SR10 System Requirements.pdf

so it is not possible to setup & load qv jobs in Linux environment and share via QV web server/IIS.

So sorry if i understand your query wrongly.

Re: Sending or Viewing QVW across servers

adamdavi3s — Tue, 22 Nov 2016 07:18:19 GMT

I don't think that is the issue in this case

Re: Sending or Viewing QVW across servers

adamdavi3s — Tue, 22 Nov 2016 07:36:34 GMT

Hi Ajay,

I am struggling to understand a little bit where the issue is here as it seems like this is quite normal server setup and deployment, so I apologise if I am talking to simple here....

So you have the data you need in SQL

You already have this Data in a dashboard or dashboards.

Have you put these dashboards in the server yet? If so then you should be able to automate the reloading etc.

Once the dashboards are in the server then you can set reload schedules to refresh the data. This involves making sure your Qlikview Services user has the correct access etc.

From here, the dashboards can be published in the access point. Now access to the access point is usually within your domain, but you can split the web / access point server out (no additional license cost if you have enterprise, not sure about SBE)

Because you can split the web server you can then put it in a DMZ or wherever you want which makes it accessible to your factories over the internet.

Each factory would then just need to log in using a username linked to your document CALS and the information could be presented on the TV (i assume the TV has a web browser or is linked to a PC?).

You can of course configure these dashboards to auto-refresh when the server one is refreshed.

As I said I am not quite sure where the issue lies, obviously if you need some consultancy to help then I would be glad to 😄

However here are a bunch of resources that should help with what I have outlined, sorry if I have totally missed the point though!

Deploying Qlikview: https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Server/Content/QlikView%20Server/Deploying.htm

Splitting off the webserver: https://community.qlik.com/thread/34809 https://community.qlik.com/thread/19697

Re: Sending or Viewing QVW across servers

adamdavi3s — Tue, 22 Nov 2016 07:36:58 GMT

Hi Ajay,

There is a big comment coming but it is being moderated!

Re: Sending or Viewing QVW across servers

Anonymous — Wed, 23 Nov 2016 09:53:25 GMT

Hi Adam,

We have two servers here

One where the data gets captured directly from the DCM(Machines)

Two where these dashboards need to be displayed using RMG Display Screens in the Factory Machines

Now to integrate these dashboards from one server to another without the access point, do we have any other alternatives ? Please Advise and I would really appreciate your guidance on this one

Thanks!

Re: Sending or Viewing QVW across servers

adamdavi3s — Wed, 23 Nov 2016 10:08:49 GMT

Ok so can I assume you're using desktop and not server?

If so I would look to get server!

Re: Sending or Viewing QVW across servers

Anonymous — Wed, 23 Nov 2016 10:23:24 GMT

So If I get a server then can I send QVW across servers? .... even if the other server hasn't got Qlikview server installed ?

Re: Sending or Viewing QVW across servers

adamdavi3s — Wed, 23 Nov 2016 10:54:22 GMT

If you get server then you can publish to the access point and pick up the dashboards on any machine with a web browser. That would be my advice!

Otherwise cant you just have dashboards on the remote machines but load the data via a webservice / api / some other method? Not something I have done I am afraid

Re: Sending or Viewing QVW across servers

stevedark — Wed, 23 Nov 2016 14:41:26 GMT

To have things on TVs you probably don't want to have QlikView apps showing there directly, as each TV would consume a CAL and refreshing them would be a pain.

Two approaches you may want to look at are using NPrinting to reload and distribute your app. Make sure that you get version 16 though, as some of the functionality you will need is missing in 17. Using this you can write dynamic HTML code and all of the images required for an HTML display on your TVs.

Another approach is to write out HTML code in your load script. This can then show text based KPIs on your wall boards. With some macro code you could pull through QlikView charts as well (using some exports on the post reload trigger), but you have more moving parts if you do this.

I've done a blog post on using the STORE statement to create HTML on the fly:

https://www.quickintelligence.co.uk/write-csv-qlikview-store/

I have a wallboard display at a number of clients which looks like the below using this method:

Hope that helps.

Steve