Hi,

we are using the Qlik Learning Continuous Classroom.

I would like to monitor the access and the courses taken by my colleagues.

I see there is the Usage Analytics App, but it requires a subscription administrator access level.

How can I check which account is our subscription administrator?

Can I get this permission for my account?

Thanks

Hi,

I have data like this and when we do the calculation like below it ends up with duplicates.

if(num([cal date])-num(today())>0 and confirmed='N',1,0) as "Review Eve"

expression: sum("Review Eve") gives duplicates

09-05-2024

Hello,

i have a strange behaviour on my QlikSense, on premise, installation: everything is working fine, in QMC i have no error on licence, even if i reload information from web, the analyzer and professional and user can log and work.

However i have a constant error in the log located in: ProgramData\Qlik\Sense\Log\Licenses

Around every ten seconds it report this couple of line

{"caller":"handler.go:53","errorMessage":"invalid license error, no license found, tenant not found","errorType":"LICENSES-ForbiddenRequest","level":"info","logTraceId":"7003c215e34da346b906beed9bcdb019","statusCode":403,"timestamp":"2024-05-09T09:37:40.8800623Z"}
{"audience":"","caller":"middleware.go:114","level":"info","license":"","logTraceId":"7003c215e34da346b906beed9bcdb019","message":"http request","name":"V1LicensesDefinitionGet","req.method":"GET","req.url":"/v1/licenses/definition?privileges=true&xrfkey=GFycs5f2YXBS8w15","res.statusCode":"403","subType":"","tenant":"","timestamp":"2024-05-09T09:37:40.8806126Z","userAgent":"nl-app-search"}

Do you have any idea how to fix this?

For context: Windows firewall is disable and the server, at the moment, reach everything on the net, included http://license.qlikcloud.com/

Thanks a lot

The version is the latest Qlik Sense February 2024 Patch 3 - 14.173.6

Hi all,

I am trying to access files in a folder on a remote server.

The first issue was that I could reach the folder but could not see the files - this was solved by giving the Qlik user full control over the files.

Now the issue is that when I press one of the files to open it and choose whatever I need - nothing happens. it does not response.

The user has "Root admin" role.

Any ideas?

Regards.

I have an application that is essentially a flat table. The columns are name, user_id, company, city, state. I want users to be able to input a list of names in the variable input and then fuzzy match those names with the names in my data set. I believe there isnt an actual tool but would love a creative way someone solved this problem

Hello Everyone, I have a question for Qlik sense. I have a table that has a Date column and a quantity column. I need to create a master Item that calculates the month to date quantity. 

I am attaching an Excel file that has those 2 columns and also the column of the MTD that I need to calculate as a master item

Can you please Help ?. Thanks

I have some problems with SAP SQL Connector to SAP HANA S/4. 
I'm not able to alias fields, and this cause me problems with left join. 

This is the query that i'm trying: 

SQL
SELECT
U1~UMREZ   AS A1,
U1~UMREN  AS A2,
U2~UMREZ  AS B1
U2~UMREN  AS B2
FROM ZQGCZ AS Z
LEFT JOIN MARM AS U1 ON U1~MATNR = Z~MATNR AND U1~MEINH = Z~MEINS 
LEFT JOIN MARM AS U2 ON U2~MATNR = Z~MATNR AND U2~MEINH='TO';

Hi Everyone,

We have a problem with qlik sense and AD integration. Could you comment on how Qlik parses groups with the same givenname in AD?
In our checks, QMC returns one of them as a direct group name and the other with CN=xxx,OU=yyy…..

Thanks

Hello All, 

We need to connect  to a Finance application named Intacct (https://www.sage.com/en-us/sage-business-cloud/intacct/)

Today they are using an ODBC connection from CDATA that it is quite expensive and they requested me is there any other way connect to extract info from Intacct. 

Please help.

#help Talend Data Integration Talend Studio Talend Cloud