I have multiple qvds uploaded in my data load editor with each qvd containing a few datapoints that have similar data but different column names. I created aliases for each to join each other but that created multiple synthetic keys. I want to join these tables so that these common fields can become filters on the dahboard. I can not concatenate the tables since the names are not the same in each table. Adding an example of data below. 

Table 1: 
Load
ProductName
Sales
Cost
Projects
City
From[Source]

Table 2:
Load
Products
Profit
Cost
SKU
ProjectName
CityName

Table3: 
Product
PersonID
PersonName
CityEnName
Project

The filters that I want to create are Product Names, Project Names & City Name. 
Please suggest how. I also tried creating joins but creating multiple joins for more than 20 tables doesn't work either. 

Hi, 

Is it possible to copy the Qlik Sense server to another server as is?

The system administrator guy in our company copied the entire server to a new machine (computer name and IP address remained the same)

Buy now the Page cannot be reached, No access to Apps or QMC. 

Another details : 
- All services are active
- no firewall active or restriction on ports
- Both are singe node environment
- Old server: hyper-v , New server: vmware 

Has anyone tried this type of server copying / migration?
Is there a way to make it work from this point or just restore the previous server?

Tanks 

Hallo Zusammen,
ich bin recht unerfahren in der Nutzung von Qlik und würde mich sehr freuen, wenn mir jemand einen Tipp geben könnte.

Ich müsste einen Filter definieren der aus einer Auswahl von Werten einer vorhandenen Tabelle besteht. Die Tabelle hat über 3000 Einträge aus der man mehrere Hundert Werte auswählen müsste, um mit diesen Werten bestehende Arbeitsblätter zu filtern. Die Auswahl aus dem Drop-Down Menü ist mühsam und fehleranfällig, weshalb ich einen Weg suche den Filter mit dem Formeleditor abzubilden. Die Filterwerte würden in Textform vorliegen.

Gibt es eine Funktion mit der man das Arbeitsblatt wie gewünscht filtern kann? Bestenfalls würde ich diesem Filter gerne einen Namen geben und ihn als Drop-Down Auswahl zu Verfügung stellen. Könnte mir aber auch mit entsprechenden Lesezeichen behelfen.

Vielen Dank im Voraus für Eure Hilfe.

Hi there, 
I have created an APP reload button. 
On my work environment button seems to work ok.

Once I publish dashboard, button only reloads data for 20 seconds, then it goes back to the previous set of data.

does anyone know why this anomaly happens?

Thanks a million for your support!

Regards

Jose

I'm getting below error while trying to read data from a HIVE table

20240415T105556.712-0500 Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 08S01, ErrorCode: 115, ErrorMsg: [Microsoft][Hardy] (115) Connection failed with error: SSL_read: error code: 0

I'm getting this error only while fetching data from a particular table, for rest of the other tables it works fine with same connection.

Can anybody give any pointers to how to debug this? I ran the same query via Hue SQL interface which HIVE provides, the query works fine and I'm able to export whole dataset

{"errors":[{"title":"State verification failed","detail":"State parameter not valid, try accessing the tenant url directly","code":"STATE-1","status":"401"}],"traceId":"5ca138b53b455ee35f9e25502159cc42"}

 Getting State parameter not valid while accessing Qlik cloud from Single page application .

Using Qlik Sense ClientId and Client secret key  with  Azure AD configuration by ADFS.

Hello everyone,

As part of an audit from my company, it security is asking me how to extract event log (every type of log) to splunk.

The logs i want to extract is the following:

• com.qlik/edge-auth
• com.qlik/users
• com.qlik/automations

Is it possible to do that with an automation ?

I know that there is one available but it lacks informations.

Thank you

Regards

I am trying to connect to google BQ I am successfully able to create ODBC connection but not from qlikreplicate getting this error

SYS-E-HTTPFAIL, Cannot connect to ODBC provider.
SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 08001 NativeError: 10380 Message: [Simba][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[KeyFilePath_Enc]}
 

Bonjour, 

Je viens d'installer QlikSense Entreprise 2023 (sur un serveur qui n'est pas connecté à internet) et dans chargement des données > Créer une connexion, je constate qu'il me manque le connecteur PostgreSQL : 

Savez-vous comment je peux récupérer le connecteur PostgreSQL ? 

Voici les informations sur la version : 

Qlik Sense February 2023 Patch 4 

Qliksenseserver : 14.113.6

• About Service 1.35.0
• Bot Channel Service to enable chat experience through channels like Slack/Teams 1.25.0
• Broker Service 5.40.0
• Capability Service 1.13.0
• Client 7.862.5
• Cross-applications search for nl questions 1.78.1
• Data Preparation Service 3.450.0
• Dependency Graph Service 2.1.0
• Dev Hub 2.3.0
• Download Preparation Service 1.3.0
• Freya Client Service 2.15.0
• Licenses service 3.269.0
• Mobility Registrar Service 1.3.6
• Monitoring Apps 9.4.0
• Natural-language broker, a front-facing API for NL utterances 3.116.0
• Natural-language understanding parser service 2.64.0
• Notifier service 1.5.6
• ODAG Service 3.25.0
• Precedents Service 3.31.0
• Printing Service 15.46.0
• Proxy 15.11.2
• QDC Catalog Service 0.27.0
• QIX Engine 12.1581.4
• Qlik Essbase Connector 1.72.0
• Qlik Management Console 1.123.2
• Qlik ODBC Connector 6.235.0
• Qlik REST Connector 2.175.0
• Qlik SalesForce Connector 15.162.0
• Qlik Sense Hub 0.102.2
• Qlik Web Connectors 4.30.0
• Repository 31.22.2
• Scheduler 20.5.1
• Service Dispatcher 15.38.1
• Web Extension Service 1.12.0
• Web Extensions 1.7.3

Merci pour votre aide