Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,745 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

Discussion Boards and Documents for Qlik Services.

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success Blog!

Learn about upcoming Qlik related events, webinars and local meetups.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Recent Discussions

  • QlikView Connectors

    Error: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server.

    Hiya,I am trying to use a REST connector and am able to bring back data when reloading manually. However, when reloading on the server I get the follo... Show More

    Hiya,

    I am trying to use a REST connector and am able to bring back data when reloading manually. However, when reloading on the server I get the following error message:

    Error: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server.

    I have ran the script on the server without bringing the data back and just the connection string and it reloads fine with no errors.

    I have tried with and without authentication, skipping server certificate validation and it still fails on the server.

    Do I need to do anything server side to allow for REST connections?

    Does anyone have any ideas on what I might be doing wrong?

    TIA.

     

     

    Full error log:

    2019-03-11 11:27:40      Execution started.
    2019-03-11 11:27:40      QVB Version                   12.20.20900+2018-11-27 14:46:56+566945a
    2019-03-11 11:27:40      CPU Target                    x64
    2019-03-11 11:27:40      Operating System              Windows Server 2012 R2 Standard  (64 bit edition)
    2019-03-11 11:27:40      Wow64 mode                    Not using Wow64
    2019-03-11 11:27:40      Language                      0809 English (United Kingdom) English
    2019-03-11 11:27:40      Country                       44 United Kingdom United Kingdom
    2019-03-11 11:27:40      MDAC Version                  6.3.9600.16384
    2019-03-11 11:27:40      MDAC Full Install Version     6.3.9600.16384
    2019-03-11 11:27:40      PreferredCompression          2
    2019-03-11 11:27:40      EnableParallelReload          1
    2019-03-11 11:27:40      ParallelizeQvdLoads           1
    2019-03-11 11:27:40      AutoSaveAfterReload           0
    2019-03-11 11:27:40      BackupBeforeReload            0
    2019-03-11 11:27:40      EnableFlushLog                0
    2019-03-11 11:27:40      SaveInfoWhenSavingFile        0
    2019-03-11 11:27:40      UserLogfileCharset            65001
    2019-03-11 11:27:40      OdbcLoginTimeout              -1
    2019-03-11 11:27:40      OdbcConnectionTimeout         -1
    2019-03-11 11:27:40      LongestPossibleLine           1048576
    2019-03-11 11:27:40      MaxCoreMask                   -1
    2019-03-11 11:27:40      ScriptWantsDbWrite            false
    2019-03-11 11:27:40      ScriptWantsExe                false
    2019-03-11 11:27:40      LogFile CodePage Used:        65001
    2019-03-11 11:27:40      UseMemoryFillPattern          1
    2019-03-11 11:27:40      ScriptMode                    Legacy (gives greater system access) (aka qv11 mode)
    2019-03-11 11:27:40      SequentialThreadCount         16
    2019-03-11 11:27:40      NumberOfCores (effective)     4
    2019-03-11 11:27:40      ReloadCodebase                Bnf
    2019-03-11 11:27:40      Reload Executed By            KMBC\qlik
    2019-03-11 11:27:40      Process Executing             QVB
    2019-03-11 11:27:40      Process ID                    3208
    2019-03-11 11:27:40 0002 SET ThousandSep=','
    2019-03-11 11:27:40 0003 SET DecimalSep='.'
    2019-03-11 11:27:40 0004 SET MoneyThousandSep=','
    2019-03-11 11:27:40 0005 SET MoneyDecimalSep='.'
    2019-03-11 11:27:40 0006 SET MoneyFormat='£#,##0.00;-£#,##0.00'
    2019-03-11 11:27:40 0007 SET TimeFormat='hh:mm:ss'
    2019-03-11 11:27:40 0008 SET DateFormat='DD/MM/YYYY'
    2019-03-11 11:27:40 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'
    2019-03-11 11:27:40 0010 SET FirstWeekDay=0
    2019-03-11 11:27:40 0011 SET BrokenWeeks=0
    2019-03-11 11:27:40 0012 SET ReferenceDay=4
    2019-03-11 11:27:40 0013 SET FirstMonthOfYear=1
    2019-03-11 11:27:40 0014 SET CollationLocale='en-GB'
    2019-03-11 11:27:40 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
    2019-03-11 11:27:40 0016 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'
    2019-03-11 11:27:40 0017 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
    2019-03-11 11:27:40 0018 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'
    2019-03-11 11:27:40 0020 CUSTOM CONNECT TO ***
    2019-03-11 11:28:02 0022 RestConnectorMasterTable:
    2019-03-11 11:28:02 0023 SQL SELECT
    2019-03-11 11:28:02 0024  "PreferredMethodOfContact",
    2019-03-11 11:28:02 0025  "RequestType",
    2019-03-11 11:28:02 0026  "AreaType",
    2019-03-11 11:28:02 0027  "Title",
    2019-03-11 11:28:02 0028  "FirstName",
    2019-03-11 11:28:02 0029  "Surname",
    2019-03-11 11:28:02 0030  "PhoneNumber",
    2019-03-11 11:28:02 0031  "__KEY_root"
    2019-03-11 11:28:02 0032 FROM JSON (wrap on) "root" PK "__KEY_root"
    2019-03-11 11:28:44       9 fields found: PreferredMethodOfContact, RequestType, AreaType, Title, FirstName, Surname, PhoneNumber, __KEY_root, __extra_,
    2019-03-11 11:28:44      Error: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server.
    2019-03-11 11:28:44      Execution Failed
    2019-03-11 11:28:44      Execution finished.

    Show Less
  • New to Qlik Sense

    Finding Sum on Rows and Column based on condition

    I have a data as below.I have to find the total as below.Please let me know anyone, is this possible in qlik sense? If possible, how to do this? Thank... Show More

    I have a data as below.

    Pic1.PNG

    I have to find the total as below.

    Pic2.PNG

    Please let me know anyone, is this possible in qlik sense? If possible, how to do this?

     

    Thanks.

    Show Less
  • New to Qlik Sense

    How to store the data of t-1 and t-2 day in QlikSense

    Hello Everyone,I want to store the data in one .qvd of previous day and one .qvd of previous to previous day on today's day. For e.g 20-02-20: Store t... Show More

    Hello Everyone,

    I want to store the data in one .qvd of previous day and one .qvd of previous to previous day on today's day.

     

    For e.g 

    20-02-20: Store the data for 19-02-20. This is done

    20-02-20 : The other qvd should store the data for 18-02-20. How to do it?

     

    Regards,

    Kavita

     

     

    Show Less
  • Qlik Data Catalyst Discussions

    Publish to QS Issues

    Hi,Trying to get this working, but I am stuck...and hopeful this community of experts might be able to point me in the right direction!I went through ... Show More

    Hi,

    Trying to get this working, but I am stuck...and hopeful this community of experts might be able to point me in the right direction!

    I went through the steps to setup this feature (in the pdf) and get the Publish option from the cart, but getting some errors:

    If I choose publish to Qlik Sense I get the following:

    "2020-02-16 11:57:34.269: Task OnDemandQSEntityPromotionTask failed: PodiumFault: core.error.code.USER_CANNOT_PROMOTE_ENTITY_FOR_PUBLISH - Selected entity is not in a managed state and doesn't carry any data. The user requested the publish cannot promote entity to Managed."

     

    If I choose publish advanced I get:

    "There was an error fetching the app list"

     

    I would appreciate any guidance!

    thanks,

    DD

    Show Less
  • New to Qlik Sense

    Custom theme - change color of grid lines in bar chart

    Hi, I am making a custom theme and have figured out how to change the colors I want, except for the grid lines.I am using an example file. In Qlik Sen... Show More

    Hi, I am making a custom theme and have figured out how to change the colors I want, except for the grid lines.

    I am using an example file. In Qlik Sense standard theme, the grid lines are light grey, in my example file black. Does anyone know what object / property to change?

    custom.JPGcustom2.JPG

     

     

     

    Show Less
  • QlikView Scripting

    Issue with the date comparison for qlikview incremental load

    Hi All, We are applying an incremental load. Whenever we are trying to compare dates we are getting an error like,ODBC errorConnector reply error: SQL... Show More

    Hi All,

     

    We are applying an incremental load. Whenever we are trying to compare dates we are getting an error like,

    ODBC error

    Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1843, ErrorMsg: [Oracle][ODBC][Ora]ORA-01843: not a valid month

    I have attached the sample file for your reference.

    I am not getting how to go ahead with the comparison for dates.

    Please suggest.

    Thanks in advance.

    Thanks

    Show Less
  • QlikView Scripting

    Last updated Price for all Products based on date selection

    Hi Team,Please help me on achieving this logicI want to show Product & Last updated Price in Straight table based on date selection in listbox.Data Ta... Show More

    Hi Team,

    Please help me on achieving this logic

    I want to show Product & Last updated Price in Straight table based on date selection in listbox.

    Data Table:

    ProductDatePrice
    Samsung01/01/202015000
    Apple02/01/202045000
    Nokia03/01/20208000
    Motorola04/01/202011000
    Samsung11/01/202017000
    Apple12/01/202047000
    Nokia13/01/20209000
    Motorola14/01/202011500
    Samsung20/01/202019000
    Apple21/01/202043000
    Nokia22/01/20207500
    Motorola23/01/202012000

     

    I have tried with Firstsortedvalue,by default it is showing Lastupdatedprice Product wise But i want to show LastupdatedPrice for Selecteddate.

    Product=FirstSortedValue(Price,-Date)
      
    Samsung19000
    Apple43000
    Nokia7500
    Motorola12000

    I have generated missing dates with master calender and tried to populate missing Product & Price using Peek function But its nor working..

    ProductDatePrice
    Samsung01/01/202015000
    Apple02/01/202045000
    Nokia03/01/20208000
    Motorola04/01/202011000
     05/01/2020 
     06/01/2020 
     07/01/2020 
     08/01/2020 
     09/01/2020 
     10/01/2020 
    Samsung11/01/202017000
    Apple12/01/202047000
    Nokia13/01/20209000
    Motorola14/01/202011500
     15/01/2020 
     16/01/2020 
     17/01/2020 
     18/01/2020 
     19/01/2020 
    Samsung20/01/202019000
    Apple21/01/202043000
    Nokia22/01/20207500
    Motorola23/01/202012000

     

    Show Less
  • New to Qlik Sense

    SQL query into Expression

    Hi All,I want to convert the below SQL statement into Expression.SELECT Round(([SumOfGrossValue_LC]-[SumOfCOGS_LC])/[SumOfGrossValue_LC],2) AS Expr1FR... Show More

    Hi All,

    I want to convert the below SQL statement into Expression.

    SELECT Round(([SumOfGrossValue_LC]-[SumOfCOGS_LC])/[SumOfGrossValue_LC],2) AS Expr1
    FROM (SELECT Sum(Invoice.GrossValue_LC) AS SumOfGrossValue_LC, Sum(Invoice.COGS_LC) AS SumOfCOGS_LC, PH9.PH6, Invoice.BillingYear
    FROM (Invoice INNER JOIN Material ON Invoice.MaterialNr = Material.MaterialNr)
    INNER JOIN PH9 ON Material.PH9 = PH9.PH9
    GROUP BY PH9.PH6, Invoice.BillingYear
    HAVING (((PH9.PH6)='" & PH & "' ) AND ((Invoice.BillingYear)='" & year & "'))) AS ord1
    GROUP BY Round(([SumOfGrossValue_LC]-[SumOfCOGS_LC])/[SumOfGrossValue_LC],2);

     

    I'm using a filter for the Billing Year.

    What ever the user selects year from the UI that value should come in "invoice.BillingYear" like wise for PH6 also

    How can I achieve it??

    Show Less
  • New to Qlik Sense

    Drill down name as a dimension

    I m using a drill down in my table as a dimension and the dimension is named.However in my table, I can see the first field that makes up the drilldow... Show More

    I m using a drill down in my table as a dimension and the dimension is named.

    However in my table, I can see the first field that makes up the drilldown instead of the drilldown name itself.

    can someone tell me how to solve this

    qlik key.PNG

    Show Less
  • Qlik NPrinting Discussions

    add filters in cascade from Import Task

    Hello,I have this Excel File for Import Recipients Task.Can I set the same Filter Name in more rows and add these in cascade?In this case the name "F ... Show More

    Hello,

    I have this Excel File for Import Recipients Task.

    Can I set the same Filter Name in more rows and add these in cascade?

    In this case the name "F - NPrinting Filtri Dinamici" will have the Filter [Campo]={Valore1,Valore2,Valore3,Valore4}

    nprintingfilter.PNG

     

    Thanks

    Riccardo

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Qlik World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by February 29th to save $200.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Insider: What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

February 26, 2020