Hi All,

I am trying to create a calculate field based on multiple IF conditions in chart in dimension field.

I know we can create easily in script but i need to put in frontend.

If($(variable)<1, 'start',

  If($(variable)<2, 'End',

    If($(variable)<3, 'xyz',

       If($(variable)<4, 'middle','abc'))))

If $(variable) is 1, the field would return start but i need to display all values in chart 

start

end

xyz

middle 

abc

and measure is Sum(sales)

Please suggest me how can we create this in chart.

Thanks & regards,

Saritha.

Hi everyone

I am facing an issue with the QCDI. Yesterday when I faced an error of REPLICATE-AGENT-UPDATE-TASK-FAILED 502 so, the data gateway movement was not able to connect, so we tried to update the key and restart the connection of gateway movement. But we are facing an issue with the data gateway movement.  

so, please guide me where I need to check to correct this error!

Hello,

Qlikview Personnal Edition on Windows11 x64

Since the windows11 update in august and especially september 2024. all the documents created on my PC no longer open (message: this qlikview document was created by another user of the personal edition ....)

which is not the case (only one user on this PC). If I create a new document, save it, close it and try to open it again within a minute, I always get this message. this has been the case since the last windows11 update. in august I lost all my documents, it took me almost a month to rewrite the main documents.

now since the last windows update, i can't even do that, as it's immediately unusable.

Does anyone have a solution to this problem?

NB I tried revoking the last Windows update and reinstalling Qlikview ... but nothing worked!

Regards

突然QCDIでプロジェクトを作成していたら、データゲートウェイに接続できないエラーが出てしまい、LandingタスクからDMまで全てのタスクがエラーになってしまいました。

Data Gatewayは起動していて、QS SaaS上のステータスも接続済み、SAPHANAサーバも問題なく動いておりました。

Gateway側でテナントURLの更新、キー発行、QS SaaSで新しいゲートウェイ接続でキー登録したのですが、再度実行してみると、Landingタスクは動きましたが、その後のStorageタスク、DMタスクが物理オブジェクトでViewを見ているときにデータゲートウェイサーバに接続できないというエラーが発生しております。

解決策を教えてください。

I have a question about a Compose Task.

I have a mapping that creates a table in the data warehouse from a table in the landing zone. The full load works. Apparently a row with id = 0 and all other values NULL is created. If I now want to run this mapping as a CDC task, I always get the error message “Cannot insert the value NULL into column”. This message occurs when the task “Populating temporary table TTMP_5868_DwhKeys” is to be executed. How can I fix this error, since the NULL line is created by Compose?

Any tips are highly appreciated!

Hello everyone,

since the update to version May 2024 - Patch 6, I do not get the complete table displayed directly in the table when creating a new app and have to click on “Load more” at the bottom.

Is there a setting option that will load the complete table again?

Many thanks in advance.

Best regards

DS395

Is there comprehensive documentation available on using Qlik Replicate to extract data from SQL Server objects, including approaches with replication, CDC, and without either replication or CDC?

I’m looking for detailed information on each approach, including the pros and cons. I understand that the choice depends on the specific use case, but Looking for a list with all possible methods and clearly outline the use case for each, along with their advantages and disadvantages.

Limitations with SQL Server objects with each of these approaches.

Hello Team,

We were performing migration from of Qlik Sense site from one servers to another server which includes multiple RIM nodes and central node with bundled data base.

Restoration was successful and central and one RIM node was up and accessible from HUB. However, for other server status in the nodes section in QMC shows 1 of 1 service is running even though all the services are running in the server.

The only service that is running on that RIM node is repository service and other services are shows not contacted.

Every other service has errors logged saying cannot be connected to the central node and license service logs shows below error:

"message":"failed retrieve central node info from QRS (communication error)"

 connectex: No connection could be made because the target machine actively refused it.

 failed retrieve central node info from QRS. http status code","statusCode":503

I have removed the node from QMC and redistributed the certificates, also have verified that every required port is open and connectivity is there.

Any idea what could be the issue, as only reinstallation option is pending.

Thanks. 

A possible bug:

1. Set a page as private into a group
2. Publish the page
3. Move the page in a different position = Error 5

But:

1. Set a page as private not in a group
2. Publish the page
3. Move the page in a different position = Ok!

See attached video.

Some help?