Hi Qlik Sense Fam,

Requesting your assistance with this issue. We would like to ask is DB encryption is enabled on this PostGres DB?  If not enabled, feasible can simply be enabled and no impact on the Qlik Sense? Also, how to know if the current PostGres DB used has a password or is encrypted?

Thank you.

Completely new to Qlik. I'm been asked to create a a "Domino's pizza tracker" like graphic that is colored based on the status of the activity. A user could then click on a "section" to get more details. Does anyone know how I could go about creating something like this?

Hi All,

We are running Qlik Sense on premise May 2023 version (with patch 13).

we want to upgrade to the latest version Feb2024 or latest (still on prem).

Could anyone please suggest if there is any constraints or blockers or limitations we should take care of?

Many Thanks

Ani

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. 

I am getting a Error Code 1Error Message java.sql.SQLRecoverableException:Closed Connection error while a talend job is running on a production server but am unable to diagnose while this is happening.

Does anyone have any suggestions on how I can go about diagnosing this?

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, I'm trying to connect SharePoint via Qlik Sense. Below steps i followed, 

1. Creating a new data connection. 

2. Choosing  the data source "Office 365 Sharepoint"

3. Then given the base URL of Office 365 Sharepoint in the baseURL.

4. Then choose the "None" from Prompt/Consent level. 

5. Click on Authenticate button. Then it will take to next tab and code generated. Then copied code and paste in the respective tab. Then clicked on the Authenticate tab. 

6. After that taking some time and faced the error. Below is the error message,

"error verifying: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond "Some IP (1.1.1.1:443)"

kindly suggest

Hi,

I have a fact table (f_table) and dimension table (d_table) with below fields.

f_table: country_cd, measure_1

d_table: country_cd, country_desc

In Qlik Sense data manager, I associate both the tables on country_cd field. 

Now I add a bar chart to display measure_1 against country_desc. There are many country codes in my fact table which are not in dimension table. All these are displayed against '-' in my bar chart. But I want to display it as 'Unknown'.

I tried changing the dimension (in bar chart) from just "country_desc" to "if(isnull(country_desc), 'Unknown',country_desc)" but it does not help.

Appreciate any suggestions. Thanks!