Hello Folks,

We are wanting to connect to an Acuity report with our QS Feb 2023 installation.  Acuity seems to have a two step process

1. Request an auth token that will expire in 30 seconds.

2. Use the said token to request the report.

As you see, this is a two step process.  My question is "Can Qlik connect in a 2-step fashion"?  I haven't seen it done, but would like to know if anyone else has solved such a problem.

Any help is greatly appreciated.

Hello Folks,

I have an NPrinting system that takes a while (~12 hours) to import all the users.  What should my next move be to shorten this process?  I know I can get a larger servers, but are there transaction settings on the DB that I might be able to look into?

Any help is greatly appreciated.

The import will also fail, complaining about a deadlock if that helps.

Hi,

I want to configure Oracle on premise only to load full load, but in the parameters of connection need put the asm parameter.

there are any way to configure parameter connection in oracle as source without asm and cdc.

Thanks

Hi Experts,

I have a requirement like need to clean cleanup more than 10 days qvds data with loading qvds data(records) into Qlik only using filename basis.

Below is the script to generate Daily qvds.

T1:
LOAD Date,

Date(Date,'YYYYMMM') as YearMonth,
Date(Date,'YYYY-MM-DD') as Day,
Product,
Sales
FROM
[D:\My Daily Prac\DAILY QVDS\01-01-2025.xlsx]
(ooxml, embedded labels, table is Sheet1);

let vm=NoOfRows('T1');

for i=0 to $(vm)-1;
let vFileName=peek('Day',$(i),'T2');

NoConcatenate
T2:
load *
Resident T1 where Day='$(vFileName)';
STORE T2 into D:\My Daily Prac\DAILY QVDS\$(vFileName).qvd (qvd);
DROP table T2;
next i;

Below Script help us to cleanup the qvds (loading qvd records data )

Set vQvdpath='D:\My Daily Prac\DAILY QVDS\';
Let vCurrentDate= DATE(TODAY(),'YYYY-MM-DD');
Let vDays90DaysAgo= DATE((TODAY()-10),'YYYY-MM-DD');

OldQvdFiles:
Load *,
FileName() AS QvdFileName,
FileTime() AS QvdFileTime,
'Daily' AS TYPE
FROM
[$(vQvdpath)*.qvd](qvd)

WHERE DATE(DATE#(MID(FileName(),Index(FileName(),'DAILY QVDS')+1,10),'YYYY-MM-DD'),'YYYY-MM-DD')<= DATE((TODAY()-10),'YYYY-MM-DD');

FOR i=0 to NoofRows('OldQvdFiles')-1
LET vCurrentQvdFile= Peek('QvdFileName',$(i),'OldQvdfiles');
LET vQvdFilePath='$(vQvdpath)' & vCurrentQvdFile;

TempTable:
Load *
FROM [$(vQvdFilePath)](qvd)
WHERE 0;
STORE TempTable INTO [$(vQvdFilePath)] (qvd);
DROP TABLE TempTable;
TRACE Cleared QVD File: $(vQvdFilePath);
NEXT i;

exit Script;

My Qlik secript is working like While loading data it is fecting records from each qvds and later is clean up but i want to cleanup the qvds withloading data from qvds and using only filename of the qvds.

It should not fetch the records like these when i load it.

It has to work directly like how temp table is loading when we are running the app

Note This can be fine in qliksense and and code has to build without OS commands and Any external scripts.

@sunny_talwar 

I have reviewed the following article: Qlik Cloud: How to set up Auth0 and map roles to g... - Qlik Community - 2474504 as it is similar to what I would like to do.

I am trying to setup a custom claim for email between auth0 and Qlik.

On the auth0 side, I have created a post login action that sets the custom claim: https://test.my-domain.com/email. All the testing on auth0 side shows this working as expected.

// key code in action

On the Qlik, I have successfully setup the Idp without the custom claim i.e. just using email.  In /api/v1/diagnose-claims, I see my custom claim with the proper value in the claimsFromIdp section.

The next step, I replace email in the claims mapping with https://test.my-domain.com/email,email .

It always chooses email not the custom claim. The custom claim is empty (but can be found in claimsFromIdp?).

I have checked "Email verified override". 

I have tried many things, nothing seems to get this custom claim to work.

Any help is appreciated.

Dear Team,

In our development environment, we have over 3000+ connections, and users are experiencing significant delays when accessing the Data Load Editor page. The page takes a long time to load the connections, and it freezes for several seconds during this process.

I have heard that there is a possibility to optimize this by loading only a subset of connections at a time. Could you please provide guidance or share an article on how to implement this solution?

Hi,

I want to configure in QCDI database Oracle 19c as source, but only want to work as full load.

What permission must be granted?

Its ok these ?:

SELECT ANY TABLE
SELECT all_indexes
SELECT all_ind_columns
SELECT all_constraints
SELECT all_cons_columns
LOCK ANY TABLE

thanks,

Hi,

I am using a Qlik cloud Trial version(student subscription) for learning purpose. I wan to try integrating OpenAI into qlik usin REST API, how to do that.