Hi Team,

I want to display monthly analysis in bar chart where every month shows last 12months of sales. Want to create last 12months field  for every month in backend .
example : Jan 2023,Feb 2023,March 2023,April 2023 these are my month dimension values in bar chart

Jan 2023 means it has to show Feb 2022 to Jan 2023 sales sum

Feb 2023 means it has to show March 2022 to Feb 2023 sales sum

March 2023 means it has to show April  2022 to March 2023 sales sum

April 2023 means it has to show May 2022 to April 2023 sales sum

like that I want to show in bar chart.

Please anyone help me to resolve this it is an urgent requirement in my project delivery.

Regards,

Anusha 

Hi,

A customer is trying to build a QlikEntity Report from Qlik Sense on prem, but can't seem to find the object id in the list of the available objects.

It looks like there is a hard limit on how many objects the interface can show in the drop down menu when creating the report, and we're not able to search for anything beyond the last value in the list.

e.g. in the screenshot you can see the list ends with object id "8*******" something, but we know as a fact from the application interface that we have many object ids starting with "c****".

Do you know of any such limitation? How can we work around this limit?

Hi everyone,

I have a task in Qlik Replicate with target Databricks Lakehouse (Delta). Recently, many tables have been suspended due to the following errors:

• "Performing 'update' operations in "Transactional apply" mode is not supported by Databricks Delta"
• "Performing 'insert' operations in "Transactional apply" mode is not supported by Databricks Delta"
• "Performing 'delete' operations in "Transactional apply" mode is not supported by Databricks Delta"

The problem is that the task has always been set to "Batch optimized apply". Does anyone know why this is happening?

Thank you in advance for any insights!

Hi.  Is there a way to get an export of the QMC tasks and the associated security.  

So Task Name\App Name\Stream Name and all users or groups that have access to the associated Stream.

Thanks.

Hello qlikers 

I am trying to develop a planning model in script, currently i have certain constrains ...

right now I have a table as below

now i want to calculate optimized run time through loop by using the below condition and logic

Condition: sum (Current Optimized Run time) < Available_time_Perday 

Logic to run : current Optimized Run time + Run time 

stop condition: sum (Current Optimized Run time) > Available_time_Perday 

and need to load the output in Optimized Run time column against respective Item

Hi,

I have a table with four dimensions, and I want to display only the Top 10 rows based on the largest values in one of those dimensions (let's call it Column X).

My goal is to:

• Sort the table by Column X (descending)

• Show only the top 10 values by Column X

• Keep the table dimensions-only (no visible measures)

However, I’m running into a few issues:

• The "Limitation" option is disabled when using only dimensions.

• If I use Column X as a measure, it requires me to choose a dimension to group by, which doesn't give the correct granularity for my use case.

• The only workaround I've found is to use Column X as both a dimension and a measure, then apply a limitation — but this displays Column X twice, and there’s no clean way to hide the extra column, which feels like a clumsy solution.

To complicate things further, I plan to apply this approach in another table where I’ll also need to filter one of the dimensions beforehand, so I want a reusable and clean method.

Is there a way to filter a table to the top N rows based on a dimension’s numeric value, without displaying the ranking field or duplicating columns?

Thanks!

Afternoon all

We have just changed our fiscal year to a 4-4-5 year where the start of the fiscal year is the last Monday in March unless 1st April is a Monday then the start date is 1st April.

I have been scouring the knowledge library and can't find an answer to how I can incorporate this into the autocalendar.

I was hoping that getting this into the autocalendar would be the easiest way otherwise I will need to change all my apps.

Any help would be greatly appreciated.

Hello,

I'm publishing some apps in Qlik Cloud, (I'm using the functionality : right click on the Dev version in Shared Spaces / Publish). Sometimes images are displayed in the Production Management Space, sometimes not ? 

Can someone helps me to understand the logic ? 

Regards