Recent Discussions
-
Read SQL T-log backups from Azure Blob storage as Alternate backup folder in the...
How to set the SQL T-LOG backups from the Azure Blob storage as Alternate backup folder for CDC read changes from backup logs only. If no, when would ... Show MoreHow to set the SQL T-LOG backups from the Azure Blob storage as Alternate backup folder for CDC read changes from backup logs only. If no, when would this be for GA and are there any alternate solutions immediately available to access the backups from the Azure Blob
-
Qlik NPrinting API's inside Qlik Sense load script, Extracting Session cookie
@Marc I have been following a document Publish by Qlik about how to use Qlik Nprinting API's inside a load script. Se attached. I have successfully m... Show MoreI have been following a document Publish by Qlik about how to use Qlik Nprinting API's inside a load script. Se attached. I have successfully managed to set up the rest connections and managed to get the code on Page 12 of the document to work properly as shown below.
//Connect to NPrinting using the GET REST Connection
LIB CONNECT TO 'NPrinting REST Login (qtsel_gpr)';
//Perform a GET call to NPrinting NTLM login API
RestConnectorMasterTable:
SQL SELECT
"Set-Cookie",
"__KEY__response_header"
FROM JSON "_response_header" PK "__KEY__response_header";
[_response_header]:
LOAD [Set-Cookie] AS [Set-Cookie]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY__response_header]);
//Extracts session cookie from the API response
let vCookieRaw = Peek('Set-Cookie',0,'_response_header');
let vCookie = TextBetween('$(vCookieRaw)','Secure,','Path=/',2);
DROP TABLE RestConnectorMasterTable;When the code runs it manages to get the RAW cookie data and store it in the variable vCookieRaw but it's not successfully extracting the session cookie data in the variable vCookie. The contents of the variable vCookieRaw I have listed below. I need to adjust some how the delimiters in the text between function to extract the session cookie. So I need figure out how to identify the session cookie in the raw cookie data so I can extract it.
'NPWEBCONSOLE_XSRF-TOKEN=2bUxAp2KHUi4J74pAZ3IuAnq8pApPqEQFrUkfCgVySE=; Path=/; Secure; SameSite=None,NPWEBCONSOLE_SESSION=fed51ec0a77ead9fd0f78fe4ca77124e0a2380a0-%00NPWEBCONSOLE_XSRF-TOKEN%3A2bUxAp2KHUi4J74pAZ3IuAnq8pApPqEQFrUkfCgVySE%3D%00%00_TS%3Asession%00; Path=/; HttpOnly; Secure; SameSite=None,NPWEBCONSOLE_XSRF-TOKEN=2HrcIdHCYx3Bib/sJV/GcWifpT0TspCbSacMtfuUUa0=; Path=/; Secure; SameSite=None,NPWEBCONSOLE_SESSION=6dd480d385aa1695a7cbbf87f20554958a4d429f-%00NPWEBCONSOLE_XSRF-TOKEN%3A2HrcIdHCYx3Bib%2FsJV%2FGcWifpT0TspCbSacMtfuUUa0%3D%00%00_TS%3Asession%00%00userid%3A4368b68a2ed54443bf0c7b85a76b3d4f%00%00userlogin%3A2025-05-26T07%3A12%3A19.3449016Z%00; Path=/; HttpOnly; Secure; SameSite=None'
-
How Qlik Cloud Handles RAM and Cache
Hi everyone,I am writing to you all mainly because I need some guidance with how Qlik Cloud handles cache and RAM with a large app I have. Additionall... Show MoreHi everyone,
I am writing to you all mainly because I need some guidance with how Qlik Cloud handles cache and RAM with a large app I have. Additionally, the app itself uses 20GB of RAM, and some of the objects are embedded in a webpage for external users to use. I understand that the first time the app is accessed, it will take some time to load due to the size, however, the second time, third time and so on, the app will load faster as it is already cached in memory.
On the other hand, I also understand that when users have stopped using the app (there are no sessions), it can be evicted from memory. Based on this, does anyone know how often does Qlik clear this cache from apps? Is it always checking if apps are no longer used? Or is it a random event based on something?
Any help and or guidance will be greatly appreciated!
Thanks a bunch!
-
Transladar de columna a renglón en EXCEL y generar el QVD
Comunidad QLIK, favor de apoyarme, Me URGECuento con 2 tablas en EXCEL UNA DE 51 Instructores y otra de 2070 IDs con sus evaluacionesCuento con 2070 r... Show MoreComunidad QLIK, favor de apoyarme, Me URGE
Cuento con 2 tablas en EXCEL UNA DE 51 Instructores y otra de 2070 IDs con sus evaluaciones
Cuento con 2070 registros CON ID del 1 al 2070 y sobre cada fila cuento con columnas de evaluación de Máximo 5 ID por evaluación. ejemplo el ID 1 tiene 5 instructores necesito traer en forma de filas a los 5 instructores con sus evaluaciones correspondientes. GRACIAS
Fuentes de entrada
ID de respuesta Fecha de inicio de la capacitación: Fecha de término de la capacitación: Satisfecho? Calidad? Mejoré? CuántosInst? 1Otra? 1Dominio? 1CubrióContenido? 1Habilidad? 1RecursosSuf? 2Otra? 2Dominio? 2CubrióContenido? 2Habilidad? 2RecursosSuf? 3Otra? 3Dominio? 3CubrióContenido? 3Habilidad? 3RecursosSuf? 4Otra? 4Dominio? 4CubrióContenido? 4Habilidad? 4RecursosSuf? 5Otra? 5Dominio? 5CubrióContenido? 5Habilidad? 5RecursosSuf? 1 2025-02-05 00:00:00.000 2025-02-05 00:00:00.000 1 Muy insatisfecho 3 Regular 5 Definitivamente sí 5 4 De acuerdo 3 Neutral 4 De acuerdo 3 Neutral 3 Neutral 3 Neutral 4 De acuerdo 3 Neutral 5 Totalmente de acuerdo 3 Neutral 2 En desacuerdo 4 De acuerdo 2 En desacuerdo 4 De acuerdo 3 Neutral 4 De acuerdo 3 Neutral 2 En desacuerdo 4 De acuerdo 3 Neutral 3 Neutral 2 En desacuerdo 5 Totalmente de acuerdo 4 De acuerdo 5 Totalmente de acuerdo SE REQUIERE LO SIGUIENTE
ID InstructorN InstructorCurso Ev [1 de los 5 Instr] Ev [2 de los 5 Instr] Ev [3 de los 5 Instr] Ev [4 de los 5 Instr] Ev [5 de los 5 Instr] 1 Instructor 1 1-1 4 De acuerdo [R1NI1] 3 Neutral [R2NI1] 4 De acuerdo [R3NI1] 3 Neutral [R4NI1] 3 Neutral [R5NI1] 1 Instructor 2 1-2 3 Neutral [R1NI2] 4 De acuerdo [R2NI2] 3 Neutral [R3NI2] 5 Totalmente de acuerdo [R4NI2] 3 Neutral [R5NI2] 1 Instructor 3 1-3 2 En desacuerdo [RINI3] 4 De acuerdo [R2NI3] 2 En desacuerdo [R3NI3] 4 De acuerdo [R4NI3] 3 Neutral [R5NI3] 1 Instructor 4 1-4 4 De acuerdo [RINI4] 3 Neutral [R2NI4] 2 En desacuerdo [R3NI4] 4 De acuerdo [R4NI4] 3 Neutral [R5NI4] 1 Instructor 5 1-5 3 Neutral [R1NI5] 2 En desacuerdo [R2NI5] 5 Totalmente de acuerdo [R3NI5] 4 De acuerdo [R4NI5] 5 Totalmente de acuerdo [R5NI5] -
Issue Migrating IntervalMatch from QlikView to Qlik Sense – Only Field Names, No...
Hello,I'm currently in the process of migrating an existing QlikView application to Qlik Sense. One part of the script involves using IntervalMatch() ... Show MoreHello,
I'm currently in the process of migrating an existing QlikView application to Qlik Sense. One part of the script involves using IntervalMatch() to map account numbers to predefined level 3 ranges for account grouping.
However, after the migration, I’m facing an issue where Qlik Sense only returns the field names, but no actual data is shown in the resulting table (even though the script executes without error).
What I’ve done:
Recreated the exact logic from QlikView using the same QVD files.
Verified the data is present by previewing the individual source tables (accounts, intervals).
Tried both INNER JOIN and LEFT JOIN around IntervalMatch() but the result is the same – no rows.
What seems strange:
The exact same script with IntervalMatch works in QlikView, but fails silently in Qlik Sense.
It appears to load structure (columns) but no content.
Has anyone experienced similar behavior with IntervalMatch() after migrating to Qlik Sense? Are there best practices or known differences I should be aware of?
I’ll attach a simplified part of the script to clarify.
Sub Formulate_Account_Grouping/*Actually we want to group accounts by 4 levels or categoriesstarting from level 3*//*these are the accounts that we want per company*/account_level:LOAD distinctGMAID as account_row_id,GMCO as company_id,GMOBJ as account_numFROM[lib://QVD/Tables/PRODDTA.F0901.qvd](qvd)where GMCO <> 99999and wildmatch(GMLDA ,6,7,8)and (GMPEC <> 'N' or GMOBJ=4999);//and GMPEC <> 'N';/*************************************************************************************************//*let's formulate the starting level which is level 3*/temp_acc_level_3:LOAD distinctGMCO as company_id,GMOBJ as acc_num_3,GMDL01 as acc_level_3from [lib://QVD /Tables/PRODDTA.F0901.qvd](qvd)whereGMCO <> 99999and GMLDA = 3and GMPEC = 'N';temp_acc_level_3_2:NoConcatenateLOAD * Resident temp_acc_level_3Order by company_id asc,acc_num_3 desc;drop Table temp_acc_level_3;temp_acc_level_3_3:LOADcompany_id,acc_level_3,acc_num_3,acc_num_3 as start_account,if(RowNo() = 1 or company_id <> Previous(company_id),99999,Peek(start_account) -1 ) as end_accountResident temp_acc_level_3_2;drop Table temp_acc_level_3_2;temp_match:IntervalMatch(account_num)LOAD start_account,end_accountResident temp_acc_level_3_3;INNER JOIN(account_level)LOAD * Resident temp_match;drop Table temp_match;INNER JOIN(account_level)LOAD start_account,end_account, acc_level_3,company_id,acc_num_3Resident temp_acc_level_3_3;drop Table temp_acc_level_3_3;drop fields start_account,end_account;Would greatly appreciate your input. Thanks!
-
Cycle through cyclic dimension within map visualization
Hello everybody,I have a map visualization that uses a cyclic dimension.Is it possible to iterate through the cyclic dimension from within the map viz... Show MoreHello everybody,
I have a map visualization that uses a cyclic dimension.
Is it possible to iterate through the cyclic dimension from within the map viz? At the moment I have a button that cycles through the dimensions and it works perfectly fine.
My issue however, when I maximize the map viz, I can not click the button (i.e. cycling through dimensions) anymore.
Is there a way to embed the button into the visualization or any other way to achieve cycling through dimensions when the map is in full-screen?
Please see screen-cap and app attached below.
Thanks in advance! -
Qlikview Pivot Table Column doesn't show
Hi, I made a modification to a QlikView app, adding a column to a pivot table, but there is a user that can't see the column, other users can. I thoug... Show MoreHi, I made a modification to a QlikView app, adding a column to a pivot table, but there is a user that can't see the column, other users can. I thought that the problem are the cookies of the browser, but the user logged in another PC and happend the same thing. Please help me.
-
Rolling 12 months Sum
I have a dataset with the premium and paid amount in each month. I want to show the rolling 12 months sum of the premium and paid in a table on QLik. ... Show MoreI have a dataset with the premium and paid amount in each month. I want to show the rolling 12 months sum of the premium and paid in a table on QLik. Does anyone know how to do it? Thanks.
I have attached a excel with a sample of my dataset on tab "Dataset" and my desired Qlik table on tab "QLik Dashboard".
-
How to get a simple count of rows in a table
Hello Everyone,I'm trying to find a simple way to make my table title show the number of rows in the current selection.Usually I just count one of my ... Show MoreHello Everyone,
I'm trying to find a simple way to make my table title show the number of rows in the current selection.
Usually I just count one of my ID fields such as count(MY_ID), but I'm looking if there is a built in function I can use instead?
Similar to the "Sum of Rows" feature for an expression, just need a simple count of the number of rows that are shown on screen.Does QV have a built in function for this sort of thing or anyone have any ideas?
The dataset is large with 6million+rows.Thanks,
Peter.
-
Finding Top 5 values in 10 columns
I have 10 columns containing number values and need to find and sum the top 5 values for each row. How can I do it in the data loading script?