Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Welcome to our first-ever Qlik Community Scavenger Hunt! We’ve hidden secret letters all around the Community, and each clue below will point you toward a different location in the navigation. Follow the trail, collect every letter, and crack the final phrase to reveal the mystery phrase. Submit your answer for a chance to score some exclusive prizes!
Ready to get started? Here's some helpful tips:
Now, for the fun! Here are the clues. Good luck!
Do you have all the letters?
When you create a new App this is what gets created in the script section:
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET FirstWeekDay=6;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='en-US';
SET CreateSearchIndexOnReload=1;
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';
I want to add a line that is basically a $(Must_Include) statement that loads a controlled standard QVS file, that will force our script standards during App creation across all Apps.
What file & location do I need to add this logic?
Hello
I have a barchart with Fiscal year as the dimension and I got an expression
the fiscal years in the data are the following :
FY.23, FY.24, FY.25, and FyY.26 for actuals and FY.23, FY.24, FY.25, FyY.26, FY.27 for budget and forecast
I want to color the bars gradually from Fy.23 as dark gray, then this color would be brigther for Fy.24, brigher for FY.25 than Fy.24 but Green for Fy.26 (this for the actuals)
while for budget I want the same for 23,24, and 25, and finally Fy26, and 27 are both colored green
Kindly advise on how to accomplish this knowing that next year we'll have data for FY.28 and thus FY.27, and FY.28 would be green
is this feasible?
Hey Guys,
I had a chance to use our new MPC server and I am blown away.
Let me know how you plan on using Qlik MCP Server when it is available.
"AI is transformative, but it’s only as good as the data it can access and the means it has to unlock it. Qlik’s MCP server provides a full set of tools that allow external LLMs to tap into Qlik’s unique capabilities for data and analytics—so AI can take advantage of our data products foundation and analytics engine to deliver powerful insight and automate tasks and workflows.
Register your interest and be one of the first to try Qlik’s new agentic AI capabilities." https://pages.qlik.com/MCPInterestEAP.html
Create a new sheet and a interactive dashboard:
Hi everyone,
I'm developing a Route in Talend Studio.
It's fairly straightforward: the route must copy text files (*.txt) from one directory to another.
The directory from which the txt files must be copied has other types of files, as well.
How do I configure the cFile component so that is copies only the text files (*.txt)?
Thank you.
Hi,
I have a pivot table in which I am showing top 10 Clients and remaining in "Others". Clients that are bucket in "Others" category are shown in Text and Image box below the pivot table as seen in below image. Currently they are showing in alphabetical order. User wants them to be sorted based upon rank.
How can i achieve that?
Below is the formula used
=if(GetSelectedCount([Currency])=0 or Currency='EUR',
concat(
distinct if(
aggr(
rank(
Sum({<CSDR_Detection_Date_MonthEnd={'$(=$(vEndDate_1))'}>}Positive_EURAmount),1,1
),
CSDR_Counterparty_Name
) >= 11 and Positive_EURAmount<>0,
CSDR_Counterparty_Name
),
', '
),
concat(
distinct if(
aggr(
rank(
Sum({<CSDR_Detection_Date_MonthEnd={'$(=$(vEndDate_1))'}>}Positive_USDAmount),1,1
),
CSDR_Counterparty_Name
) >= 11 and Positive_USDAmount<>0,
CSDR_Counterparty_Name
),
', '
)
)
Hello everyone!
I'm trying to run predictions using the new Qlik Predict module, but since this morning I've been encountering the message Unexpected Error Occurred when I run the deployment Time Series model.
At first, I thought the issue was with my apply dataset, but I also tried running the Sales Prediction exercise from the official documentation and faced the same error.
I tested both with and without the future variable, but the result is always the same.
Any ideas??
Thanks.
Good day Qlik Community!
I have a new video available on the Data Voyagers YouTube channel. In this video, I interact with Qlik Answers directly from Claude Desktop using Model Context Protocol (MCP), a revolutionary technology that connects multiple APIs to LLM tools. Check it out, it is super cool!
Watch it here and, if you like, please share it.
Also, help us by subscribing to the Data Voyagers YouTube channel.
Qlik Answers MCP with Claude Desktop - YouTube
I am using a REST Connection and the token expires each hour, therefore I am using sub function to create a subrutine for the token table and after I use the call function to bring the subrutine, nevertheless the token doesn´t renew and 1 hour later I have the error in code because of expire time.
I appreciate if someone could help with this issue.
Below you will see the code
Use of sub function:
I use the Call Function:
Hi Qlik Experts,
I’m currently working with a three-tier architecture in Qlik Sense and I’d appreciate any guidance on how to set up incremental load in both the 2nd tier (Data Model) and the 3rd tier (Dashboard) layers.
1st Tier (Extraction):
2nd Tier (Data Model):
Challenge:
How can I implement incremental logic in this tier to avoid loading the full dataset every time? I want to ensure only new or changed data from the QVDs are loaded into the data model.
3rd Tier (Dashboard):
Challenge:
I know the binary load takes the entire data model into the dashboard app. Is there a way to optimize or implement an incremental approach here? Or would I need to rely on partial reloads or some other strategy?
Any suggestions or best practices for setting up incremental loading across these tiers would be greatly appreciated!
Thank you for your time and help!
FREE TRIAL
Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!
Register between December 1–7 and stack an extra $150 off on top of the existing $500 early bird savings. Use code: CYBERWEEK.
Trends 2026 Alert! Plug into this rewired framework for driving ROI from AI.
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader.
With Qlik Public ILT Passport, embark on live sessions with our top trainers — helping you grow faster and get the most out of Qlik. See where your passport can take you.
Take advantage of this ISV on-demand webinar series that includes 12 sessions of detailed examples and product demonstrations presented by Qlik experts.
Your journey awaits! Join us by Logging in and let the adventure begin.
Afcons Infrastructure partnered with Qlik to unify its data and build dynamic dashboards, reducing review times from weeks to hours and enabling on-demand reporting across its global operations.
By implementing Qlik Analytics, Atria Convergence Technologies improves insight into churn, revenue, and downtime, driving faster decisions and more proactive customer support.
Hydronorth uses Qlik to replace disconnected data systems with a single source of truth, improving alignment, speeding up decisions, and reducing manual work.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?
You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.
Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.
You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.