Qlik Community

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF). Providing best practices, libraries and utilities that facilitate the recommended setup and management of QlikView or Qlik Sense environments. An understanding of the Qlik platform is recommended before joining this group. Download QDF and documentation here: https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases

CREATE A POST
Post a Question
  • QDF 1.6.0 support with Sense November 2018

    Dear Group,This week we updated the Qlik Sense server of a client (who is using QDF version 1.6.0) to the November 2018 release.That resulte... Show More

    Dear Group,

    This week we updated the Qlik Sense server of a client (who is using QDF version 1.6.0) to the November 2018 release.
    That resulted in non of the scripts running anymore. There is no crash of the script, it just stops.

    script snippet.PNG

     

     

    On this server there are more than 500 applications and non of them crashed, but non of them had data included as the script just stopped. All on the same location as shown in the image. 

    Does any of you have similar experience or have a clue what the root cause could be?

    We are looking to upgrade QDF to the latest version, but we still need to test-run that upgrade and see if it has impact on our production environment.

    Thank you,

    Roel

    Show Less
  • Count of Growth Label

    Hi,i need to create a Report 2, format which is given in attached excel file.kindly guide,application and data file has been attached.Thanks in advanc... Show More

    Hi,

    i need to create a Report 2, format which is given in attached excel file.

    kindly guide,

    application and data file has been attached.

    Thanks in advance,

    Regards,

    Zain.

    Show Less
  • Getting ICU Conversion error while connecting to DB

    Hi All,Kindly help me how to resolve the below issue.Thanks,SAI
  • Top 10 Records of Each Department

    Hi,Given below statement is working fine when I talking about top 10First 10Load * from abc.csvorder by sal desc; My question is how I do to get Top 1... Show More

    Hi,


    Given below statement is working fine when I talking about top 10

    First 10

    Load * from abc.csv

    order by sal desc;


    My question is how I do to get Top 10 sal by each department (in script level only), suppose if I have 4 departments so I will get 40 records means top 10 records for each department.



    Regards,


    Zain.

    Show Less
  • How to recover corrupted Qlikview document.

    Dear All,Need your help to recover a qlikview document which is corrupted.I have that document and it's .shared and .Meta file.That document shows err... Show More

    Dear All,

    Need your help to recover a qlikview document which is corrupted.

    I have that document and it's .shared and .Meta file.

    That document shows error 'Document failed to open'.

    Your help is highly appriciated.

    Regards,

    Akhilesh

    Show Less
  • Distribute .csv file via NPrinting to ''C:\Users\XX\Desktop''

    Dear expert, I would like to export and a QlikView Pivot table data as .csv format  and distribute via NPrinting to Shared location (Example:C:\U... Show More

    Dear expert,

    I would like to export and a QlikView Pivot table data as .csv format  and distribute via NPrinting to Shared location (Example:C:\Users\XX\Desktop ) 

    in detail- I would like to export QlikView Object- Pivot table data into .csv format after daily reload.

    - we have a N-Printing tool available, does N-printing have a capability to to convert the file and schedule it to shared path(C:\Users\XX\Desktop)

    Please shed some light.

    Show Less
  • Possible to retain single color in bar and have multi color in Line in a combo c...

    Hello All,I am placing a combo chart with single dimension and single expression. There should be bars and lines in it. Client wants the line to have ... Show More

    Hello All,

    I am placing a combo chart with single dimension and single expression. There should be bars and lines in it. Client wants the line to have different color but to retain the bars in mono color scheme. Is such thing is possible in QlikView?

    Kindly suggest!

    Thank you,

    Regards,

    Saimeenakshi S

    Show Less
  • Identify what environment we are

    Hello qlikers,I've a quick question for you laid on the beach! I'm using my QDF scripts in both Qlik Sense and Qlik View. The question is: how do I kn... Show More

    Hello qlikers,

    I've a quick question for you laid on the beach!

    I'm using my QDF scripts in both Qlik Sense and Qlik View. The question is: how do I know, from a script perspective, which environment I am dealing with? This can be useful, for instance, during an automated "LOAD" of QVDs: if you are in QS, to identify the path of the file you have to use "/" while in QV you have to use "\".

    Any idea?

    Thanks a lot and have a nice summer time!

    Brunello

    Show Less
  • Issue with IndexAdd since moving to 1.7.1 [RESOLVED - internal script error]

    Hi allWe've recently updated to 1.7.1 of the QDF and are having some issues with IndexAdd in some of our generators.What's strange is that some files ... Show More

    Hi all

    We've recently updated to 1.7.1 of the QDF and are having some issues with IndexAdd in some of our generators.

    What's strange is that some files work and create indexes in the Shared Folder, whereas a number of them don't and are throwing errors with this part of the indexing: Call DoDir ('[Folder]\[File].qvd', '_tmp_DoDir','','','true')

    Anyone else having any problems, or can offer any help?

    Thanks

    Ian

    We've tested by reverting to the 5.DoDir.qvs and 12.Index.qvs from 1.6.0 and they create the index file successfully, so something is awry with the 1.7.1 version of these files.

    Show Less
  • LCGV function not working

    HelloI'm using the version 1.7.1 of the QDFI'm trying to link / mount containersin my script I put the following code:/*QDF initiation script*/set vG.... Show More

    Hello

    I'm using the version 1.7.1 of the QDF

    I'm trying to link / mount containers

    in my script I put the following code:

    /*

    QDF initiation script

    */

    set vG.BasePath=; //Clrear cache

    set vG.SharedBasePath=; //Clrear cache

    SET vG.RootContainer='lib://QDF_ROOT/';

    SET vG.HomeContainer='lib://QDF_ROOT/3.Customer_Case_Analysis/';

    $(Include=lib://QDF_ROOT/InitLink.qvs);

    /*****************************************************************/

    /*

    we need to read QVD files from the QVD Generator resource

    and mainly from the Transform folder of the QVDs

    */

    call LCGV('QVDGEN','QVD');

    /*****************************************************************/?

    However I get the following warning: (check attached image)

    kindly advise as I'm stuck and don't know a work around this issue

    Ali M. Hijazi - BI Solution Architect

    ali.hijazi@setelia.com<mailto:Jean.Aboujaoude@setelia.com>

    Mobile : +961 03 197337- Tel: +33 (0)1 55 43 26 01 - 961 (5) 955 417- Fax: + 33 (0)1 55 43 26 10

    This message and any attachments are confidential. If you are not the intended recipient or his authorized agent, please be advised that copying, distributing or revealing the contents of this message is expressly prohibited. If you are not the intended recipient, kindly notify the sender immediately by return e-mail and delete this message from your system.

    Show Less
  • link with available containers

    Hello I'm working on Qlik SenseI'm using QDF and I have the containers defined below:I created a new app and I put the below script:/* QDF initiation ... Show More

    Hello I'm working on Qlik Sense

    I'm using QDF and I have the containers defined below:C838D138.PNG

    I created a new app and I put the below script:

    /*

    QDF initiation script

    */   

    set vG.BasePath=;  //Clrear cache

    set vG.SharedBasePath=; //Clrear cache

    SET vG.RootContainer='lib://QDF_ROOT/';

    SET vG.HomeContainer='lib://QDF_ROOT/3.Customer_Case_Analysis/';

    $(Include=lib://QDF_ROOT/InitLink.qvs);

    /*****************************************************************/



    /*

    we need to read QVD files from the QVD Generator container

        and mainly from the Transform folder of the QVDs

    */

    call LCGV('QVDGEN','QVD');

    /*****************************************************************/

    when I reload I get the following warning:

    Capture.PNG

    and so the variables that hold the QVD path for the QVDGEN container are not created
    kindly advise

    dwambg

    Show Less
  • How to reference script defined in Custom folder

    Helloin one of containers I've created a QVS file and named it 1.MyCompanyNamein this file I created a sub called myCompanyName.LookUpnow I'm working ... Show More

    Hello

    in one of containers I've created a QVS file and named it 1.MyCompanyName
    in this file I created a sub called myCompanyName.LookUp

    now I'm working on a Qlik Sense dashboard
    I initiated the framework as follows:

    SET vG.RootContainer='lib://QDF_ROOT/';

    SET vG.HomeContainer='lib://QDF_ROOT/2.QVD_Generator/';

    $(Include=lib://QDF_ROOT/InitLink.qvs);

    and I got all variables starting with vG

    for now everything is fine

    now if I want to call the myCompanyName.Looup do I need to explicity include the 1.MyCompanyName.qvs or should the InitLink.qvs references the file by default?
    kindly advise as now when I call my custom function I get an error when I reload the dashboard

    Regards,

    Show Less
  • hello, how can i apply the ETL process with qlik sense ?

    hello, how can i apply the ETL process with qlik sense ?
  • Endless Bubbles in Hub

    We have sporadically the effect, that the user can enter the hub and sees all the correct apps, but whenever he tries to open an app the Qlik loading ... Show More

    We have sporadically the effect, that the user can enter the hub and sees all the correct apps, but whenever he tries to open an app the Qlik loading bubbles appear and stay no matter how long he waits.
    To make things worse, this bug can't be detected in the QMC, so we only notice it's occurrence when the users complain that Qlik isn't working.

    This has happend on our Single-Server System as well as on on our 4-Server System with one central, two Reload and one Display Node.
    The only way to remove the Bug ist to reboot the Display-Node-Server or on the Single-Server-System the whole system.

    We are currently trying to find a html-query to detect when the error occurs to initiate an automatic Server reboot. While this would help us reduce the downtime for the Users, it still doesn't solve the actual Problem.

    Any tips or ideas would be highly appreciated.

    Show Less
  • call LCGV('Shared')

    Hello I'm new to QDF and I'm using it in Qlik Sensein the script editor I'm putting the  following script:call LCGV('Shared');However I get the f... Show More

    Hello I'm new to QDF and I'm using it in Qlik Sense

    in the script editor I'm putting the  following script:

    call LCGV('Shared');

    However I get the following warning and the vG.Sharedxxx variables are not created:

    warning.PNG

    kindly advise

    Show Less
  • new to QDF

    Hello I'm new to QDFI'm using Qlik SenseI created a container called QVGENin Qlik Sense I created a new folder connection named QDF_ROOT pointing to t... Show More

    Hello I'm new to QDF

    I'm using Qlik Sense

    I created a container called QVGEN

    in Qlik Sense I created a new folder connection named QDF_ROOT pointing to the folder where the containers reside

    following is my script:

    script.PNG

    when I run the script I get the following warning messages:

    error.PNG

    kindly advise on how to solve this issue

    Message was edited by: Ali Hijazi

    Show Less
  • QDF for Sense

    HelloI've just started reading about QDF and all PDF files are QlikView-Oriented (file-based)However in Sense we work on the server - I mean we open t... Show More

    Hello
    I've just started reading about QDF and all PDF files are QlikView-Oriented (file-based)

    However in Sense we work on the server - I mean we open the hub via browser and in sense connection strings for example are not saved in file system

    How can we benefit from QDF in Qlik Sense

    Kindly advise

    Show Less
  • Need Example file QVF with QDF Functionality

    Hi Team,Could some one share me example QVF Files. With QDF functionality The should contains few QDF Functions and Load Statements Thanks,Siva
  • How to deal with txt file data

    Hi All,I have hundreds of text file with a format like belowPurge (Yes/No):            &nb... Show More

    Hi All,

    I have hundreds of text file with a format like below

    Purge (Yes/No):                             yes

    Day Count to Retain (INT):        180

    Purge Limit (INT):                          3

    Days Deleted:                                 3

    Export Data to file (Yes/no):     no

    Export Path (CHAR):                     D:\Index\auditExportDir

    E-mail Confirmation (Yes/No): yes

    E-mail Address(char):                  support@support.ie

    Audit Records Deleted:              33960

    Duration:                                          00:02:32

    What is the best way to read this data, use RowNo() or RecNo()

    Thanks

    Show Less
  • Upgrading to QlikView 12.20 SR1 (November 2017 SR1)

      Hi All,  Good news so far....I have successfully upgraded from QlikView 11.20 SR17 to QlikView 12.20 SR1.  Step 1. Document and scree... Show More

     

    Hi All,

     

    Good news so far....I have successfully upgraded from QlikView 11.20 SR17 to QlikView 12.20 SR1.

     

    Step 1. Document and screen capture all the configuration screens.

     

    Step 2. Backup all the *.pgo files and note all the locations. [Example: C:\ProgramData\QlikTech\QlikViewServer & G:\ProgramData\QlikTech\Documents (Access point)]

     

    Step 3. Backup your copy of Settings.ini file.

     

    Step 4. Renew your LEF file and copy it to your notes. (My Server can not talk to the internet hence to authenticate QlikView License I would need to manually enter the license information. ** Make sure your service contract is up to date before proceeding to upgrade**

     

    Step 5. Uninstall the older version of QlikView from control panel.

     

    Step 6. Install the new version of QlikView.

     

    Step 7. Reboot your Server.

     

    Step 8. Validate your license. (Enter license information and Apply)

     

    Step 9. After reboot check all QlikView Services are running.

     

    Step 10. New version of QlikView should be using all the setting from settings.ini file. No need to reconfigure the Server. Unless you wish to.

     

    No change to OS. Still running Windows 2008 R2. Next year planning to move Microsoft Server 2016.

     

    One bug I noticed is that you can not double click on " *.qvw “or” *.qvd ". It throws a licencing error message when you try to use a personal copy of developer. Even though I am leasing a license from the enterprise server.

     

    In the new version you have to all ways open QlikView Desktop and point to qvw or qvd file.

     

    Please notify me if there is a fix or work around for this issue.

     

     

    QlikView 12.20 SR1 performance is fast and better performance when it comes to QlikView 11.20 SR 17.

     

     

    Cheers and Good Luck to you all.

     

     

    Message was edited by: Arish Selvadurai

    Show Less
Group details
Qlik Deployment Framework
Qlik Deployment Framework
2,703 members Open Group Since ‎11-07-2013 06:20 PM
This group hosts information related to the Qlik Deployment Framework (QDF). Providing best practices, libraries and utilities that facilitate the recommended setup and management of QlikView or Qlik Sense environments. An understanding of the Qlik platform is recommended before joining this group. Download QDF and documentation here: https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases
This group hosts information related to the Qlik Deployment Framework (QDF). Providing best practices, libraries and utilities that facilitate the recommended setup and management of QlikView or Qlik Sense environments. An understanding of the Qlik platform is recommended before joining this group. Download QDF and documentation here: https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases
Group Admin
Magnus_Berg Employee
Michael_Tarallo Employee
Damian_Waldron Employee
Members (2,703)