Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,676 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

  • New to QlikView

    Carry data along with date

    Hi All,I have to create a line chart of my count of  ID's by weekstart. Now my requirement is like :I need to show all the tickets which were opened i... Show More

    Hi All,

    I have to create a line chart of my count of  ID's by weekstart. 

    Now my requirement is like :

    I need to show all the tickets which were opened in past till current weekstart date for example :

    ID-1lowNov/22/2019
    ID-2MediumFeb/9/2020
    ID-3MediumFeb/9/2020

     

    If you look in the above table I have ID-1 for Low  on  date 22nd-Nov-2019

    when i covert the date to weekstart  (I have Master Calendar) then the Dimension would be Weekstart and expression is count(ID) by doing this when the line chart shows only the dot for Feb-09-2019 . 

    What i want is to show is that , the count of (ID)which is one (on Feb-09-2019 )  should keep showing 1 count  till current weekstart which is 17th Feb-2020. ( if theer is no data for any of the weekstart then the line chart should show the previous data . 

    How do i achive this ? can someone please hep me on this 

    thanks in dvance 

    Show Less
  • New to Qlik Sense

    Need to calculate the Avg of another calculation

    I am running into a problem with my expression. This is ultimately what I want:  I am trying to subtract any paused time from the total time and then ... Show More

    I am running into a problem with my expression.

    This is ultimately what I want:  I am trying to subtract any paused time from the total time and then get an average for the dimension type.

    Avg(Interval(rejejctedtimestamp - submittedtimestamp,'hh')) - Sum(PausedTime))

    It will not allow me to nest the functions. I can remove the Sum from PausedTime and I don't get the error.  But it doesn't work correctly.

    Not sure what my options are here?

    Show Less
  • QlikWorld Discussions

    YEARFRAC Function In qlik

    Hi Team,In Excel we have function called YEARFRAC , is there a same function in Qlik.Start DateMaturity dateYearFrac2020-02-042020-08-0449.73%2020-02-... Show More

    Hi Team,

    In Excel we have function called YEARFRAC , is there a same function in Qlik.

    Start DateMaturity dateYearFrac
    2020-02-042020-08-0449.73%
    2020-02-042021-02-04100.00%
    2020-02-042023-02-04300.07%
    2020-02-042025-02-05500.36%

     

    Thanks,

    Gowtham

    Show Less
  • Qlik NPrinting Discussions

    Failed to send e-mail message with error message "No such host is known"

    Hi Techies,Suddenly we are receiving error messages in Task Execution log:I have checked the logs and below message is there for multiple users ERROR ... Show More

    Hi Techies,

    Suddenly we are receiving error messages in Task Execution log:

    I have checked the logs and below message is there for multiple users 

    ERROR  QLKNPRNT  0 0 0 0 0 0 0 0 Failed to send e-mail message to xxxxxxxx@xxxxx.com. ERROR: System.Net.Sockets.SocketException (0x80004005): No such host is known↓↓ at System.Net.Dns.GetAddrInfo(String name)↓↓

    It has started from last week and occurs randomly.

    Can anyone help us to fix it ?

     

    Thanks,
    Rohit

    Show Less
  • Qlik Sense SaaS & Multi-Cloud

    Change Qlik Sense Cloud account manager or owner

    I am facing a number of problems, now with the impending discontinuity of Qlik Sense Desktop.I created the qlikcloud environment for the company, howe... Show More

    I am facing a number of problems, now with the impending discontinuity of Qlik Sense Desktop.

    I created the qlikcloud environment for the company, however when creating it, I created it with my email. Now, I would like to change the tenant, or the manager, or whatever the name is given to the general owner of the environment. And I just can't find this option anywhere. Even changing the user settings by editing their functions at https://empresa.us.qlikcloud.com/console/users/ in the "users" tab, placing another user as "tenant admin", disabling ALL other users including mine who is the current manager, even so, i can't change. Because only my e-mail can verify the licenses and buy licenses.

    Gentlemen, in short, has anyone gone through this, and already had to change the master user or key of the cloud, who can pass this information to me? Important detail: I was in the trial period, which is now closed. I clicked on prolonging the test, and nothing happened. And I don't want to buy the license with my user, precisely because I don't want him to be the general manager of the cloud, and because I don't want to burn a license with a user who won't have access. That is why my need to first change the user and then hire the service by purchasing licenses.

    Show Less
  • Community Corner

    Make your Voice Heard and Participate in the Wisdom of Crowds® Business Intellig...

    Dresner Advisory Services is inviting all business intelligence (BI) and enterprise performance management users to participate in its annual examinat... Show More

    Dresner Advisory Services is inviting all business intelligence (BI) and enterprise performance management users to participate in its annual examination of the state of the BI and analytics marketplace focusing on drivers, usage, and products.   

    The 2020 survey covers overall BI  deployment trends and related technologies and initiatives including cloud computing and BI;  self-service business intelligence; data catalog; marketing analytics; data science + machine learning;  and the role of the BI Competency Center (BICC). The survey also covers Enterprise Performance Management usage and intentions, including strategic, operational, and planning initiatives, as well as sales performance management.   

    Users in all roles and throughout all industries are invited to contribute their insight via an online survey. The 2020 Dresner Advisory Services research will be published beginning in late Spring and throughout 3Q20. Qualified survey participants will receive a complimentary copy of the findings.   

    Click here to start the survey today! The deadline is March 31st

    Show Less
  • Qlik Sense App Development

    GeoAnalytics UK Postcode Area / District / Sector / Postcode Map

    I am trying to create a map using GeoAnalytics. I would like to use UK postcode data to map sales based on a drill down of Area, District, Sector, Pos... Show More

    I am trying to create a map using GeoAnalytics. 

    I would like to use UK postcode data to map sales based on a drill down of Area, District, Sector, Postcode.

    Example data:

    Country = UK
    Area = PO
    District = PO14
    Sector PO14 4
    Postcode = PO14 4LW

    Does anyone know of any documentation to help me set this up, every video I find doesn't show any UK examples. 

    Thanks,

    Joe

    Show Less
  • New to Qlik Sense

    Dynamic load from multiple CSV; source data has duplicate field names

    I have multiple CSV files with slightly different columns that I wish to concatenate load into a single table. Each file contains approximately 120 co... Show More

    I have multiple CSV files with slightly different columns that I wish to concatenate load into a single table. Each file contains approximately 120 columns.

    Unfortunately, the source files also contain multiple "Filler" columns (header = "Filler").

    So, this fails:

    [SDE]:
    Load * Inline [
    SDE
    ];

    // This method won't work, because the file is littered with "Filler" columns (field names must be unique)

    For Each File in Filelist('$(vPath)/$(vFileMask)')

    SET vFile = '$(File)';

    Concatenate
    LOAD *
    FROM [$(vFile)]
    (txt, codepage is 28591, embedded labels, delimiter is ',');

    Next File;

    Is there a way to dynamically load multiple files, but exclude (or dynamically rename) columns named "Filler"?

    Thank you!

    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
  • Qlik Sense App Development

    count(field) is duplicating rows

    Dear community,I hope someone can help me since this is driving me crazy.I have a simple table with all the fields of the model which are 9. After som... Show More

    Dear community,

    I hope someone can help me since this is driving me crazy.

    I have a simple table with all the fields of the model which are 9. After some date filters, only one row show up in the table but my kpi shows '2' as value.

    capture29.png

    My script is:

    capture30.png

     

    I would appreciate some help please!

     

    Thank you in advance

    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