Good morning,

I need some help with this expression.

My table has unique Invoice numbers, I join it with another table to get meteringpoints.

I add all this with customer information in a table format in Qlik.

I need to show in one line, one invoice , with many meteringpointnumbers. To be able to do this I use ''concat'' the meteringpointnumbers. But it seems not to be working.

Am I doing something wrong?

Code:
Concat(Distinct MeteringPointnumber, ', ')

Thanks

Theresa

Hi,

I've been using it very well since the Window function was added.
I wonder if the window function or the group by consumes more resources.
And what functions perform faster when loading data?
I don't know the difference because my test data capacity is small.

Reply, Thanks!

Hello everyone

I am using Talend Data Integration Job to read the following Excel which has 3 rows and 88 columns:

But only part of data(2 rows and 17 columns) can be read, the first row and part of columns lost after read by using dynamic schema.

By the way, if I define 88 string column in the schema , I can read the all data.

Thanks in advance.

I have a field [Evidence Review] which contains dates (in this format: 4/25/2025 12:00:00 AM)

I want to be able to count the number of dates where the review is due in the future.

I am using the following, but getting zero.

=Count({<[Evidence Review]={">$(=Today())"}>} [Evidence Review])

Thanks

Mark

Hello,

I have a question regarding the requirements for automated provisioning of Qlik Sense SaaS.

In the help it is stated that P2 or higher license is required, however according to Microsoft licensing requirements, P1 can also be auto-provisioned.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/auto-provisioning-configure-scim-in-azure.htm
-----------------------------------------------------------
Microsoft Entra ID with a P2 subscription or higher (formerly Microsoft Azure Active Directory Premium P2)
-----------------------------------------------------------

https://www.microsoft.com/en-us//security/business/microsoft-entra-pricing
-----------------------------------------------------------
Identity governance>Automated user provisioning to SaaS apps>on
-----------------------------------------------------------

Why do we need a P2 or higher license?
This is a costly area, so I would appreciate the information.

Thank you in advance.

Hello,

I am trying to connect Copilot on Microsoft Copilot Studio with QlikInsight Chat, and I am attempting to use an HTTP request to access Qlik Insight Chat. What URL can I use? /api/v1/questions/actions/ask is the endpoint. Has anyone already worked on integrating Microsoft Copilot with Qlik Insight Chat? I want my Copilot to understand users' questions, their intents, and present insights through Insight Chat capabilities.

I have an output like this Given below :

load * inline [

field name

potato

radius

beans

potato

carrot

mango

grapes

orange];

by using pick and match I want output like this ;

field name      category 

potato            vegetable

radius             vegetable

beans              vegetable

potato              vegetable

carrot              vegetable

mango           fruit

grapes           fruit

orange         fruit 

 here need to separate the groups by using pick and match   

please anybody help 

Hi guys，

     I have an excel with 12 sheets of data. How should I set a date range parameter and then load the first 12 months of the current month's data through a SQL on qlik sense?

    Please help, thanks！！！