Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 235,157 members
  • 4,129 online
  • 2,018,704 posts
  • 151,623 Solutions
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!

Welcome to Qlik Community

Recent Discussions

  • forum

    Move to Cloud

    Talend CLOUD API DESIGNER

    WHY i don't have api designer in my talend cloud ?at the moment, i'm using free trial version for 14 days,  it's because i'm using a trial version ? Show More

    WHY i don't have api designer in my talend cloud ?

    at the moment, i'm using free trial version for 14 days, 

    it's because i'm using a trial version ?

    Show Less
  • forum

    Qlik Replicate

    Express license

    Hi all, hope you guys are doing well. I have recently downloaded Qlik replicate on my windows laptop and the url from where i downloaded the Qlik repl... Show More

    Hi all,

    hope you guys are doing well. I have recently downloaded Qlik replicate on my windows laptop and the url from where i downloaded the Qlik replicate is "https://community.qlik.com/t5/Product-Downloads/tkb-p/Downloads". I am trying to populate a csv file into a local folder in my laptop. For source, endpoint is built using file and for destination endpoint is built using File Channel.

     

    and it gave me this error

    "

    • Task cannot run.
    • Express license: Target endpoint File Channel is not licensed under the Express license.
    • Express license: Source endpoint File is not licensed under the Express license."
    Show Less
  • forum

    Qlik NPrinting

    Scheduled report comes out empty unless I also schedule a metadata refresh befor...

    Hi everyone, I recently switched from NPrinting 16 to NPrinting May 2023 SR3 and QlikView May 2023 SR1. My QVF/QVW document gets refreshed daily on th... Show More

    Hi everyone,

    I recently switched from NPrinting 16 to NPrinting May 2023 SR3 and QlikView May 2023 SR1. My QVF/QVW document gets refreshed daily on the QlikView server.

    Initially, I noticed that my NPrinting report worked once, but the next day it was sent empty (charts and tables were present, but no data). After tinkering in the NPrinting web console, it worked again once, but then the next time it was empty again.

    Later, I discovered that I needed to schedule a metadata refresh to run before the publishing task. Is this the correct approach, or am I doing something wrong?

    If scheduling a metadata refresh is necessary, is there a way to automatically trigger the report publishing right after the metadata gets refreshed?

    Thanks for your help!

    I'm not sure if this is relevant or not. The data in the report is dependent on a date parameter that gets passed from NPrinting filter which is usually today(1)-1  with evaluate ticked.

    Show Less
  • forum

    App Development

    Retrieving data from AT&T RingCentral using REST connector

    I am having some issues getting the REST connector to pull the data I'm looking for on RingCentral. I've set up a REST application in the development ... Show More

    I am having some issues getting the REST connector to pull the data I'm looking for on RingCentral. I've set up a REST application in the development console on ringcentral.com, and they provided the following:

    • Client ID
    • Secret
    • JWT credential
    • URL to query

    The REST connector in Qlik, however, just has User ID and Password in the credentials area, so I am unsure how to proceed. Is there a way to use Client ID/Secret/JWT in the Qlik REST connector? Perhaps there are query parameters that I can use to pass this information to the API (cannot find this info on their site). 

    Thanks for any guidance!

     

    Show Less
  • forum

    Qlik NPrinting

    Standardizing company logo in all NPrinting reports

    Hi, I am trying figure if there is a standard way I could put/maintain my company logo in all our NPrinting reports. Example we have hundreds of  NPri... Show More

    Hi,

    I am trying figure if there is a standard way I could put/maintain my company logo in all our NPrinting reports. Example we have hundreds of  NPrinting reports going out and we have added company logo in templates but if we were to change this we need to update it in each report. Is there a way we can standardize it, so that if we update the logo in one place all the reports gets updated for future reference.

     

    Thanks,

    Sikander

    Show Less
  • forum

    App Development

    Passing variable in SQL query while extracting data

    Hi, I am using an SQL query to fetch previous day's data from an Oracle database. This query gives me data for just previous day. I need last 45 days ... Show More

    Hi,

    I am using an SQL query to fetch previous day's data from an Oracle database. This query gives me data for just previous day. I need last 45 days worth of data on a daily basis.

    Is there a way I can pass a variable for the highlighted section of the query snippet below so that I can run a loop and extract data for all the past 45 days... something like sysdate - $(vDateCount) in place of the highlighted section.

    bsharma_velcro_0-1730291884381.png

    Regards,

    Bhaskar

    Show Less
  • forum

    Design and Development

    How to reject records on a specific column when using schema type defined as "Dy...

    Hello there, Is there any way we can filter/reject some records on a specific column in Tmap when using “Dynamic” schema type in Talend. My source is ... Show More

    Hello there,

    Is there any way we can filter/reject some records on a specific column in Tmap when using “Dynamic” schema type in Talend.

    My source is Oracle and Target is Snowflake and am using schema type as "Dynamic" on both sides and I won't be able to see the columns.

    my job looks like this currently:

    tdbOracleInput - tmap-3 flows (1st one goes to tDBoutputsnowflake, 2nd one goes to a tFileoutputdelimited to store raw records and last one is where I want to capture the rejects).

    Any pointers are very helpful.

    Thank you

    Nandu

    Show Less
  • forum

    App Development

    How can I add qvd-files with data manager automatically depending on which space...

    Hi,In my app I want to use qvd-files from the space where the app is located. I.e when the app is in shared space the qvd-files resides in shared spac... Show More

    Hi,

    In my app I want to use qvd-files from the space where the app is located. I.e when the app is in shared space the qvd-files resides in shared space and when the app is in managed space it should use the qvd-files in the managed space. And I don't want to change the app once it is in managed space.

    This can be solved by manually adding this in the script:

    Let vSpaceType = GetSysAttr('spaceType');
    
    // Figure out if this is shared or managed space
    if vSpaceType = 'shared' then
    Let vQvdExtractPath = 'lib://MySharedSpace:DataFiles/';
    else
    Let vQvdExtractPath = 'lib://MyManagedSpace:DataFiles/';
    end if;
    
    Data:
    LOAD *
    FROM [$(vQvdExtractPath)MyExtractedData.qvd]
    (qvd);


    But how can I set this when I fetch data automatically with data manager?


    Kind regards
    Johan

    Show Less
  • forum

    Stitch

    A new board to talk about all things Stitch!

    Stitch is a cloud-first, open source platform for rapidly moving data. A simple, powerful ETL service, Stitch connects to all your data sources – from... Show More

    Stitch is a cloud-first, open source platform for rapidly moving data. A simple, powerful ETL service, Stitch connects to all your data sources – from databases like MySQL and MongoDB, to SaaS applications like Salesforce and Zendesk – and replicates that data to a destination of your choosing.

    If you are new to Stitch or one of our Stitch experts, here is the place to ask questions and/or build up your reputation points by answering questions and offering up your Stitch life hacks to get stuff done.

    Show Less
  • forum

    New to Qlik Analytics

    Is there any way to reduce the font size in this card?

    Hi, I'm following along the course Data Manager Associations, Concatenations and Joins. On the 6th video, 'Concatenate Tables from Separate Sources in... Show More

    Hi,

    I'm following along the course Data Manager Associations, Concatenations and Joins.

    On the 6th video, 'Concatenate Tables from Separate Sources into a Single Table', we are instructed to inspect the table 'OrderData' via the table editor, and keep the range of the field 'OrderDate' in mind.

    In the video, the range is fully visible:

    Value Range of 'OrderDate' field is presented in regular sized font, making the range fully visibleValue Range of 'OrderDate' field is presented in regular sized font, making the range fully visible

    In the app I created with instructions from the video, the font size of the range is unnecessarily large, making the range only partially visible:

    Screenshot showing the Value Range of 'OrderDate' field is so large.Screenshot showing the Value Range of 'OrderDate' field is so large.

    As it can be seen in the screenshot, the final part of the value is omitted and replaced by ellipses, which kind of defeats the purpose of having the range summarized there. 

    Is there any way to reduce the font size so the whole value is visible? 

    I tried to use ctrl + '-' to change the size of the page, but comically enough, the font of every other text on the page decreased except for the range! I also thought maybe the value could be copied and pasted somewhere else for inspection, but that is not possible either. What can be done in this case to visualize the whole value?

    Screenshot showing zoomed out page, where all the text has been scaled down to reflect the zoom change, except for the value of interest, which actually seemed to increase in size.Screenshot showing zoomed out page, where all the text has been scaled down to reflect the zoom change, except for the value of interest, which actually seemed to increase in size.

     

    Show Less
X
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.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

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

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

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