Problem with Insight Advisor and date questions

[Kolorov]

Hi all,

I'm having a problem with Insight Advisor when I ask questions about dates.

For example, when I ask: "how many companies were registered after 1 January 2025?"

Insight Advisor creates this Set Analysis expression, which doesn't work:

={<[=Num(Registration Date)]={">=45658"}>} [Companies]

This code doesn't filter my data correctly, so the result is wrong.

Has anyone else had this issue or knows how to fix it?

Thanks for your help.

[rafaelencinas]

Hi @Kolorov ,

Let's check 

1 - The Field Registration Date is a date field ( based on Data Model Viewer you can check it ) 

2 - Technically, it's correct the set analysis, because when we convert Date to Num , the number is like your image

3 - Check if Insight Advisor uses Count function

4 - Companies may be repeated, if the dimension has values in lines, try to change you date model building keys that makes your companies unique.

Bye!

[Kolorov]

Hi @rafaelencinas 

Thank you for your dedicated help and for guiding me through the troubleshooting steps. I have followed all the suggestions and have also conducted some additional tests to isolate the issue. Unfortunately, the problem still exists on Qlik Cloud.

I wanted to share a full summary of my findings and ask if you might have any further ideas on what I could check.

Summary of Steps Taken So Far:

Based on your advice, I have fully configured the application:

1. Measure: My master measure correctly uses Count(distinct IdCompany).

2. Date Field: The Registration Date field is correctly typed as a date.

3. System Tags: I have removed the $numeric and $integer tags from the Registration Date field in the script. It is now tagged only with $timestamp and $date.

4. Logical Model: I have fully configured the Logical Model, including:

   • Placing the Companies master measure into a Group.

   • Placing the Registration Date dimension into a Group.

   • Creating a Behavior with a Prefer relationship to explicitly link the measure group with the dimension group.

After all these configurations, the problem on Qlik Cloud remains unchanged: the KPI card shows the total, unfiltered value, while the chart below it is filtered correctly.

Additional Test 1: On-Premise Environment

• I built a data model on a Qlik Sense Enterprise (On-Premise) server using the exact same QVD files as my source data.

• In the On-Premise environment, Insight Advisor works perfectly. The date filter is correctly applied to the KPI. This indicates the issue is specific to the Qlik Cloud environment.

Additional Test 2: New, Minimal Application

• To completely isolate the problem from my main application, I created a brand new, simple test application on Qlik Cloud.

• In this app, I loaded a simple inline table with a unique ID and a date for each row.

• Even in this minimal, clean application, I experienced the exact same issue. A natural language query with a date filter resulted in a KPI that ignored the filter.

Given all of these tests, do you have any other thoughts on what could be causing this behavior specifically on Qlik Cloud? Is there anything else you can think of that I could check or a different approach I could take?

Thanks again for all your help.

[rafaelencinas · Accepted solution]

Hi @Kolorov 

Maybe I found your problem:

1 - I created a simple database with companyes, but in my data, I have a field Company ID

2 - I asked your question in Qlik Cloud

3 - I've got this SetAnalysis

4 - I removed the Company ID from Data and asked the same question

For some reason, your Insight Advision ins't using distinct in your Analysis.

Try to Enable Busines Logic, Create Master Items, Create Tags to create  a reference to this Fields

Bye!