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 

Hi,

This is my first time working with xml files,I am loading several xml files in my application, they are being concatenated but there is no key which links the different tables together.QV generates a %key but that is always a 0 for eachfile, how can i create/get a key to link the files?

any help is appreciated.

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.

Liebe Community,

Ich habe ein Punktediagramm mit x - y Werten sowie einer definierten Größe pro Datensatz. Je nach gefilterter Kategorie scheint es jedoch so, dass sich die Bubblegröße (trotz fester Skalierung) an die gefilterte Menge anpasst und somit rein visuell unterschiedliche Größen aufweist.

Ist das Problem hier bekannt und wisst zufällig ob sich das lösen lässt?

Vielen Dank vorab

Hi Support Team,

I checked the status of the task in Enterprise Manager's Message Center.

When executing the 「FULL+CDC」 task, TYPE was output in the following order.
・TASK_START
・TASK_FULL_LOAD_STARTED
・TASK_FULL_LOAD_FINISHED

After stopping the task and restarting it with "Resume", the TYPE was output in the following order.
・TASK_STOP
・TASK_START
・TASK_FULL_LOAD_STARTED

Since it is 「Resume」, FULLLOAD will not be executed,
but 「TASK_FULL_LOAD_STARTED」 was displayed in the Message Center.

I have a question about the TYPE 「TASK_FULL_LOAD_STARTED」 at this time.
・Why is 「TASK_FULL_LOAD_STARTED"」 output even when I select 「Resume」？
・For what kind of operations will 「TASK_FULL_LOAD_STARTED」 be output？

I am trying to send a request body to tRestClient in the below format

{"x" : [1,2,3], "y" : [] }

I am using txml map to prepare the body and send a request, it is being sent as  string type not as a list type

{"x" : "[1,2,3]", "y" : "[]" }