I have an expression which is given below:

(Sum({<Year={$(=Max(Year))},Company={"ITC"},DTNo={$(=Min(DTNo))} >}Contr)

/

Sum({<Year={$(=Max(Year))},Company={"ITC"},DTNo={$(=Min(DTNo))} >}Volume))
/1000

Please let me know is InputSum works here because in a single expression InputSum is working but in that type of calculation logic it's not working.

Hello team,

Currently, we suspect that two tasks are updating a single table simultaneously, but we are unable to identify which specific tasks are causing this conflict.
We are also considering the possibility that it is not displayed on the GUI.

Could you please assist us with the following two points?

1. Task Identification Method
We need to identify the exact tasks involved.
Could you please advise on the procedure or command to uniquely identify a task using only the following parameters?
- Partial Task ID (incomplete string)
- Target table name being modified
- Gateway information

2. Safe Termination Procedure for Non-GUI Tasks
If the identified task is not displayed on the GUI, what is the official and safe procedure (e.g., via CLI or administrative commands) to terminate ONLY that specific old task without impacting or disrupting other running tasks?

Best Regards.

A customer IT dept have asked that we start using Windows Managed Service Accounts (MSAs) or Group Managed Service Accounts (gMSAs) for the for the Qlik Sense and NPrinting Service Accounts.

I seem to remember that Qlik did NOT support this, but have been unable to find documentation about that.

What is the current situation?

Can we use MSA or gMSA?

Should we? meaning is this a recommended solution?

Or should we recommend against it?

Or is it impossible and cannot be done? 

Hello,

I have configured a Log Stream task that reads from an Oracle JDE database, followed by a unidirectional task that replicates the data to Snowflake in CDC mode.

Occasionally, auditing is enabled on some source tables. This causes the tables to be renamed with the _ADT suffix, while the base tables (without this suffix) are converted into views of the corresponding audit tables.

In these cases, Qlik Replicate typically suspends the replication of the table with an error message such as: “Object ids of table 'DTA.F0401' are not correct”. I assume this is because the CDC replication task cannot replicate views, which in fact are not even selectable in the Log Stream task. At that point, we manually add the table with the _ADT suffix to the replication tasks.

We would like to manage these changes in a way that minimizes the impact on consumers that need to read these tables in Snowflake.

I was thinking of:

• adding a table selection pattern to the replication tasks that automatically includes all tables with the _ADT suffix (using the %_ADT pattern under the relevant schemas and selecting the “use exact table name” option);
• adding a global rule to the unidirectional task to Snowflake that renames tables with the %_ADT suffix by removing the last four characters.

This way, both the _ADT table and the base table would be replicated to the same target table in Snowflake. Moreover, the conversion of the base table into a view would have no significant impact on the replication, since the corresponding _ADT table would be automatically included in the replication instead. In any case, I assume that the task logs would still indicate that the base table is no longer available as a table.

Could this be a good solution or is there a better best practice for handling this type of situation?

Thank you in advance for your support.

Best regards

Hi,

I have a button object on my sheet which sets 3 variable values then runs a reload of a very small script which is basically an IF statement based on the variable values. Every time I use it it performs as it should but I get this error message at the end. I've tried with full and partial reloads and get the same outcome.

Is there a way I can suppress this message or is there something I can do to stop the error?

Thank you

Hi everyone,

I’m trying to create a pie chart in Qlik Sense where I want to show both the value and the share for each category.

For example, I have a calculated dimension like this:

=If(
    region = 'REGION_A',

    If(
        buyer = 'BUYER_A'
        AND WildMatch(product_type, '*TYPE_01*', '*TYPE_02*'),
        'CATEGORY_A',

        If(
            (
                buyer = 'BUYER_A'
                AND NOT WildMatch(product_type, '*TYPE_01*', '*TYPE_02*')
            )
            OR buyer = 'BUYER_B',
            'CATEGORY_B',

            If(
                buyer = 'BUYER_C',
                'CATEGORY_C',

                If(
                    buyer = 'BUYER_D',
                    'CATEGORY_D'
                )
            )
        )
    )
)

My measure is:

Count(DISTINCT transaction_id)

Ideally, I want both the value and percentage to be displayed on the pie chart itself, or at least have both available in the tooltip.

What would be the recommended way to achieve this in Qlik Sense? Should I use a custom label expression, a second measure, or another approach?

Thanks!

Hi all,

Anyone has idea on how to fix this issue for sharepoint connector.
getting this error tried all the possible ways but still getting this error.

Kindly help

Hi everyone,

I've been working on improving the structure and performance of my Qlik load scripts and front-end apps, and I want to make sure I'm following the most current best practices... not just what was recommended 3 or 4 years ago.

I'm looking for resources that cover topics like:

• Load script structure and organization
• Data model optimization (star schema, avoiding synthetic keys, QVD layers)
• Performance tuning (set analysis efficiency, AutoNumber, incremental loads)
• Naming conventions and maintainability

My question to the community: What are the most current and reliable sources you use to guide your development decisions? For example:

• Official Qlik help docs or whitepapers
• Community blogs or specific contributors you follow
• YouTube channels or webinars
• Internal standards your team has developed

Any links, authors, or resources you'd recommend would be greatly appreciated. Thanks in advance!

Hi all, good evening,

I need to compare the cumulative sales between a year and the year before. This for many years stored in my database.

The sales had already been normalized by the month of each year.

This is the expression I created to generate the information for each year:

Aggr(RangeSum(Above(Sum(QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

And this is the generated graphic:

What I need is to created a new graphic that shows, for each year, the % growth between that year vs its last year, using the same rule (acumulated sales for each month).

I have already tried many solutions here in the topics, but I couldn't get the right result.

For exemple: Aggr(RangeSum(Above(Sum(QTY) / Sum({<[SALES YEAR] = {"$(=Only([SALES YEAR])-1)"}>}QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

Thanks in advance for any help.