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
  • How to create Holiday Calendar Script in Qlik Deployment Framework?

    Hi All,As a hospitality planner I need to analyze trends across many time dimensions days, weeks, months, quarters, years, and previous periods. Holid... Show More

    Hi All,

    As a hospitality planner I need to analyze trends across many time dimensions days, weeks, months, quarters, years, and previous periods. Holidays are very important to our business, so we need to track holiday trends year over year regardless of fluctuations in calendar date


    Thanks,

    Siva

    Show Less
  • show dimension values based on condition

    Hi All,  Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL&... Show More

    Hi All,

      Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL  otherwise it should show selected country.

    countrySales
    ALL40
    IND20
    USA10
    UK10
    Show Less
  • show dimension values based on condition

    Hi All,  Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL&... Show More

    Hi All,

      Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL  otherwise it should show selected country.

    countrySales
    ALL40
    IND20
    USA10
    UK10
    Show Less
  • show dimension values based on condition

    Hi All,  Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL&... Show More

    Hi All,

      Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL  otherwise it should show selected country.

    countrySales
    ALL40
    IND20
    USA10
    UK10
    Show Less
  • FABS not Working in Text Object

    Hi All,I can use FABS function in a straight table, however when I use it in a text object it does not return the correct result.FABS(SUM({<TaskId ... Show More

    Hi All,

    I can use FABS function in a straight table, however when I use it in a text object it does not return the correct result.

    FABS(SUM({<TaskId = {'*ADJUST*'}>}[#Act-Second]))

    Any ideas why it aint correct in the text object but its ok in the table, should I be removing the null values.

    Regards

    Alan

    Show Less
  • How to create Holiday Calendar Script in Qlik Deployment Framework?

    Hi All,As a hospitality planner I need to analyze trends across many time dimensions days, weeks, months, quarters, years, and previous periods. Holid... Show More

    Hi All,

    As a hospitality planner I need to analyze trends across many time dimensions days, weeks, months, quarters, years, and previous periods. Holidays are very important to our business, so we need to track holiday trends year over year regardless of fluctuations in calendar date


    Thanks,

    Siva

    Show Less
  • RestAPI connection Qliksense

    Hello All,We have a requirement where I need to connect to a python web service(restapi) from qliksense and download the data which will be in json fo... Show More

    Hello All,

    We have a requirement where I need to connect to a python web service(restapi) from qliksense and download the data which will be in json format.

    This web service is expecting the username and password to be embedded in the below format.

    curl -H "Content-Type: application/json" -X GET -d '{"username":"postgres","password":"postgres123"}' http://localhost:5000/Table1

    where Table1 is the name of the table. Could you please let me know how qliksense is sending a POST/GET request to a web service when username and password are provided.

    I would like to know how the username and password are embedded in the request so that I can make changes in the webservice and extract the username/password.

    Thanks!

    Show Less
  • QlikView logs are generated after the task is finished

    Hello All,Our qlikview documents logs are saved on the disk when the documents finishes its load and not written during the process of its execution.P... Show More

    Hello All,

    Our qlikview documents logs are saved on the disk when the documents finishes its load and not written during the process of its execution.

    Please help me know, how do i change the settings, so that the documents logs are written as the script execution progresses.

    Show Less
  • Deployment Process in Qliksense Step by Step

    Can you please share deployment process in Qliksense
  • QDF: Shared container paths -- problem when copying from Development to Test/Pro...

    Hey everyone!I recently deployed an app into the QDF and created a three layered Dev-Test-Prod environment for it. Upon making some adjustments to the... Show More

    Hey everyone!

    I recently deployed an app into the QDF and created a three layered Dev-Test-Prod environment for it. Upon making some adjustments to the Development app, I copied it to the two other locations. When I did so, all paths (vG.*) were correctly changed except the Shared paths, which remained with its reference to the Development folder.

    As shown in the variable overview within the Production app, for instance:

    ...\1.Production\3000.Reports\1.Reports\

    ...3.Development\99.shared_folders\

    I thought the inclusion of the InitLink.qvs file was supposed to make sure that this did not happen. Now I must call the LCGV subroutine in the Test and Production locations in order to correctly name all the Shared paths.

    Has this happened to any of you? Any ideas why it might happen?

    By the way, I'm using QlikView, as some might have guessed already.

    Thanks in advance.

    Show Less
  • Qlik Sense - Default value selection from Filter pane without Set analysis

    Hi Guys,Is there a possibility to set default value in filter pane or any other method?We got a date selection to be set for "Current Year" by default... Show More

    Hi Guys,

    Is there a possibility to set default value in filter pane or any other method?

    We got a date selection to be set for "Current Year" by default.

    Because of multiple complex calculations, we could not implement set analysis. We learned that we can possibly set the default values through set analysis. However, in our scenario, we have to go with writing If Else statements. So setting the default value has become a challenge.

    Please suggest any thoughts that you may have.

    Show Less
  • Import app from another QS Cluster

    I exported an app from a Qlik Sense Cluster and tried to import it into another cluster which has the following setup:- Qlik Sense Sep 2017 Release- R... Show More

    I exported an app from a Qlik Sense Cluster and tried to import it into another cluster which has the following setup:

    - Qlik Sense Sep 2017 Release

    - Repository DB Machine

    - Central Node

    - Engine Node 2

    When I attempt to import the app, I get the following error (picked up from the logs at C:\ProgramData\Qlik\Sense\Log\Repository\System\<host_name>_Service_Repository.txt)

    SeverityERROR
    DescriptionCommand=Import app;Result=500;ResultText=Error: IO
    ServiceRepository
    OriginManagementAccess
    Context/qrs/app/upload
    CommandImport app
    Result500
    Message The network name cannot be found.↵↓ (HTTP code: 500)

    I would appreciate any suggestions on how to fix this issue.

    I couldn't find much in the way of help in Qlik Documentation.

    Thanks

    Show Less
  • How to convert multiple date format to single date format in single field

    Hi All,I have some date field data. i need to convert all date in same format.   DateRequire Date5-Jan-16 05/01/201624-Aug-1624/08/201626-A... Show More

    Hi All,

    I have some date field data. i need to convert all date in same format.

      

    DateRequire Date
    5-Jan-16 05/01/2016
    24-Aug-1624/08/2016
    26-Aug-1626/08/2016
    Jul 15-16  201616/07/2016
    31-Mar-1631/03/2016
    Aug 28-29 201629/08/2016
    Show Less
  • how to count no of files in qliksense which i am loading in script ..

    I am developing an app for File validation which i am getting from source .Validation required :- Column name check file name check sheet name check i... Show More

    I am developing an app for File validation which i am getting from source .

    Validation required :-

    Column name check

    file name check

    sheet name check

    i want to display result like if am loading 10 files in that 8 got successfully validated and 2 got failed, it should show result like 8 out of 10 successful  .

    Show Less
  • How to create field based on other field

    Hi All,I have some data. I need to create field 'Home Away' based on 'Ground' Field .if Ground out of India it will be Away otherwise Home in script.&... Show More

    Hi All,

    I have some data. I need to create field 'Home Away' based on 'Ground' Field .

    if Ground out of India it will be Away otherwise Home in script.

     

    GroundHome Away
    MelbourneAway
    ManchesterAway
    Lord'sAway
    BengaluruHome
    DelhiHome

    Please any one help me.

    Show Less
  • how to fix multiple dates in one entry

    Hi All,I have some Date filed like..."Jul 15-16 2017""Jun 16-18 2017"Client want to show this data like..."Jul 16 2017""Jun 18 2017"Please help me on ... Show More

    Hi All,

    I have some Date filed like...

    "Jul 15-16 2017"

    "Jun 16-18 2017"

    Client want to show this data like...

    "Jul 16 2017"

    "Jun 18 2017"

    Please help me on this scenario

    Show Less
  • issue in IF statement in expr

    Hi all,This is my if statement condition--> =If((ORDER_STAT=11 OR ORDER_STAT=12),Num(Count(DISTINCT(ORDER_NUM)))) The expression has no errors. but... Show More

    Hi all,

    This is my if statement condition--> =If((ORDER_STAT=11 OR ORDER_STAT=12),Num(Count(DISTINCT(ORDER_NUM))))

    The expression has no errors. but my chart is not showing anything. Only this part is working: Num(Count(DISTINCT(ORDER_NUM)))

    Could anyone help me identify what is that I am missing?

    Thank you!

    Regards,

    Sai

    Show Less
  • I can able to get the current selection data from Qlik sense mashup,but i need t...

    I can able to get the current selection dimension values using mashup in Qliksense,but i want to get the another dimension field values for current se... Show More

    I can able to get the current selection dimension values using mashup in Qliksense,but i want to get the another dimension field values for current selected dimension.


    Eg: if i select country ID in will get the country values in current selection box.


    I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.I can able to get the current selection data from Qlik sense mashup,but i need the another dimension field values from the Current selected dimension.
    Show Less
  • First Value in the table

    Hi All,in the below table, i need to capture the first value of the price for every model and month_year in a new field. (need in script level)For Exa... Show More

    Hi All,

    in the below table, i need to capture the first value of the price for every model and month_year in a new field. (need in script level)

    For Example:

    for a model , if we have price for july2017 then we consider that price . if  july2017 has no price then we capture the price for aug2017  and so on ..

    Table.JPG

    Show Less
  • Ensures only good quality applications to your environments

    Join our Qlik quality control webinar to understand how WIP ensures only good quality applications pass through your environments. The QlikView and Ql... Show More

    Join our Qlik quality control webinar to understand how WIP ensures only good quality applications pass through your environments. The QlikView and Qlik Sense integrated complexity and environment analysis checklists not only ensures that developers are aware of the complexity of their applications but enables administrator users to implement proper quality control into their environments.

    Please register for our Qlik Quality Assurance Webinar
    Date: 18 April 2018

    Time:

    Europe Time: 16:00 PM (CET)
    South Africa Time: 17:00 PM (SAST)
    USA Eastern Time: 11:00 AM (GMT -4)
    USA Central Time: 10:00 AM (GMT -5)
    USA Pacific Time: 8:00 AM (GMT -6)

    Ensuring quality control across all you QlikView and Qlik Sense Environments

    Please visit our site at www.ebiexperts.com

    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)