Hi All,

I have a measure that returns the date of the earliest gift given by a person (ID) with the unique identifier 'PAT':

=Min({<UNIQUE IDENTIFIER]={'PAT'}>} [DTE])

Now, I would like to create a measure that returns the date of the earliest gift made AFTER the one calculated above for the same person (ID). To do this, I am trying to Aggregate by ID within set analysis as follows:

=Min({<[DTE] = {">$(=Aggr(Min({<[UNIQUE IDENTIFIER]={'PAT'}>}[DTE]),[ID]))"}>} [DTE])

However, this results in null values for every ID.

I find this strange since when I test the Aggr() function outside of a Set Analysis, it returns the date I expect. But when I put it in the Set Analysis, it results in the Preview looking like:

=Min({<[DTE] = {">-}>} [DTE])

Does anyone know why this is? Is Aggr() not allowed within Set Analysis?

Thank you very much for any help!

Hi,

I want to config proxy parameter to comunicate since harvesting server in windows with Talend Cloud Data Catalog.

Exists any configuration in harvesting server?

Hi

How does Windows UI replicate Server work when it automatically links with Active Directory? Does it use any specific protocol, or how does this linking?

Thanks

Just published — a new app in the Qlik Gallery! It lets you explore the results of U.S. presidential elections from 2016 to 2024 in depth, using a variety of visualizations — from maps and bar charts to decomposition trees and circular gauges.

Dive into voting patterns, candidate performance, third-party impact, and more — all the way down to county-level granularity. Yes, Daenerys Targaryen and Donald Duck even make guest appearances.

👉Check out the app on Qlik Gallery — and view it live or grab the QVF!

Tried it? Liked it? Found something surprising? We'd truly love to hear your thoughts — feel free to drop a comment right there! We’re actively working on the app, planning to add more visuals and extend the dataset back to George Washington — so your feedback is genuinely golden!

Hello,

I am facing an issue when using the same file for user distribution list in two tasks.

1. I have a task that doesn't have any filters at task-level and

2. I have another task that has filters at the task-level. 

I am using an excel file to maintain the user distribution list and assigned a filter to myself that corresponds to the filter in the 2nd point above. I am using this same file for both the tasks above and what I noticed is, even though there are no filter at task-level in the 1st one, I got a report with the reduced data as per the filter from the excel file.

I want the task to apply the filters to my name only in 2nd task and not apply for the 1st task. Any suggestions on how to achieve this?

Thank you,

Apoorva 

Hello,

Not sure if there is a difference in QlikView to Qlik Sense for Set Analysis. The example below should force the filter to always select the flag 1 and 0 regardless of a user interacting with the IsInNetwork filter then adjust the total to the other filters such as date or region or sales person.

sum({<IsInNetwork={'1','0'}>}Quantity)

If I set to this I get and the user updates the IsInNetwork filter the total changes to the selected flag to sum({$<IsInNetwork={'1','0'}>}Quantity)

Hi,

in the last 30 days, I had on two difference Qlik Sense Server, one was a customer server and the second our internal development server, the same error ERR_CONNECTION_REFUSED.

A short look in the logs I found this indicator for corrupted certificates "Starting proxy, waiting for certificates to be installed" 

 After following the instructions of How to recreate or just delete certificates in Qli... - Qlik Community - 1712692 it works fine.

But now to my question is there any plausible explanation for this issue or is there a way to find the cause of this error?

Best regards Anh Toan

Hello,

I am trying to connect Qlik cloud to SharePoint site and fetch data from one of the excel files in the site. I was able to successfully establish the connection  however when I click on "select data" in the connection I am getting the following error message. Has anyone come across this issue?

P.S.: I do have access to the SharePoint site and the file I am trying to fetch data from.

Any help on this is greatly appreciated!

Thank you,

Apoorva

Talking this through to find the best way to solve the issue I am having.  We have a large app that is being moved from Prem to Cloud.  The app has at least 1,300 fields.  None of the fields were assigned a data type in Prem and somehow managed to work.

In the Cloud, the fields all have a Schema Data Type 'assigned' I'm assuming by Qlik Cloud and it's wrecking havoc in the application.  Is there any way to do an analysis on the application itself to see each field, what data type is was assigned?

There's a lot of build here, and I'm trying not to miss anything.  We also have the Document Analyzer tool, but it's not quite getting us there.

Suggestions?