Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
1 EB |
100 Stammkapital |
0143 immaterielle Vermögensgegenstände |
0520 Pkw |
0635 Betriebs- und Geschäftsausstattung |
0650 Büroeinrichtung |
0755 Gewinnvortrag vor Verwendung |
0850 Beteiligungen |
1000 Verrechnungskonto Anlagevermögen |
1010 Anlagevermögen |
1050 Beteiligungen |
1100 Verbindlichkeiten langfristig |
1200 Kunden gewerblich Inland |
1210 Kunden gewerblich EU |
1220 Kunden gewerblich Drittland |
4000 Kosten |
8000 Umsatz |
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 want to default all the security rules to Auto Assign to "Off" when creating a new tenant. I've been looking through the rest API Group, Users, Roles, ... but can't find anything relating to this
Does this exist in the API?
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!
Workshops and certifications are always in high demand. Register now to be sure to get what you want.
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions for the sixth time.
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.
Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!