Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 241,480 members
  • 4,571 online
  • 2,024,258 posts
  • 152,246 Solutions
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY

Welcome to Qlik Community

Recent Discussions

  • No Boards Found
  • forum

    Integration, Extension & APIs

    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 More

    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 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-embed
            ui="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)

    vlian_0-1737521570449.png

     

    vlian_1-1737521642885.png

     

     

    Show Less
  • forum

    Move to SaaS

    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 More

    Hello 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!

    Show Less
  • forum

    App Development

    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 More

    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 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.qvd
    TempTable << RPT033
    Lines fetched: 40,826 Checking vFieldExists: 18 TempTable << TempTable
    Lines fetched: 81,652
     
    The following error occurred:
    Table 'FinalTable' not found
     
    The 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.
    Show Less
  • forum

    QlikView App Dev

    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 More
    Hello!
    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 SR1
     
    Maybe someone has experienced something similar and has any suggestion?
    Show Less
  • forum

    Qlik NPrinting

    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 More

    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(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. 

    rduah4u_1-1737559096737.png

     

    Show Less
  • forum

    Integration, Extension & APIs

    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 More

    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 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 RestConnectorMasterTable

     

     

    All 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!

    Show Less
  • forum

    New to Qlik Analytics

    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 More

    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 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

    Show Less
  • forum

    Connectivity & Data Prep

    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 More

    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.

    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.

     

     

    Show Less
  • forum

    QlikView Administration

    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 More

    Buonasera a tutti,

    ho un disallineamento sul mio ambiente QlikView.

    I task funzionano correttamente e anche la sezione sourcedocument è correttamente popolata come da path corrispondente: 

    MargaretMimmi_3-1737558839868.png

     

    MargaretMimmi_2-1737558728816.png


    tuttavia, su userdocument vedo solo un file, invece dovrebbero essere due (come sulla cartella userdocument al path corrispondente):

     

    MargaretMimmi_6-1737559247588.pngMargaretMimmi_7-1737559283640.png

     

    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

    Show Less
  • forum

    App Development

    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 More

    Here 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:

    mikegrattan_0-1737569610067.png

     

     

    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?

     

    Show Less
Weekly Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!