Hi Folks,

Previously have raised one thread regarding linking of existing dates (Text format) with Dual dates(Num) but i haven't found any solution for it.

Reposting it here :

I have recenlty created the date field using Dual to show the dates in descending order in filter pane and selection tool both and its working well.

Dual(Date1,-1*Date1) giving result 2025/10

While i tried to incorporate this changes into my existing dates i.e Date which is also holding dates in 2025/10 format but in Text format its not working.

Let say i wanted to show YTD and Rolling 12 months data when clicking on action button.Its wokring fine and getting associated and selecting with green color.

R12 Logic:

=year(addmonths(TODAY(),-2))&'/'&if(num(month(addmonths(TODAY(),-2)))<10,'0','')&num(month(addmonths(TODAY(),-2)))&';' &year(addmonths(TODAY(),-3))&'/'&if(num(month(addmonths(TODAY(),-3)))<10,'0','')&num(month(addmonths(TODAY(),-3)))&';' &year(addmonths(TODAY(),-4))&'/'&if(num(month(addmonths(TODAY(),-4)))<10,'0','')&num(month(addmonths(TODAY(),-4)))&';' &year(addmonths(TODAY(),-5))&'/'&if(num(month(addmonths(TODAY(),-5)))<10,'0','')&num(month(addmonths(TODAY(),-5)))&';' &year(addmonths(TODAY(),-6))&'/'&if(num(month(addmonths(TODAY(),-6)))<10,'0','')&num(month(addmonths(TODAY(),-6)))&';' &year(addmonths(TODAY(),-7))&'/'&if(num(month(addmonths(TODAY(),-7)))<10,'0','')&num(month(addmonths(TODAY(),-7)))&';' &year(addmonths(TODAY(),-8))&'/'&if(num(month(addmonths(TODAY(),-8)))<10,'0','')&num(month(addmonths(TODAY(),-8)))&';' &year(addmonths(TODAY(),-9))&'/'&if(num(month(addmonths(TODAY(),-9)))<10,'0','')&num(month(addmonths(TODAY(),-9)))&';' &year(addmonths(TODAY(),-10))&'/'&if(num(month(addmonths(TODAY(),-10)))<10,'0','')&num(month(addmonths(TODAY(),-10)))&';' &year(addmonths(TODAY(),-11))&'/'&if(num(month(addmonths(TODAY(),-11)))<10,'0','')&num(month(addmonths(TODAY(),-11)))&';' &year(addmonths(TODAY(),-12))&'/'&if(num(month(addmonths(TODAY(),-12)))<10,'0','')&num(month(addmonths(TODAY(),-12)))&';' &year(addmonths(TODAY(),-13))&'/'&if(num(month(addmonths(TODAY(),-13)))<10,'0','')&num(month(addmonths(TODAY(),-13)))

E.g 2025/10;2025/09;2025/08;...2024/11

Mike Tarallo is back with another Friday livestream — and it’s a good one! He’ll be showing different ways to access and prep your data in Qlik Cloud using tools like the Data Load Editor, Data Catalog, Table Recipes, and more.

Catch all the details and jump into the thread here!

The new Content Monitor loads from the APIs and logs to present key metrics on the content, configuration, and usage of your platform, allowing administrators to understand the evolution and origin of specific behaviors of the platform.

• Basic information can be found in Content Monitor | help.qlik.com  
• Each sheet in the Content Monitor includes an About text box to describe its content. 
  

This new monitoring app comes pre-installed with the latest version (November 2025 onwards) of Qlik Sense Enterprise on Windows.

If you are running previous versions of Qlik Sense Enterprise on Windows, the Content Monitor is also available on Qlik's Downloads page here: Content Monitor (download page) - note, this must be manually installed and a weekly reload is recommended.

Hello I have the following table:

I have selected the above project names;

the expression is sum(amount)
now total amount is 35.79 which is correct
but in the expression I want to eliminate the projects whose parent_project_pfolio_1_id = 1 and pfolio_level_id = 18
so the last row shouldn't be calculated and thus the total should be 34.73 since the last row shouldn't be counted
so I wrote the below expression:

sum(

{$-<parent_project_pfolio_id_id = 1, pfolio_level_id=18>}

amount)
and I got the following result:

the total is correct however the results came under null scenario type and null year
but if I exclude the SUPPORT-BSRM_BSM project I get the fine result:

so how can I get the correct result when the project to be excluded is in the current selections set of data?
why when that project is available the other projects to be included come under null year and null scenario?

knowing that all the fields except the year and scenario are in the project table (dimension) linked to fact table via prjh_key and the year is part of the calendar table linked to fact table via the month_key and the scenario is part of the scenario table linked to fact table via scenario_key

kindly advise

I am trying to export information to excel and click format when exporting. When I open the Excel file I get a message to say: We found a problem with some content in Filename.xlsx. Do you want to try to recover as much as we can?

The error meaage is as follows-

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error913480_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\braham.edwards\Downloads\Comms to Pay - Month 1(zMKPSJ) (1).xlsx'
</summary><repairedRecords><repairedRecord>Repaired Records: Format from /xl/styles.xml part (Styles)</repairedRecord></repairedRecords></recoveryLog>

How do I find out what column is causing the problem?

I have my list of data (Branch, Item, Customer) ranked in a pivot table based on the field "ext_price_gross", which is working just fine.  What I'm looking to do is to then give me a percentile based on these rankings.  I'm figuring that I have to do something like:

1 - ((ranking value) / (max of total ranking)

If my Ranking Value that works is: Rank(sum(ext_price_gross),3,1)

then how do I get the max of the rankings?

If I have 100 things ranked, the 5th ranked thing should return 95% (1 - (5/100))

Thank you.

I’ve been working with the Qlik APIs for narrative responses and noticed something I can’t resolve.

• Current API in use: /api/v1/questions/actions/ask
  Docs

• Previously used API: /api/v1/nl/query
  Docs

→ These endpoint doesn’t seem to provide an option to pass filters.

The issue is that I want the narrative response to reflect user-applied filters, but currently the APIs only return unfiltered data values.

Hello
I'm working on a dashboard with huge data
I have to calculate the man-days 
is there a difference between the below syntax?
{<condition_1>-(<condition2>+<condition3>)}
sum(mandays)

and 
{<condition_1>}
sum(mandays)

-

{<condition2>}

sum(mandays)

-

{<condition3>}
sum(Mandays)

Hello
I have a pivot table with several expressions
I will show you 2 expressions 1 and 2 written in two different ways but they return the same correct result

expression 1 is not distributed on any dimension
while expression 2 is distributed on any dimension

but expression 2 is very slow when used with the remaining expressions in the pivot table
while expression 1 is much faster

Expression1:
{
$
-<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>
-<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>
}
sum(SPENT_MANDAYS)

Expression 2:

(
sum(SPENT_MANDAYS)
-
{<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>}
sum(SPENT_MANDAYS)
-
{<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>}
sum(SPENT_MANDAYS)
)

kindly advise on why expression 1 is alwys under null scenario type