Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,426 online

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.

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

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 eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

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

Discussion board and documents related to Qlik Associative Big Data Index.

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.


WEBINAR SERIES: THE DX FILES

When disruption is nonstop, how do you compete – and thrive? Digital Transformation is a must, and data is at the heart of it. To pull ahead of the pack, stay in front of the trends, and keep pushing innovation further, you have to consistently reinvent your business – fast – with a modern approach to data. When it comes to Digital Transformation, the truth isn’t out there – it’s in here. Join us July 30 – August 28, 2019, for 5 tracks of insight-packed webinars.

Recent Discussions

  • New to Qlik Sense

    Accessing Access Database From QlikSense

    Hi Team ,  I have a AccessDatabase(64 Bit) file which is saved in my Desktop(ip :172.xx.xx.xx) There is a requirement where i need to l... Show More

    Hi Team , 

     

    I have a AccessDatabase(64 Bit) file which is saved in my Desktop(ip :172.xx.xx.xx)

     

    There is a requirement where i need to load the Access database from the QlikServer((ip :172.xx.xx.01)) Hub. How do i achieve this. 

    Regards,

    Senthil

    Show Less
  • Qlik Sense Cloud Discussions

    Auto Update dashboard in qlik sense cloud

    Hello,I successfully update data in my database and see the new dataBut dashboard didn't update data - I mean that on dashboard data end on 19 July, b... Show More

    Hello,
    I successfully update data in my database and see the new data
    But dashboard didn't update data - I mean that on dashboard data end on 19 July, but data is loaded until 20 July.

    What should I do in qlik sense cloud to auto update my dashboard when new data appears after scheduled update?

    Show Less
  • QlikView Scripting

    Field Not Found Error

    Hi, I keep getting the 'Field Not Found Error - Field ShipperCountryCode Not Found' when I run the below script. I have used the If(len) formula ... Show More

    Hi, I keep getting the 'Field Not Found Error - Field ShipperCountryCode Not Found' when I run the below script. I have used the If(len) formula as I wish to replace the data in a field if another field contains a value. Any ideas?

    //===SHIPPING ORDER===

    [Shipping Order Number] as MatrixSO,
    [Port of Loading] as PoL,
    [Port of Discharge] as PoD,
    date(floor([Expected Ship Date])) as ExpShipDate,
    Upper([Service Level]) as ServiceLevel,
    [Path Type] as MatrixPathType,
    INCOTerms,

    //===SHIPPER===
    [Shipper Name] as ShipperName,
    [Shipper Alias] as ShipperAlias,
    //[Shipper Country Name] as ShipperCountry,
    //[Shipper Country Code] as ShipperCountryCode,
    //[Shipper City] as ShipperCity,
    [Shipper State] as ShipperState,
    //[Shipper Postal Code] as ShipperPostalCode,
    [Shipper Region Name] as ShipperRegion,
    [Pick Up Location Name],
    [Pick Up Location Alias],
    [Pick Up Location Country Name],
    [Pick Up Location Country Code],
    [Pick Up Location City],
    [Pick Up Location State],
    [Pick Up Location Postal Code],
    [Pickup Location Region Name],

    // For each country, the tradelane identifier has to be entered in the input file
    applymap('Tradelane_map', ShipperCountryCode, 'n/a')
    & ' to ' &
    applymap('Tradelane_map', [Delivery Location Country Code], 'n/a') as Tradelane,



    // For non-UK origins and destinations, the rates are stored without any characters (eg. not '5469 VV' but '5469').
    // In order to define the correct %RateID (see below), we need to purge the shipper and delivery postal codes
    // outside UK from any non-numeric characters
    IF(ShipperCountryCode = 'GBR',
    ShipperPostalCode,
    KeepChar(ShipperPostalCode, '0123456789')) as ShipperPostalCode_purged,

    IF([Delivery Location Country Code] = 'GBR',
    [Delivery Location Postal Code],
    KeepChar([Delivery Location Postal Code], '0123456789')) as DeliveryPostalCode_purged,


    if(len([Pick Up Location Country Name])>0,[Pick Up Location Country Name], [Shipper Country Name]) as ShipperCountry,
    if(len([Pick Up Location Country Code])>0,[Pick Up Location Country Code], [Shipper Country Code]) as ShipperCountryCode,
    if(len([Pick Up Location City])>0, [Pick Up Location City], [Shipper City]) as ShipperCity,
    if(len([Pick Up Location Postal Code])>0, [Pick Up Location Postal Code], [Shipper Postal Code]) as ShipperPostalCode




    FROM
    [Input\Shipping_Order_Extract-week 27.xlsx.xls]
    (
    biff, embedded labels, table is Results$);

    Show Less
  • QlikView Layout & Visualizations

    background color change for straight table labels

    I want to change the background color for the labels for expressions in straight table.I tried custom formatting also to change the background colors ... Show More

    I want to change the background color for the labels for expressions in straight table.I tried custom formatting also to change the background colors but it is reflecting only to the values of the expressions but not to the labels. How can I achieve this.Please hep me

    Show Less
  • New to Qlik Sense

    Ranking customers both on the current and previous years in one table (and restr...

    Hi everyone, I hope the title is not too confusing, but basically I have a table looking like following: Table: [date, sales volume, custome... Show More

    Hi everyone, 

    I hope the title is not too confusing, but basically I have a table looking like following: 

    Table:
    [date, sales volume, customer
    01.01.1970, 100, A
    01.01.1970, 200, B
    ...
    31.12.1970, 500, C
    31.12.1970, 550, D
    ...
    01.01.1971, 120, A
    01.01.1971, 230, B
    ...
    31.12.1971, 550, C
    31.12.1971, 650, D
    ]

    What I need to do is to have table which basically shows 10 clients with biggest sum([sales volume]) this year,

    and shows those clients' ranks in the previous year.

     

    I do understand how I rank current year (with set analysis), but can't get my head around how to rank the previous year's sales in the same table

    Any help would be really appreciated,

    Thanks in advance 

    Show Less
  • New to QlikView

    Acces point

    Hi, How to disable + sign on access point URL so that users can not add sheet.Please fine attached screenshot:    
  • New to Qlik Sense

    How to replace a null chart

    I created a hotel dashboard myself and I made a filtering on some dates and some times not all corporate guest made a booking on that date. How d... Show More

    1.PNG

    I created a hotel dashboard myself and I made a filtering on some dates and some times not all corporate guest made a booking on that date. 

    How do I replace this blank chart with a message that is saying 'No corporate booking in this period' 

    Thanks

    Show Less
  • QlikView Publisher

    Task History Disappeared

    Dear Experts,Task History for executed tasks in QMC is disappeared.Can someone please help with your points.Thanks,John
  • Qlik Sense App Development

    Access to Data Load Editor intermittently disappearing

    We have been having developers reporting that the menu item for the Data Load Script will just randomly disappear while working in an app in their Wor... Show More

    We have been having developers reporting that the menu item for the Data Load Script will just randomly disappear while working in an app in their Work stream. It's not consistent or replicatable, but it's been happening on and off for a few months - we just can't get a handle on it.

    We are not modifying any permissions or roles at all, let alone access to the script, and all of these are while they're in Work, so apps they own - all users can report about when it's happening is that it is typically when they have been working in their load script for awhile, usually with multiple tabs open (i.e., checking the data model viewer) and then try to save their script or come back to the script from one of the other pages - and the option in the menu is just gone. Only ways around it are to log completely out and back in (which works sometimes) or else duplicate the app and the new app is fine. 

    We are running an Enterprise Server installation of Qlik Sense, running November 2018.

    Ideas?

    2019-02-12_17-34-39.png

     

    Show Less
  • QlikView Deployment

    Using NTLM for authentication, LDAP for distribution

    Hello community.  I am trying to resolve the following issue.  We would like to use NTLM for authentication (using IIS/QVWS).  This is ... Show More

    Hello community.  I am trying to resolve the following issue.  We would like to use NTLM for authentication (using IIS/QVWS).  This is fine, as long as we are limiting our distribution to Active Directory groups.  We find however, that we cannot use LDAP groups for distribution.  The issue appears to be that with NTLM, QV is presented with an ID in the form of ADDomain\USER_ID.  This value does not retrieve LDAP groups for the given SID.  Is there some way to use LDAP groups for distribution, when user is logging in via NTLM?  Thank you for your assistance.

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.