Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gsmajdor
Contributor

Save as (qvf) via data load script

Hi,

Is there any option to save an app as another qvf file using the data load script?

The purpose is to:

- run load script

- in the load script create a loop

- in each step of the loop:

-->filter the data using WHERE clause i.e. Sector = 'first_sector'

-->save as app_first_sector.qvf

- go to next loop iteration

17 Replies
tomasz_tru
Valued Contributor

Re: Save as (qvf) via data load script

what's the purpose? maybe all you need is on demand app generation (On-demand apps ‒ Qlik Sense)?

if not - it's not possible to save QVF in script loop - only to CSV or QVD - here's my shortcut for doing that the way you need: Subroutines in load script

Re: Save as (qvf) via data load script

You could in each loop save to the data to different qvd files and then create multiple qvf's that load from the appropriate qvd files.

But the best forwards depends on your required end game.  If your needs are actually security, as in for some people to only have access to some data and other people to other data then maybe look at this blog post A Primer on Section Access by HIC.  It is a few years old, but Section Access security is still pretty much the same in the latest Qlik Sense and a search on Section Access will produce loads of hits.

gsmajdor
Contributor

Re: Save as (qvf) via data load script

The purpose is to create 10 copies of the same app. Every single app should have data filtered by 'Sector' (there are 10 sectors)

Re: Save as (qvf) via data load script

May I ask what the required end game is ?

Is this for data security reasons, as in you only want certain people to be able to see certain data ?

Or is there another reason ?

The reason I ask is that the best way forwards depends on the required end game.

tomasz_tru
Valued Contributor

Re: Save as (qvf) via data load script

Section Access is not possible? Is it Desktop or server version?

dcj
Valued Contributor II

Re: Save as (qvf) via data load script

Dear Grzegorz,

   I guess that you want to create a loop and reduce as we have on Qlikview Publisher, creating multiple dashboards, correct?

   This resource is available on Qlikview Publisher and will be moved on to Qlik Nprinting (I believe) that is compatible with Qlik Sense.

Regards.

mdmukramali
Valued Contributor II

Re: Save as (qvf) via data load script

Hi,

why don't you try Section Access?

Instead of Creating and Maintaining 10 Copies of the same application which is not good idea,

like if you want to modify an expression in the chart then you have to modify 10 places same expression.

Thanks,

Mukram

gsmajdor
Contributor

Re: Save as (qvf) via data load script

This sector split is for security reasons - allow users to see only their sector.

My recipients will use QS Desktop to open the qvf file.

Is the 'section access' working on QS Desktop too?

dcj
Valued Contributor II

Re: Save as (qvf) via data load script

Qlik Sense Desktop is for single user only.

Take a look on this article Section access in Qlik Sense

My suggestion is to use variables in order to controle informations or Qlik Sense server.