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

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?

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$);

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 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

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?

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.