Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 246,479 members
  • 5,595 online
  • 2,029,318 posts
  • 152,740 Solutions
Announcements
March 26 at 10am ET: See how Qlik drives growth and value in ISV segment - REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    Application Automation

    Use an automation to copy a sheet from one Qlik app to another Qlik app

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

    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? 

    Show Less
  • forum

    Visualization and Usability

    Leap year issue

    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 acco... Show More

    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

    Show Less
  • forum

    Talend Cloud

    Remote Engine Endpoints drivers

    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 insta... Show More

    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

    Show Less
  • forum

    App Development

    Disable Data Preview in Data Load Editor in Qlik Sense on Windows

    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 navigat... Show More

    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. 

     

    Vegar_3-1742818496879.png

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

     

    Show Less
  • forum

    Visualization and Usability

    Filter at set analysis

    I have the following Table 1 EB 100 Stammkapital 0143 immaterielle Vermögensgegenstände 0520 Pkw 0635 Betriebs- und Geschäftsausstattung ... Show More

    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?

    Show Less
  • forum

    App Development

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

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

    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?

    Show Less
  • forum

    Integration, Extension & APIs

    API end point for Auto Assigning Security Roles (SaaS)

    RE https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/SaaS-roles-capacity-model.htm#:~:text=Do%20the%20following%3A-,In... Show More

    RE https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/SaaS-roles-capacity-model.htm#:~:text=Do%20the%20following%3A-,In%20the%20Administration%20activity%20center%2C%20go%20to%20Manage%20users%20%3E%20Permissions,role%20at%20their%20next%20login.

     

    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?

     

     

    Show Less
  • forum

    Connectivity & Data Prep

    wildmatch data from two tables without linking those tables

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

    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.

    MahendranCS_0-1742445214452.png

    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.

    Show Less
  • forum

    Visualization and Usability

    Code Breaking Values ​​Counting

    Hi, we have the data series below and we would like to count the breakout changes of one of the two fields Forma/DiamResult we would like in this case... Show More

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

    SalvatoreSteccato_0-1742813584023.png

    Result we would like in this case is 7

     

    Show Less
  • forum

    App Development

    How would I use 'Crosstable'

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

    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!

     

    GeorgeEard_0-1742819134085.png

    GeorgeEard_1-1742819163281.pngGeorgeEard_2-1742819172037.png

     

     

    Show Less
Leaderboard

Customer Story

Optimizing Food Relief with Qlik

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.

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!