Hey,

Was wondering if anyone has ran into the following issue. 

I am  trying to find Closest date to another date while having multiple entries.

I calculate days between and filter for min datebetween, but the issue is that i get multiple min days when grouping for final table. first sorted does not work because a single customer can have multiple events with same days between usually 0. And i cannot think of any key that would work 

looks something like this: 

TMP:
NoConcatenate
LOAD
*
where DAYS_BETWEEN >= 0 ;
load*,
if(isNULL(days_between_TEMP),0,days_between_TEMP) as DAYS_BETWEEN;
load *, EVENT_DATE - RISK_DATE as days_between_TEMP
RESIDENT QUACK;

FINAL:
LOAD CUSTOMER_ID,
SCORE,
EVENT_DATE,
MIN(DAYS_BETWEEN) as DAYS_TO_RISK
Resident TMP
group by CUSTOMER_ID,EVENT_DATE,RISK_DATE,SCORE;
DROP TABLEs QUACK, TMP;

I have a pax flow forecast per date and time. the range per date is from 06:00 hours till 22:00 hours. For everyday, the forecast can be per quarter. I noticed that some quarters are missing for some dates.

I would like to have a table where each date has alle the quarters in the range from 06:00 till 22:00. which means 60 quarters per date. I am looking for a way/the best way to get this in my date, perhaps in some sort of date calendar which can be joined with the other table containing the pax flow per filter.

I think I would need a script which generates for all dates present in the forecast table, a table with alle the quarters, from 06:00 till 22:00.

Hi @john_wang / @Dana_Baldwin 

Can you please share how can we create authorization Object /QTQVC/RFC, from the user guide I don't see all the steps to create it. And why it is needed, also I am not able to search for some custom tables, is it due to not available of authorization Object /QTQVC/RFC ?

Thanks in advance!!

Regards,

Sukanya!!

Hi,

I'm trying to create defined functions to make some expressions more readable, but I can't find a workaround to not expand a $() using SET.

For instance:

SET someFunction =

(Sum(Aggr({<store= {$1}>} Revenue, store)) / Aggr(NoDistinct Only({1<key_calendar = {"$(=Floor(vToday - 1))"}, store = {$1}>} growth_idx), store));

When this function is loaded, it expands the set analysis "$(=Floor...)" and returns blank, as expected. Is there a way to delay the expansion to the front end? I've tried multiple things, like using Chr(34) for the " and Chr(36) for the $. They all come as text tho.

If you haven’t explored this year’s Qlik Data & Analytics Trends yet, now is the perfect time. The entire experience is available on demand — and it’s packed with insight, inspiration, and practical guidance to help you stay ahead of what’s coming in 2026.

Alongside the full trends reveal, you’ll also get access to the webinar with Dan Sommer, where he breaks down the biggest shifts shaping data, AI, and analytics — and what they mean for the year ahead.

What’s waiting for you:

• Trends 2026 Webinar — your deep dive into the biggest forces shaping data, AI, and analytics in 2026
• Bonus Video Content!
• AWS’ Chris McNabney, Director of Solutions Architecture, US ISV joins Qlik CMO, Chris Powell for a high-powered conversation on how to translate Qlik’s 2026 Trends into practical strategies that drive real results
• Responsible AI Fellow at Harvard’s Berkman Klein Center, Dr Rumman Chowdhury and Qlik's CTO, Sam Pierson and chat in-depth on the evolving data and AI landscape, and the essential skills that are needed to thrive in it today.

Whether you're evaluating AI capabilities, or modernizing your data foundation, this will give you a clear, actionable view of where the industry is heading.

Watch everything on demand here

I've created a tabular report template that uses data tables to create native Excel Pivot tables. The Pivot table structure is like so:

I need to have the report generate with Fiscal Quarter and PC Hier Level 2 collapsed. Is that possible?

Thanks,