In a recent Qlik Q&A session, I asked a question about how I could automate copying a full sheet from a source app to a destination app. The reason I am trying to do this is because I have several versions of one app published, each for a different audience. As a result, each app has a slightly different set of sheets (but they all have the same backend data). However, there are some sheets that are deliberately common between apps. In my current state, I have to make the same changes to these sheets across several apps. This occasionally leads to data discrepancies between those sheets (because it is so manual). It would be nice to have one source version of the sheet, and propagate it to all necessary apps.

Originally I was trying to investigate using the Qlik CLI and build/unbuild feature to do this, but in the Q&A session, it was suggested by the Qlik experts on the call that I could use an automation to accomplish this. I cannot find a template that does this, nor can I find blocks in an automation having to do with Qlik sheets at all. Is this something possible to do in an automation? 

I am looking to retrieve all the days of the previous year within my date range.
However, with this formula, for leap years, it does not take into account February 29th.

The variable DateCloture is filled with a value such as 28/02/2025.

And I want to retrieve the measure for the period from 01/02/2024 to 29/02/2024.

How should I proceed, please?

SUM({1<TYPE={"F*"},
DATE={">=$(=NUM(MonthStart(ADDMONTHS($(vDateCloture),-12))))<=$(=NUM(MonthEnd(ADDMONTHS($(vDateCloture),-12))))"},
DOMAINE={"*P"}>} TOT*TAUX)/1000

Hi,

Hi please when configure a remote engine on Premise to connect sql server u oracle database, If necesary install in server host remote engine install jdbc driver or Remote Engine managment this?

Thanks

Is it possible to per default disable the data preview when opening the script editor on a Qlik Sense on Windows installation?

When a developer navigates to the Data Load Editor of an Qlik Sense application then the default view is to see script section to the left, the data connections to the right and the data preview tables in the bottom. Populating these views, sometimes  makes the data editor page use substantial amount of time to fully render it self so it is possible for the developer to do script changes or initiate a reload.

We handle some very large applications and we believe being able to disable the data preview in the load script editor would speed up the rendering of the load script editor page. 

I have not found any documentation on how to set the default state to disable disable the preview. Is it possible to configure Qlik Sense to do this, either on environmental or by app level. 

(The environment is running Qlik Sense November 2024 on multiple nodes)

I have the following Table

in a set analyses formula i want to select only all codes less than 4000 Kosten

Sum({$ <Jahr = {"$(=only(Jahr)-1)"}, Monat = {"*"}, Konto = {"< 4000"} >} [Betrag])

what is wrong with this formula?

Hi Team,

How can we show bar labels inside the bars in combo chart in qliksense.

I checked the option Style under chart properties under Bar labels but that is not working. Can you suggest any other option present?

I have two tables: Master and Transaction.

Master has one column named Source, which contains string values, and the name column in the Transaction is made up of string values.

I need to create two new columns, Is Available and Split, based on the columns mentioned earlier. If the value in the Name column fuzzy matches with a value in the Source column, the new column Is_Available should populate Y; otherwise, N. Similarly, if the Source column fuzzy matches the Name column value, the Split column should populate the Source value in it; otherwise, nothing. It has to work like fuzzy lookup.

For example, in the attached picture, the df value in the Name column is present in the Sdf and Aspdsdf values in the Source column, and hence Y is populated along with the Source values in the new columns.

Hi, we have the data series below and we would like to count the breakout changes of one of the two fields Forma/Diam

Result we would like in this case is 7

Hi I am trying to create a line graph such as the one below shown in Excel. How would I use crosstable on my table below in order to achieve something similar.

Thank you in advance!