Recent Discussions
-
Qlik-embed shows no content but no error
Hi we are encountering an issue here. We are using qlik-embed and it successfully injects some html elements (qmfe and iframe), but does not render an... Show MoreHi we are encountering an issue here. We are using qlik-embed and it successfully injects some html elements (qmfe and iframe), but does not render any content. The iframe it inserted is empty (see screenshot). There was no errors or other messages in the console so don't really have much to troubleshoot.
The html for the embed component is:
<qlik-embedui="classic/app"app-id="c95adbee-a89e-41d8-b06f-d7492527814b"sheet-id="f927b2dd-d550-4239-b1ed-d56681fea1cc"theme="fraedom"></qlik-embed>We are trying to use the classic/app UI. The app id and sheet id we got is working in qlik sense (see second screenshot from qlik hub)
-
App Active Status
Hello ExpertsI have a client inquiry concerning their Qlik Sense SaaS environment where we've recently deployed 20 dashboards. These dashboards are st... Show MoreHello Experts
I have a client inquiry concerning their Qlik Sense SaaS environment where we've recently deployed 20 dashboards. These dashboards are static, with data loaded only once at deployment and no subsequent refreshes planned.Could you recommend a tool or method to monitor the health of these dashboards daily in the Qlik Sense SaaS environment ?
Basically I wanted to check if the 20 dashboard is active and Its up and running.
I am not interested in checking the RAM usage or reloads or numbers of Users using dashboard or Synthetic keys. I wanted to check only the status of the dashboard if it is active and up running on Qlik Saas.
Based on the above requirement which tool can perform this in Qlik.
Thank you! -
Rename field in loop store statement
I have a folder that contains several monthly .xlsx files. Most of these files contain a field called "Grade Category". In the newer months, this fi... Show MoreI have a folder that contains several monthly .xlsx files. Most of these files contain a field called "Grade Category". In the newer months, this field is renamed to "Career Band/Level Category". I am trying to create a process to loop through each of these files and rename the field if needed and store into a qvd. The 2 processes are broken out below. I've also included my script. This script works fine for all of the files that contain "Grade Category". Once it gets to a file where the field is "Career Band/Level Category" I am getting an error stating 'FinalTable' is not found.
Any suggestions on what I'm doing wrong? Thanks in advance!1. If the field in the file is called "Grade Category", rename it to "Career Band/Level Category" and then store it into a qvd.
2. If the field in the file is called "Career Band/Level Category", no renaming is necessary and the file can be stored into a qvd.
My Script:
// Define the source folder containing the raw files and the QVD target folder
LET vSourceFolder = 'lib:/.../';
LET vTargetFolder = 'lib://.../';// Get a list of the files in the source folder
FOR Each vFile in FileList('$(vSourceFolder)*Global Audit Reports Active *.xlsx')
// Extract the file name without the extension
LET vFileName = SubField(vFile, '/', -1);
LET vFileBaseName = SubField(vFileName, '.', 1); // Remove the extension
// Construct the QVD file name
LET vQvdFileName = '$(vTargetFolder)' & '$(vFileBaseName).qvd';
// Debugging: Trace the generated QVD file name
TRACE Checking QVD file: $(vQvdFileName);// Check if the QVD already exists
IF NOT IsNull(FileSize('$(vQvdFileName)')) THEN
// If FileSize returns a number, that means the file exists
TRACE QVD [$(vQvdFileName)] already exists, skipping loading of [$(vFile)];
ELSE
// Load the data from the Excel file into a temporary table
TempTable:
LOAD
*
FROM [$(vFile)]
(ooxml, embedded labels, table is [RPT033]);
// Check for the existence of the Career Band/Level Category field using FieldIndex
LET vFieldExists = FieldNumber('Career Band/Level Category', 'TempTable');
TRACE Checking vFieldExists: $(vFieldExists);// Create the final table based on the field existence
IF vFieldExists > 0 THEN
FinalTable:
LOAD
*
RESIDENT TempTable;
ELSE
FinalTable:
LOAD
*,
"Grade Category" AS "Career Band/Level Category"
RESIDENT TempTable;
Drop Field "Grade Category" from FinalTable;
ENDIF;// Store the data from the final table into QVD
STORE FinalTable INTO [$(vQvdFileName)];
// Drop the temporary tables to free up memory
DROP TABLE TempTable;
DROP TABLE FinalTable;
ENDIF
NEXT vFile;Log:
QVD [lib://.../Global Audit Reports Active 2024-11.qvd] already exists, skipping loading of [lib://.../Global Audit Reports Active 2024-11.xlsx] Checking QVD file: lib://.../Global Audit Reports Active 2024-12.qvdTempTable << RPT033Lines fetched: 40,826 Checking vFieldExists: 18 TempTable << TempTableLines fetched: 81,652The following error occurred:Table 'FinalTable' not foundThe error occurred here:STORE FinalTable INTO [lib://.../Global Audit Reports Active 2024-12.qvd]Data has not been loaded. Please correct the error and try loading again. -
Fast change option not working for some charts in container object
Hello! Our QlikView application users reported an issue that for some charts in our application "Fast change" button, which in our case switches betwe... Show MoreHello!Our QlikView application users reported an issue that for some charts in our application "Fast change" button, which in our case switches between "Combo chart" and "Straight table", is not working. These charts are added to container object. When they are cloned and are outside of the container object, fast change is working, but when it is added to old or newly created container, it stops working. It is possible to use Fast change to switch from Combo chart to, for example, Pie chart, but not to the Pivot table and Straight table.Interesting part is that in other tabs, where charts are a part of container object, there is no such issue and charts are switched to tables. I have tried creating new container object with adding cloned charts, but the issue remains.I found some 10 year old discussions on community site regarding the similar issue, there it was explained as version issue, but then it shouldn't work in any of the tabs..We are using version 12.70.20100.0 SR1Maybe someone has experienced something similar and has any suggestion? -
Filtering Specifc Sites
I have a kiosk report that reports on statues for kiosks per site daily for the rolling 7 days. I created a Variable that $(vFlagYCount) that =Count(D... Show MoreI have a kiosk report that reports on statues for kiosks per site daily for the rolling 7 days. I created a Variable that $(vFlagYCount) that =Count(Distinct(Kiosk_No) - this is shown as 13 under the flag tab. The sites listed are ones that show a status of Kiosks where there has been an offline status in the last 7 rolling day period. This is already defined in my report via calculated dimensions/measures. Therefore the sites that appear in a specific only has sites that have an offline status which is what is needed. The app also has sheets for other purposes that include all sites. However, focusing on this sheet, i only want emails sent to sites with a Kiosk Status 'offline' for the previous days to appear on this report regardless if they are on the other sheets. At the moment it's sending emails to all sites and where sites have been ok all week its replacing the status with 'Offline' which is not true and sending them emails to show this. I already have an import list that im using for my distibutions and im just currently testing the sites that shouldnt have emails sent to them, but this is not working.
-
Need to load a field from Pluralsight API in Qliksense
Hi, I created a report to track the progress of the company training progress. It works and I am doing some updates to it now. I want to include the t... Show MoreHi,
I created a report to track the progress of the company training progress. It works and I am doing some updates to it now. I want to include the team name for each user. This is the documentation I am referring to:
https://developer.pluralsight.com/schema/user/users
and the field 'teamNames' description states:
teamNames [String] A list of all the team names that the user is directly on. so this is my query ( I removed the api key and any other confidential information) :
UsersTotalCount:SQL SELECT"__KEY_data",(SELECT"totalCount"FROM "users" PK "__KEY_users" FK "__FK_users")FROM JSON (wrap off) "data" PK "__KEY_data"WITH CONNECTION (QUERY "type" "JSON",HTTPHEADER "Authorization" "KEY",HTTPHEADER "Content-Type" "application/json",BODY "{""query"":""query{ users { totalCount } }"" }");LET totalCount = Peek('totalCount', 0, 'UsersTotalCount');DROP TABLE UsersTotalCount;RestConnectorMasterTable:load__KEY_data as userData,__KEY_users as userKey,__FK_users as fk_User,__FK_nodes as userNode,id as userId,email as userEmail,firstName,lastName,teamNames;SQL SELECT"__KEY_data",(SELECT"__KEY_users","__FK_users",(SELECT"id","email","firstName","lastName","teamNames","__FK_nodes"FROM "nodes" FK "__FK_nodes")FROM "users" PK "__KEY_users" FK "__FK_users")FROM JSON (wrap off) "data" PK "__KEY_data"WITH CONNECTION (QUERY "type" "JSON",HTTPHEADER "Authorization" "KEY",HTTPHEADER "Content-Type" "application/json",BODY "{""query"":""query{ users (first: $(totalCount) filter:{isCurrent: true}){nodes {id email firstName lastName teamNames }}}""}");[users]:LOAD[userId],lower([userEmail]) as [userEmail],[firstName],[lastName],[firstName] & ' ' & [lastName] as [Full Name],[teamNames],[userNode]RESIDENT RestConnectorMasterTableAll the fields are populated and correct however, the teamNames field is just blank for every user.
Im guessing that since teamNames is an array, thats where the issue lies but I dont know what to do. Any assistance is greatly appreciated, Thanks!
-
Ignoring termination date for rehired employees
Hi I am loading employee data that includes current and former employees. One of the fields is termination date and another is active status. My issu... Show MoreHi
I am loading employee data that includes current and former employees. One of the fields is termination date and another is active status.
My issue is that some employee records have termination dates for active employees - basically they left and were rehired but the original termination date remains.
I want to use the load script to correct this and leave the termination date blank based on a True value in the active status field? What would be the best way to accomplish this? Do I need to create a new field or can I selectively populate the existing one?
I am new to Qlik so if you have a suggested script for this I would greatly appreciate it
Thanks
Ellys
-
Oracle ODBC connection via gateway --> data discrepancies
Hello, During our migration to Qlik Cloud, we are facing an issue with Oracle ODBC connection when we are comparing result between on premise and saas... Show MoreHello,
During our migration to Qlik Cloud, we are facing an issue with Oracle ODBC connection when we are comparing result between on premise and saas.
We used the last version of gateway, but number are consired as text in Qlik Cloud.
Can you help us?
Does anyone face the same issue?
Best regards,
Timothée H.
-
Documenti mancanti in userdocument
Buonasera a tutti, ho un disallineamento sul mio ambiente QlikView. I task funzionano correttamente e anche la sezione sourcedocument è correttamente ... Show MoreBuonasera a tutti,
ho un disallineamento sul mio ambiente QlikView.
I task funzionano correttamente e anche la sezione sourcedocument è correttamente popolata come da path corrispondente:
tuttavia, su userdocument vedo solo un file, invece dovrebbero essere due (come sulla cartella userdocument al path corrispondente):Ho stoppato tutti i servizi e li ho riattivati, ma non è servito.
Ho riavviato il server ma non ha funzionato.
Ho fatto diverse verifiche, anche seguendo alcuni suggerimenti trovati qui sulla comunity, ma non sono stati risolutivi. Avete qualche idea su come risolvere la problematica? Vi è mai capitato?Grazie a tutti
-
Set expressions working correctly, but give "Error in expression" when included ...
Here is the entire expression: =If((vMeasure) = 'EquivPrice',(Num(Sum({<ShipDate_DayOfWeek={'Mon'},Week={'$(vWeek)'},ShipYear={'$(=$(vYear))'}>}Extend... Show MoreHere is the entire expression:
=If((vMeasure) = 'EquivPrice',
(Num(Sum({<ShipDate_DayOfWeek={'Mon'},Week={'$(vWeek)'},ShipYear={'$(=$(vYear))'}>}ExtendedPrice) / Sum({<ShipDate_DayOfWeek={'Mon'},Week={'$(vWeek)'},ShipYear={'$(=$(vYear))'}>}EquivalentUnits),'$##.00'))
,
If((vMeasure) = 'CartonPrice',
(Num(Sum({<ShipDate_DayOfWeek={'Mon'},Week={'$(vWeek)'},ShipYear={'$(=$(vYear))'}>}ExtendedPrice) / Sum({<ShipDate_DayOfWeek={'Mon'},Week={'$(vWeek)'},ShipYear={'$(=$(vYear))'}>}CartonEquiv),'$##.00')),
(Num(Sum({<ShipDate_DayOfWeek={'Mon'},Week={'$(vWeek)'},ShipYear={'$(=$(vYear))'}>}$(vMeasure)),'#,##0'))
)
)Here is how it evaluates in the error panel:
It appears that all variables are evaluated correctly, and when I get out of the Edit mode, the results look good in the table, even after changing multiple variables to other values.
Is there a way to correct this?