Boa tarde comunidade!

Eu realizei um 'IF' que foi realizado corretamente, mas ele me apresentou alguns valores nulos.
Como poderia fazer para remover esses valores?

Muito Obrigado pela atenção.

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 ? 

Hi Team,

Today we are trying to upgrade Qliksense Multinode environment from Feb 2022 Patch 5 to Feb 2024, We follow all the backup steps which are mentioned in Qlik help-

Backing up a Qlik Sense site | Qlik Sense for administrators Help

We took backup of all certificates and Repository as mentioned in article. After taking backup we check that Postgres SQL version on Feb 2022 Patch 5 is Postgre9.6 so we decided to upgrade postgre version to postgresql14.8 which is suitable for all newer versions. For upgrading the Postgre SQL we follow all the steps mentioned in Support article as mentioned below-

Upgrading and unbundling the Qlik Sense Repository... - Qlik Community - 1934238

The PostgreSQL is upgraded successfully, after upgrading we checked the services on both Central and Rim Node all are running fine. But after that we are trying to Upgrade Qliksense, Setup started successfully but in the end it is end with an error the  error is attached in screenshot.

I am not sure what problem occurs during these steps. 

Please guide.

Thanks in advance

Hi All,

How to sort data based on leading zeros and not the actual number in qlik

Below is my example

The data should be sorted based on number of zeros at the start in ascending order.

My final output should be like the below table

Note : This is just an example . I have more that 30000 item numbers like this and i want to sort based on number of leading zeros

Dear Experts,

I would like to trigger some qlikview jobs automatically when the SAP job completed.

Do we have a work around for this?

I do have a SAP table which stores the job completion information.Is there a way qv checks the status of the sap job and trigger when it says "Yes"

Thanks & Regards

Jeba

(Apologies, this was posted earlier but was my post was so full of flaws, I removed it).

I am trying to show a graph of tickets raised over a periiod of time.  In my data I have zero 'Open' tickets in October and as a result October does not show on my graph.

I have tried a 'Master Calendar' which works until a filter is applied.  -

I have also read about adding + sum({1}0) to my measure.

Count({<[Status]={'Open'}>}id) + sum({1}0)

and setting the Addons -> Data Handling -> Include zero values 

Any help would be appreciated

We can only see the usage on the app level using the Entitlement analyzer, but we cannot track the sheet usage, is there anyway to do it on SaaS? I know it's possible on Enterprise. 

Hi,

Recently I set up a DataBricks Connection but unable to access the databases inside the Catalog.We are in May 2023 Patch 6 version of Qliksense. But the same connection could be accessed through SAAS. Please help.

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...