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!

Hi, what do i miss here??

if(frac(STARTTIME)>=MakeTime(6,45) and frac(STARTTIME)<=MakeTime(15,29,59),'FM',
if(frac(STARTTIME)>=MakeTime(15,30) and frac(STARTTIME)<=MakeTime(22,59,59),'EM','Natt')) as Shift

Hi, I'm really new to qlik and have tried to find most things on different forums but now I got stuck and was hopeing someone could help me.

How can I rearrange the columns on this table? I would need it to show the quarters on a chronological order.

Thanks in advance!

Hello

we want to transfer data from db2 for z/os -> Postgres once a time with a FULL LOAD task for  a group of tables.

Is it possible to perform this without enabling CHANGE DATA CAPTURE on that group of tables ?

Thanks

AF

I really liked chart exploration in straight table chart recently added to Qlik sense. Can Qlik sense add this feature also to the official table chart?

Hi All, 

Recently, we encountered a situation where the CPU utilization on the consumer nodes within the Qlik Sense Enterprise production environment reached 100% Wherein the Repository.exe on the consumer node is taking all the CPU. As a consequence, the Qlik Sense Hub became either inaccessible or significantly slowed down for all end users

The current interim solution involves rebooting the consumer nodes daily in the morning. However, we are actively seeking a permanent resolution to this issue. If anyone has encountered a similar problem within the Qlik Sense Enterprise environment and found a solution, your insights would be greatly appreciated.

Config- We have QS Nov 2022 installed with Cloud SQL instance Postgres as Repository.