Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 233,701 members
  • 3,715 online
  • 2,016,936 posts
  • 151,460 Solutions
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Null Value Background in Theme

    Hello - This is the CSS that is currently being loaded for a null background     .qv-st-data-cell-null-value { background-color: #f2f2f2; }       ... Show More

    Hello -

    This is the CSS that is currently being loaded for a null background

     

     

    .qv-st-data-cell-null-value {
        background-color: #f2f2f2;
    }

     

     

     

    I have updated my theme to contain the following

     

     

    .qv-st-data-cell-null-value {
        background-color: #ffffff !important;
    }

     

     

     

    However after updating/uploading my new theme I am not seeing my new style applied. I still see the style coming in from and being applied from common.css. Other styles from my theme are working, however my latest change is not.

    Any thoughts? Thanks.

    Show Less
  • forum

    App Development

    how to show percentage below numbers in bracket in single measure in pivot table...

    how to show percentage below numbers in bracket in single measure in pivot table in qliksense
  • forum

    Move to SaaS

    "Connecting" error happening frequently in Qlik Cloud Government QCG SaaS

    We have been seeing this error fairly often, for multiple users, in many different locations, on vpn and off vpn.  The error is similar to a timeout b... Show More

    We have been seeing this error fairly often, for multiple users, in many different locations, on vpn and off vpn.  The error is similar to a timeout but happens while the user is actively working in an app. The message shows at the top of the screen like shown below.

     

    Ken_T_0-1728399357765.png

     

    when this error happens, developers sometimes lose the recent changes to the script that they were working on.   we reported this to Qlik support but did not get any resolution, cause or workaround.

    Is anyone else seeing this situation in Qlik SAAS or in QCG?
    have you found any causes or workarounds?

     

    Show Less
  • forum

    Move to SaaS

    Qlik Sense Data Architect Certification 2024

    Hello, I'm having on 4th november   the QSDA2024Qlik Sense Data Architect Certification Exam - 2024English I wanted to have the list of all the requir... Show More

    Hello,

    I'm having on 4th november

     

    the QSDA2024
    Qlik Sense Data Architect Certification Exam - 2024
    English

    I wanted to have the list of all the requirement like the pdf document attached (it's an old one).

    With the certification evolving i don't want to miss anything.

    Will there be any qlik cloud related question for that certification ?

    Thank you

     

    Show Less
  • forum

    Move to SaaS

    Sentencia With

    En SQL puedo tener subconsultas con la sentencia WITH, pero Qlik no me las reconoce, alguien sabe como puedo hacer algo similar  WITH  "MAI" AS(SELECT... Show More

    En SQL puedo tener subconsultas con la sentencia WITH, pero Qlik no me las reconoce, alguien sabe como puedo hacer algo similar 

    WITH 

    "MAI" AS
    (SELECT
    "TBL_MOVIMIENTO_MERCANCIA"."ID_CENTRO" AS "ID_CENTRO",
    "TBL_MOVIMIENTO_MERCANCIA"."ID_MATERIAL" AS "ID_MATERIAL",
    "TBL_MOVIMIENTO_MERCANCIA"."ID_TIPO_MOVIMIENTO" AS "ID_TIPO_MOVIMIENTO",
    MAX("TBL_MOVIMIENTO_MERCANCIA"."F_CONTABILIZACION") AS "FUE",

    FROM "PRD_CON_INV"."INVENTARIO"."TBL_MOVIMIENTOS_MERCANCIA" "TBL_MOVIMIENTO_MERCANCIA"

    WHERE
    "TBL_MOVIMIENTO_MERCANCIA"."ID_TIPO_MOVIMIENTO" IN ('101' , '305' , '319' , '501' , '511','901')

    GROUP BY
    "TBL_MOVIMIENTO_MERCANCIA"."ID_CENTRO",
    "TBL_MOVIMIENTO_MERCANCIA"."ID_MATERIAL",
    "TBL_MOVIMIENTO_MERCANCIA"."ID_TIPO_MOVIMIENTO"


    )

    --------------------------------------------------------

    SELECT
    "PROD"."MAT_PADRE",
    "MAI"."ID_CENTRO",
    "MAI"."ID_MATERIAL",
    MAX("MAI"."FUE") AS "FUE_MAX"

    FROM
    "MAI"

    LEFT JOIN
    "PROD"

     

    ON ("MAI"."ID_MATERIAL"="PROD"."MAT_PRO")

    WHERE
    IFNULL("MAI"."FUE",0)<>0

    GROUP BY
    "PROD"."MAT_PADRE",
    "MAI"."ID_CENTRO",
    "MAI"."ID_MATERIAL"

    Show Less
  • forum

    Qlik Replicate

    Effect on Task Run Options when changing Streaming endpoint settings

    Hi Support,   I'd like to understand what effect changing the settings of a streaming endpoint would have on the task run options. If credentials are ... Show More

    Hi Support,

     

    I'd like to understand what effect changing the settings of a streaming endpoint would have on the task run options. If credentials are updated in the target streaming endpoint, would a full reload of the tables be required? Or would the task be able to resume processing of CDC?

    For example, if a Full Load + CDC task was streaming changes to an Amazon Kinesis endpoint, the task was stopped, and the access key and secret key of the Kinesis endpoint was changed, would the tables need to be reloaded?

     

    Apologies if this has been covered in a previous community article.

     

    Regards,

    Nak

    Show Less
  • forum

    App Development

    Cohort Retention

    I'm trying to get a retention data over time based on customer sign-up date. I have data as follows: Customer Start_Date Months_Active A 1/1/2024... Show More

    I'm trying to get a retention data over time based on customer sign-up date.

    I have data as follows:

    Customer Start_Date Months_Active
    A 1/1/2024 4
    B 1/1/2024 2
    C 2/1/2024 1
    D 2/1/2024 3
    E 3/1/2024 2

     

    I want to know how many active customers I had for each month number broken down by Start_Date. This is what the data should look like (the numeric values at the column headers indicate # of months post Start_Date, so '1' indicates 2/1/2024 for customers started on 1/1/2024)

    Start_Date count(Customer) 1 2 3 4
    1/1/2024 2 2 1 1 -
    2/1/2024 2 1 1 - -
    3/1/2024 1 1 - - -

     

    I was trying to find an expression formula that would take value in Months_Active at the top of the pivot table and count Customers whose Months_Active <= to that dimension value. I just can't get there. It's either the wrong approach or I just can't find the right combination of set analyses and functions to get me there.

    Any help will be appreciated.

    Show Less
  • forum

    App Development

    Table with customer retention by month

    Hi all, I'm here for a very common issue, retention rate. I want to show in a table the number of customers of the specific month and the number of cu... Show More

    Hi all,

    I'm here for a very common issue, retention rate. I want to show in a table the number of customers of the specific month and the number of customers that have bought in the specific month and in the previous too.

    I can only solve this problem at front end level, not have permission to access to load editor. Imagine that I have available a table for all transaction at CustomerCode and YearMonth level.
    Somenthing like:

    YearMonth CustomerCode Flag Buyer
    2024-01 20 1
    2024-01 21 1
    2024-01 22 1
    2024-01 23 0
    2024-01 24 1
    2024-02 20 1
    2024-02 23 1
    2024-02 39 1

     

    Resulting in:

    YearMonth # Customers # Retained Customer
    2024-01 4 -
    2024-02 3 2

     

    I'm looking to a formula that can be evaluated at row level, letting me compute for each row how many customer have bought in the row's Month and in the previous.

    Thanks,
    Davide

    Show Less
  • forum

    Qlik NPrinting

    Excel Conditional Formatting and Borders

    I have a chart in QlikSense and I'm exporting it to nprinting, but if I keep source formats, I can't add borders. If I deselect keep source formats, I... Show More

    I have a chart in QlikSense and I'm exporting it to nprinting, but if I keep source formats, I can't add borders. If I deselect keep source formats, I can add borders, but I lose the conditional formatting that comes from the app.

    Is there a way to 'keep source formats' for the conditional formatting to pass through, but be able to add cell borders? It doesn't seem like you can add the cell borders within the chart in QlikSense.

    Do not keep source formats:

    mlin_0-1728958275065.png

    Keep source formats:

    mlin_1-1728958325802.png

     

    Show Less
  • forum

    Design and Development

    How to build JSON using tWriteJSONField component

    Hello, I have build a JSON string using tWriteJSONField.  with resulting JSON as:{"PrimaryAddress": "1","AddressID": "E8BBEB79-7566-4731-BE57-E37F3A2... Show More

    Hello,

    I have build a JSON string using tWriteJSONField. 

    himanshup_0-1729007022539.png

    with resulting JSON as:
    {
    "PrimaryAddress": "1",
    "AddressID": "E8BBEB79-7566-4731-BE57-E37F3A2593EA",
    "Phone": "(705) 5551212",
    "Email": "test_Knock@john.net"
    }

    However, since I am new to this, I am not sure how to build the following (example) JSON using tWriteJSONField:

    {
            "Appointments": [
                {
                    "AppointmentBands": [
                        {
                            "AppointmentBandID": "E91E4849-5617-4C9C-BCB0-96F72EA169F4",
                            "Amount": 120.40,
                            "EffectiveDate": "2024-07-02T00:00:00",
                            "EndDate": "2025-06-30T00:00:00",
                            "AppointmentTypeCodeID": "P_MONTH_TYPE_5",
                            "FringeBenefitAmount": null,
                            "FringeBenefitSchemeID": null,
                            "PrimaryAppointment": "Y",
                            "Unique_ID": "D8FF7B12-71A2-476F-B",
                            "AppointmentID": "D55E54E3-FF72-4ACA-86A9-7F784076CC78"
                        }
                    ],
                    "AppointmentID": "D55E54E3-FF72-4ACA-86A9-7F784076CC78",
                    "CompensationPackageID": "0FB6ED82-65AC-4B98-BFB6-0E49BF2B1281",
                    "AssociatedOrgUnitCode": 14418,
                    "AppointmentTitle": "Data Analyst"
                }
            ],
            "CompensationPackageID": "0FB6ED82-65AC-4B98-BFB6-0E49BF2B1281",
            "Unique_ID": "D8FF7B12-71A2-476F-B",
            "StartDate": "2024-07-02T00:00:00",
            "EndDate": "2025-06-30T00:00:00"
        }
    Any guidance will be highly appreciated.
    Thank you.
     

     

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

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!