May 2025 qlik sense update broke part of window function
plan_query: LOAD friday_date, project, funding_type, start_dt, planned_mandays, window(count(DISTINCT friday_date)) as num_weeks, window(count(DISTINCT project)) as num_projects FROM [lib://AttachedFiles/Over Time Upload FY26.xlsx] (ooxml, embedded labels, table is [Unpivoted Execution Plan]);
Before the May 2025 qlik sense update this query worked as expected in the data load editor. But now num_weeks returns 0 for every row. This seems to be the case if I do something similar with any numeric field. friday_date is a date/numeric field. However num_projects works just as expected and that seems to be because project is a string field, not numeric. It correctly returns 29 for every row in this case. I know there's workarounds to this specific case. But in more complicated cases, the work arounds become messier. So I'm wondering why this issue was introduced and whether there's a plan for it to be fixed.
