Since a few weeks, we're getting this error frequently: 

The task however is in batch apply. There is no further information in the logging. 

source is Oracle cdc, using logstream

target is databricks lakehouse (delta)

How to resolve this recurring issue?

Hello everyone,

I received a requirement to calculate weighted availability, meaning:

The percentage of total sales in the stores where the selected product is sold, out of the total sales across all stores.

The expression needs to be displayed in two charts:

1. A Bar chart with Sector as the dimension.

2. A Line chart with Sector and Year as dimensions.

I was able to create the bar chart using the following expression:

({1<[Material]=P({1<[Product_Division]={'10','12','13','16','26','30','35'}>}[Material]), CustKey=P({<[Customers.Name] -= {"*Marlog*"}, [Customer_H6_Desc.]={'Private'}>} CustKey),
, Year = $::Year>}

[Sales])
/
{1< [Material]=P({1<[Product_Division]={'10','12','13','16','26','30','35','40'}>}[Material]), CustKey = P({1<[Customers.Name] -= {"*Marlog*"}, [Customer_H6_Desc.]={'Private'}>}CustKey), Year = $::Year>}
[Sales]

However, I was not able to make it work properly for the line chart.

There are Three additional constraints:

• [Sales] is already a master measure and cannot be modified.

• The line chart should ignore Year selection (So the trend will always be visible).

• There may be selections on different product levels (Category, Barcode, etc.).

•  

I would appreciate a solution or an alternative expression that might work better in this scenario.

Thanks in advance!

Hello

I have a DB2 z/OS source table, that is maintained by a LOAD job. There are multiple Steps in the Job. First it does a LOAD REPLACE and after that there are several LOAD RESUME steps. None of this is by default captured by the Log Stream task that is reading the source.

However these changes should be visible to Qlik Replicate. My expectation would be to have a reload of the table triggered after the LOAD REPLACE finished and the LOAD RESUME could be handled as mass inserts.

Is there any possibility to achieve this?

Hi,

I have one sales table (straight table) in Qlik Sense similar to given below table.

Now, my user wants to write comments in the comments column. Do you know, how to enable Comments column for text writing?

Sales Table:

Or is it possible to create new table with product id and comments column with editable comments cell? if yes, then how to achieve this ?

Thanks

Hello

I would like my users to be able to enter a comment to a project in a report via an inputbox. My first thought was if it was possible to include variables when you share a link to the report. That would be good enough. I tried the share button but it seem to only include selections and not variables. Or am I doing something wrong? 

Any other ideas on how to achieve this? Can it be done?

My company is going to build a platform that has 2 layers (development and production) and we are going to have source control with that (git). so I started to search for solutions.

First, I found QDF which is great to have modules but again all other parts (like visualization, measures, dimensions, ..) remain binary and we should ignore them. 

Second, I found serializeapp which converts an app to some JSON files but It didn't give any solution about how should we restore it.

Third, I found QMC Utilities which have a plugin for backup/restore in JSON files. However it's an alpha version and when I tried to test, it didn't work correctly (I made a new app and I published it but It didn't appear in the list for backup and restore!! after I found the API for getting the list and run it manually, the list in QMCU is also updated!). Also, I don't want to use an application because then some parts of the work will be manual.

Finally, I learned about QRS APIs I couldn't figure out what is the way to backup/restore APP in JSON files. I think the documentation is not good enough. 

So, do you have any solution or know an API which is my solution?

In our Qlik Sense app development life-cycle, we are thinking that there must be a way to build a Continuous Integration/Continuous Deployment pipeline and include some basic automated testing within the promotion workflow.

1) Determine how to integrate Qlik with a Source Control (like BitBucket) to ensure apps are source controlled

2) Determine if it would be possible to have more than one developer working on one app at the same time. Would Bit Bucket be able to determine and solve merge conflicts?

3) Research and POC an eventual CI\CD pipeline for Qlik to be able to automatically promote apps across environments, potentially by making use of Qlik APIs

Can you please refer to current best practices and assets we can leverage in building a continuous deployment pipeline for Qlik Sense?

Hi techies,

I opened a discussion on source control with Qlik Sense two years ago https://community.qlik.com/t5/New-to-Qlik-Sense/Version-Control-in-Qlik-Sense/td-p/1459203

I was looking for solution how to do source control in Qlik Sense as we do with github or bitbucket for text file.

I didn't get any solution or any tool suggestion that time.

I am looking for same solution again after two years. I hope people have created source control solution for Qlik Sense.

Please suggest me tool, either Windows or Web based which can help a developer to do source controlling.

Thanks in advance

Rohit