Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
Item | QTY_on hand | Ctime | Plan | Run time | Available_time_Perday | Optimized Run time |
Item-1 | 1718 | 0.5 | 576 | 288 | 1224 | ? |
Item-2 | 1323 | 0.5 | 576 | 288 | 1224 | ? |
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 trying to upload a parquet file from talend studio into qlik cloud using the tQlikOuput component, i've succeded to upload it into my personal space, but i need to use a different space, does anyone can give me any suggestion on how to achieve it if possible?
Thanks, in advance,
Vincenzo.
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
In my chart below I've applied filters in a table to only show data for a certain set of values. This seems to throw off the sort (Max(Yearmonth) ascending). Any advice on how to either hide the Yearmonth values not showing data or how to force it to show the YearMonth in order is appreciated.
Yearmonth is calculated from a date.
Workshops. Certifications. And Disney's Animal Kingdom® Theme Park. Only at Qlik Connect. May 13 - 15.
Join us online May 14-15 to explore the future of data, analytics, and AI — streamed live from Orlando.
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!