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.
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.
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?
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 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,
[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',
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
(biff, embedded labels, table is Results$);
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
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
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'
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.
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.
Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.