Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Specialist
Specialist

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

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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
Specialist
Specialist

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

Ricardo_Gerhard
Employee
Employee

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.

Ricardo Gerhard
OEM Solution Architect
LATAM
mdmukramali
Specialist III
Specialist III

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

Anonymous
Not applicable
Author

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?

Ricardo_Gerhard
Employee
Employee

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.

Ricardo Gerhard
OEM Solution Architect
LATAM