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:

• Ad and Pop-Up Blockers can block the clues, disable them to participate
• When searching.... be patient! It might take a second for the letter to load.
• Look around for the letter on the page, they can be found anywere on in the white space of the page 
• Use the comments in this post for help or ping us!
• Please do not post the answer in the comments
• Note: You must be logged into your Qlik Community account in order to participate

Now, for the fun! Here are the clues. Good luck!

1. Find the group where women speak, their stories strong, their spirits unique.
2. Not grounded by wires, not stuck in the ground— Find the forum where your data’s future is cloud-bound.
3. Where innovation is set in motion, and this new solutions blog stirs the ocean.
4. Not the present, not the now— find the forum where old discussions take a bow.
5. Where chit-chat flows (like water, hint hint!) and topics vary, From tech to fun and community commentary.
6. To uncover your next letter, navigate to the hub that maps every Qlik event across the globe.
7. New roles await with every scroll, Find where Qlik jobs are the goal.
8. If you need answers, tools, or tips, visit the hub where all Qlik resources sit.
9. From learners fresh to seasoned pro, this blog helps your knowledge grow.
10. Each month, a featured name takes the stage, recognized for insight well beyond their age
11. For walkthroughs, demos, and technical flair, look where users do more and share.
12. Look for the notes that track what’s new, what’s fixed, and what’s improved—your letter lives among the new release updates.
13. For academic users to see, this program makes Qlik learning free.
14. Where bright ideas get a spark, and suggestions leave their mark, go here to see what this program is about.
15. Looking for answers? I’m the bar that loves questions — click the 🔍 icon to find me! Hint: the icon is on the homepage or find a similar button above
16. It’s not a trophy or a like, but it tells the world: ‘This one’s right! Submit answer to riddle here Hint: You can find the answer on this post but be sure to submit the answer using the link above
17. See a post that echos your own? Click this to say "You're not alone!" Submit answer to riddle here Hint: You can find the answer on this post but be sure to submit the answer using the link above
    
    

Do you have all the letters? 

Submit the final phrase here 

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.

Architecture Overview:

• 1st Tier (Extraction):

  • I have already set up incremental refresh in the extraction layer. Data is loaded incrementally from the source and stored in QVDs. This part is working fine.

• 2nd Tier (Data Model):

  • Data in this layer is loaded from QVDs created in the extraction layer. This is where I’m looking to set up incremental loading for optimized performance and reduced load times.

  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):

  • The dashboard layer uses a binary load to load the data model from the 2nd tier.

  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!