Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,349 members
  • 2,661 online
  • 1,995,031 posts
  • 149,500 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Comparing dates in set analysis

    Data Model:   Activities Table contains ContactId, ActivityId, ActivityDate, ActivityDescription Outputs Table contains ContactId, OutputDate, OutputD... Show More

    Data Model:

     

    Activities Table contains ContactId, ActivityId, ActivityDate, ActivityDescription

    Outputs Table contains ContactId, OutputDate, OutputDescription

     

    I am trying to create a table that lists:

    Contact ID, Output Date, number of Activities that precede that Output Date.

     

    The set expression I have for the number of Activities that precede that Output Date is:

    Count({<ActivityDate={"<=OutputDate"}>} ActivityID)

     

    However, this returns nothing.  

     

    Thanks in advance for any help!

     

    Show Less
  • forum

    New to Qlik Analytics

    date format

    Hi, I need to show the output highlidhted below in red(). If the difference review date-today() >0 I need to show the difference in the format as high... Show More

    Hi,

    I need to show the output highlidhted below in red().

    If the difference review date-today() >0 I need to show the difference in the format as highlighted in red().

    And one addon like if review date-today() < 365 I need to show like 2 months 11 days instead of 0 years 2 months 11 days.

     

    ref review date =today() review date-today() difference Required output
    000AL2 01/07/2024 21/04/2024 71 <365 2 months 11 days
    000AL2 01/07/2026 21/04/2024 801 >365 2 Years 2 months 11 days
    000AL2 01/07/2029 21/04/2024 1897 >365 5 Years 2 months 12 days
    000AL2 01/07/2032 21/04/2024 2993 >365 8 Years 2 months 13 days
    000AL2 01/07/2035 21/04/2024 4088 >365 11 Years 2 months 13 days
    Show Less
  • forum

    Installing and Upgrading

    Total path and file name length must not exceed 260 characters

    Hi, During installation process, the following message is displayed even if the effective path and file name length is only 228 characters including ... Show More
    Hi,
    During installation process, the following message is displayed even if the effective path and file name length is only 228 characters including the root (C:\Outils\Talend\):
    !   C:\Users\xxxxxx\Downloads\TOS_DI-20160704_1411-V6.2.1.zip: Cannot create TOS_DI-20160704_1411-V6.2.1\plugins\org.talend.designer.components.localprovider_6.2.1.20160704_1411\org\talend\designer\components\lookup\memory\ConcurrentAdvancedMemoryLookup$ConcurrentMultiLazyValuesMap.class
    Total path and file name length must not exceed 260 characters
    ! Le chemin d’accès spécifié est introuvable.

    The problem doesn't occur with 6.2.0 and the same root.
    Regards
    FT Show Less
  • forum

    Qlik Replicate

    next execution of a task wrong date

    For several days I have had a problem in qlik sense enterprise, the date of the next execution of all the tasks that I currently have configured are w... Show More
    For several days I have had a problem in qlik sense enterprise, the date of the next execution of all the tasks that I currently have configured are wrong, they are dates that are days before the last execution or days after the last execution and currently it does not execute no task, check the scheduler is fine, delete several tasks and create them from scratch but when doing this and executing the task the date of the next execution appears blank as if it were not inserting or updating the date of the next execution, I It seems curious that by scheduling the tasks it does not work, but if I execute them manually they execute correctly but the date of the next execution is still wrong, this began to happen after I installed a new SSL certificate to the Qlik Sense server And when I restarted it, it asked me for several updates to the Windows Server operating system and I did them. Could this be the cause? But I find it curious that no other configuration or anything has been made, could you help me with this please or if someone has passed on what the solution was.
    
    I appreciate your prompt response since I have many processes stopped because of this and my company is asking for solutions.
    
    I attach images of a task and version of qlik sense enterprise

    Agudelo525_0-1713715278724.pngAgudelo525_1-1713715320409.png

     

     
    Show Less
  • forum

    App Development

    Time stamp Conversion

    Hi , I have time stamp column as follows :2023-01-09 20:39:14.0000000 +00:00 how to convert this to regular format as 'DD/MM/YYYY h:mm:ss TT'. Any Sug... Show More

    Hi ,

    I have time stamp column as follows :2023-01-09 20:39:14.0000000 +00:00

    how to convert this to regular format as 'DD/MM/YYYY h:mm:ss TT'.

    Any Suggestions would be highly appreciated.

    Thanks in Advance.

    Show Less
  • forum

    App Development

    Show zero measures in a graph

    (Apologies, this was posted earlier but was my post was so full of flaws, I removed it). I am trying to show a graph of tickets raised over a periiod ... Show More

    (Apologies, this was posted earlier but was my post was so full of flaws, I removed it).

    I am trying to show a graph of tickets raised over a periiod of time.  In my data I have zero 'Open' tickets in October and as a result October does not show on my graph.

    Markbhai_0-1713531709414.png

    I have tried a 'Master Calendar' which works until a filter is applied.  -

    I have also read about adding + sum({1}0) to my measure.

    Count({<[Status]={'Open'}>}id) + sum({1}0)

    and setting the Addons -> Data Handling -> Include zero values 

    Markbhai_1-1713531893301.png

    Any help would be appreciated

     

    Show Less
  • forum

    Qlik Application Automation

    Getting load to work with if and exists?

    Hey folks. I have a situation where I need to join a bunch of similar, but not identical, report files into a single.QVD. I've been renaming headers w... Show More

    Hey folks.

    I have a situation where I need to join a bunch of similar, but not identical, report files into a single.QVD. I've been renaming headers with python before loading but now my boss wants me to get rid of the python step and do it all in Qlik.

    The issue is that it's a bunch of .CSV files with slightly different header names. For example "Customer #" vs "Customer number" vs "Client No." There's no option to get these to come in harmonized because they're from different vendors.

    I was trying to do something like: Load Distinct If(exists('Customer #'), 'Customer #') as CustomerNumber If(exists('Client No.'), 'Client No.') as CustomerNumber

    But I get an error about the headers not being unique even though I'd expect the If() to return nothing when the Exists() condition fails.

    Moving the "as CustomerNumber" inside the If() statement is a syntax error.

    Is there a way to do this without making temporary tables and conctenating? I'm now doing it this way and it's working but it seems inelegant and like it's more steps than should be needed.

    Thanks!

    Show Less
  • forum

    Connectivity & Data Prep

    Oracle connection using ODBC - numbers converted to scientific notation

    Hi, I have a problem with numbers automatically converted to scientific notation. I know that Qlik Sense has a limit of 15 digits. My problem is: 14 d... Show More

    Hi, I have a problem with numbers automatically converted to scientific notation. I know that Qlik Sense has a limit of 15 digits. My problem is:

    14 digit number is displayed properly

    15 digit number is converted to scientific notation

    number with decimal places is also converted to scientific (instead of 0.000007 we have 7e-06)

     

    bartoszmusial_0-1709642543060.png

    Is it a bug with ODBC connector? (our version is Version: 7.34.0)

    bartoszmusial_1-1709642669673.png

    OLE DB connector works as expected and displays all those numbers in regular number format, but it's 3 times slower in our case. NLS_LANG for OLE DB driver is set as POLISH_POLAND.AL32UTF8 (commas separates decimal digits)

    bartoszmusial_2-1709642776121.png

    Show Less
  • forum

    Deployment & Management

    Can anyone share me how you studied for the Qlik Sense System Administrator (QSS...

    Hello, I looked at the information in the following url: https://www.qlik.com/us/services/training/certifications-and-qualifications I was wondering i... Show More

    Hello, I looked at the information in the following url:

    https://www.qlik.com/us/services/training/certifications-and-qualifications

    I was wondering if anyone could share how they studied for this certificate.

    Should I just do the "Recommended Preparation Resources"?

    I'm thinking of studying in this way:

    (1) Take all courses in the Qlik Continuous Classroom - All 37 courses
    (2) Take the instructor-led training
    (3) Do the practice questions

    If you have any recommended way of studying for this certificate, could you please share?
    I was wondering if there were any other ways than taking all 37 courses in Qlik Continuous Classroom.
    Can I just study the ones that are not Cloud-related?

    Thank you for your time.

    Show Less
  • forum

    Qlik Cloud Data Integration

    Is an ODBC driver needed for landing data to Snowflake?

    I have two questions regarding the help documentation provided at the following link: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Conten... Show More

    I have two questions regarding the help documentation provided at the following link:

    https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetConnections/snowflake-target.htm

    I am uncertain about when the Snowflake ODBC driver is required and when it is not.

    1. "A driver is only required if you are accessing the database via a Data Movement gateway."
    Does "the database" refer to the source database from which data is being extracted (e.g., Oracle)?

    2. "If the target database is directly accessible from Qlik Cloud, select None."
    Is the "target database" in this context referring to Snowflake?

     

    Considering the following scenario for data movement:
    FROM: Oracle on-premise internal environment (accessed via a Data Movement gateway)
    TO: Snowflake in a trial environment (directly accessible from Qlik Cloud)

    In this case, is it necessary to have both the Oracle ODBC driver for the Data Movement gateway and the Snowflake ODBC driver?
    Additionally, should we select 'None' for the Snowflake connection type since it is directly accessible from Qlik Cloud?

    "Is my understanding correct that even if Qlik Cloud has direct access to Snowflake, if the connection from the Oracle side is via a Gateway, an ODBC driver for Snowflake is required? I thought that selecting 'None' would mean that I don't need an ODBC driver, but in fact, without the ODBC driver, the data landing resulted in an error."

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

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!