Hi,

I have configured and setup an OIDC virtual proxy in QS QMC. 

However, when my user logs on, I see that it is showing their ID instead of their name. 

Why is this happening and why is it not picking up their name as it is in Entra?

Thanks

Hello everyone, i'm having issues trying to create a canonical date in qlik sense when associating tables and was wondering if anyone would be able to help out. In basic terms i have 2 tables: "orders" and "sales rep visits", which are associated to the "customer data" table by customer number, (very simplified) script below:

Hi,

I have a bar chart showing sales volume per quarter (quarters on the x-axis)

currently the chart is fixed to always show the last 10 quarters, but ideally I would like to make it flexible, so that the users can select the quarters visible on their own, but when opening the sheet initially I would like to have the last 10 quarters selected automatically..

As the FYFQ field is a string like FY23-Q1, I additionally created a FYFQ_Row field which is a number count. Meaning 1 is the oldest FYFQ available and the highest number is the most recent FYFQ.

currently the chart is fixed to show always the last 10 quarters with the following dimension "if(FYFQ_Row > v_maxFYQ-10 and FYFQ_Row <= v_maxFYQ, FYFQ)" where "v_maxFYQ is defined as max(FYFQ_Row)

this works perfectly fine.

but my question is now the following: 
when changing the dimension to "FYFQ" obviously the chart will show all quarters available.
I know that through Sheet Actions I can add actions that are performed on opening of the sheet, like select a specific field value, etc.

But is it possible to somehow make the selection from above dimension on sheet opening. Meaning can I automatically select the last 10 quarters in the FYFQ field on sheet opening?

Thanks for your help.

Hi everyone,

I have a tReplaceList component that get a list of forbidden characters from a SQL table.

I want to add to my rules the replacement of CR LF because it's making my job fail.

From my tDBInput (Oracle) I have a column containing a CR LF character in the middle

When copying the data to notepad++ I can see that the line break is indeed a CR LF. But I've tried to add to my SQL table the values "\r" "\n", "\r\n" even tried with double \\ etc....

But nothing has been working so far. How do I make this work ? 

Bonjour,

Je cherche à calculer la DN (Distribution Numérique) d'une référence par rapport à son groupe d'appartenance.

Je dois donc compter le nombre de client qui n'ont pas un CA à 0€ pour ma référence ce que j'obtiens bien avec 

Count({<Client = {"=Sum(CA) <> 0"}>} DISTINCT Client)

En revanche, j'ai maintenant besoin d'obtenir le nombre des clients qui ont un CA différent de 0€ pour l'ensemble des références appartenant au même groupe que ma référence sélectionnée.

Par exemple REF1, REF2, REF3 sont dans le groupe A et je veux donc savoir en sélectionnant REF1 le nombre de clients qui commandent soit REF1, soit REF2, soit REF3 donc qui commandent parmi groupe A.

Il me faudrait quelque chose comme groupe={groupe de REF1} et exclure la REF1 sélectionnée avec REF=

Je vous remercie par avance de votre aide.

Hello Everyone,

Recently, i have been trying to implement and following were the Result anticipated:

Expected Result:

The query that i wrote was:

if((Left(KeepChar(GSKG_Zufu_Artnum,'0123456789'),1)=6082 and Left(KeepChar(GSKG_Zufu_Artnum,'0123456789'),1)=6084
and Left(KeepChar(GSKG_Zufu_Artnum,'0123456789'),1) =6090 and If(WildMatch(GSKG_Zufu_Artnum,6087000001001),103002,If(WildMatch(GSKG_Zufu_Artnum,6089000082001),
If(WildMatch(GSKG_Zufu_Artnum,6089000082002),103002,If(WildMatch(GSKG_Zufu_Artnum,6089000082003),103002,
If(WildMatch(GSKG_Zufu_Artnum,6089000082004),103002,Text(103001))))))) as Zufu_WeBuDaten_Leer_E1MARCM_PRCTR,

While loading the Data, it fetches an Error in these lines. 

Could anyone please go through once my query and Required Result and suggest me or clarify me the mistake i am making?

Thanks in advance.

I have created a GET REST connection to NPrinting and it works perfectly. This is the GET REST Connection Setup...
GET REST Connection Setup
My problem is that I am not able to set up a POST REST Connection. Everything is the same, except for the Method and the Trusted Locations, which has been loaded into NPrinting. 
POST REST Connection Setup

I managed to get the POST working in Postman, by first doing a GET login. Then copying the XSRF-TOKEN out of the Cookie and adding it to a X-XSRF-TOKEN key under Headers.

Postman POST REST Setup

This was a manual workaround, the problem is how to do it when setting up a Qlik Sense POST REST login connection... I can't get the XSRF-TOKEN to add it to the connection, to get the connection to authenticate, i.e., not give the 403 (Forbidden) error...

This Techspert Talks session covers:

• Demo of migration process
• Back-up Best Practices
• Troubleshooting Certificates

Chapters:

• 01:40 - Demo Environment Overview
• 03:08 - Installation Requirements
• 04:55 - Backing up Certificates
• 07:43 - Qlik Share drive
• 07:56 - Backing up the Database
• 10:35 - Importing Certificates
• 12:49 – Installation
• 16:08 - Restoring the database
• 19:18 - Troubleshooting start-up issue
• 23:30 - Q&A: How to migrate additional work?
• 24:19 - Q&A: How to export multiple apps?
• 24:57 - Q&A: How to apply a patch?
• 25:56 - Q&A: First upgrade or migrate?
• 26:58 - Q&A: How to migrate to Qlik Cloud?
• 28:29 - Q&A: How to migrate reload tasks?
• 28:53 - Q&A: Can we create an image for testing?
• 30:03 - Q&A: What if monitoring apps fail to reload?
• 31:27 - Q&A: How to migrate to AWS?
• 31:53 - Q&A: How to migrate NPrinting?
• 32:29 - Q&A: How to migrate Web Connectors (QWC)?

Resources:

• Backup and restore Qlik Sense Enterprise on Windows
• Planning your migration to Qlik Cloud
• Backing up certificates
• Backingup and restoring NPrinting
• Installing Qlik Web Connectors

• Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer

• Qlik Sense Upgrade Guide

Click here to see video transcript

@Sebastian_Linser