Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,381 online
Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    Ideation Discussions

    Manipulation de données (les dates)

    Bonjour, Je fais des manipulations sur des dates, j'ai besoin de faire la différence entre deux dates en fonction d'un autre champ. J'aimerai bien sav... Show More

    Bonjour, 

    Je fais des manipulations sur des dates, j'ai besoin de faire la différence entre deux dates en fonction d'un autre champ.
     

    Absence.PNG


    J'aimerai bien savoir, s'il y a une possibilité de faire la différence entre ( La date de fin [11/07/2020]  ) et ( la date de début [04/09/2020] ). Parce qu'en vrai, j'ai besoin de savoir est ce que la personne en question a repris le travail entre temps ou pas. Surtout, pour voir si elle a prolongé son arrêt ou elle a repris et ensuite elle a déposé un autre arrêt maladie.

    En grosso-modo, je veux dire: Si[la date de fin (N-1)- [la date de début (N)] ) > 1 donc le résultat sera de 1 sinon c'est 0 cela en fonction du nom de la personne .

    Je vous remercie d'avance. 

    QlikView 

    Show Less
  • forum

    QlikView Administration

    Launch action to open a PDF file fails in Access Point

    We use the "Launch" action that opens a PDF file (Tips and Tricks document).  We open Access Point in IE and have no problems.  With IE going away, we... Show More

    We use the "Launch" action that opens a PDF file (Tips and Tricks document).  We open Access Point in IE and have no problems.  With IE going away, we have started opening Access Point in Chrome and we have discovered that the PDF document won't open and we get this window:

    dpstanley_13_0-1614940065831.png

    We discovered that both our test and prod servers have IE installed but not Chrome.  I installed Chrome, but nothing has changed.  I'm not much of a server admin type.  Are we on the right track?  I feel that I am missing something obvious, but my search attempts on the Community were not very helpful.

     

    Show Less
  • forum

    Qlik Sense App Development

    Compare dates between two tables in the script

    Hi Everyone,I've been struggling with this problem for quite some time now, which in my head seems to be simple but I can't figure out a solution.  I ... Show More

    Hi Everyone,

    I've been struggling with this problem for quite some time now, which in my head seems to be simple but I can't figure out a solution. 

     

    I have two tables loaded in my app: Admissions and Appointments.

    Admissions contains the records of when the patient was admitted at the hospital. Here is a simplified version of the table:

    Admission IDPatient IDAdmission Date
    a1p101/01/2020
    a2p102/01/2020
    a3p202/01/2020

     

    Appointments contains the appointments each patient attended in a clinic

     

    Appointment IDPatient IDAppointment Date
    app1p101/01/2019
    app2p301/03/2020
    app3p402/10/2020

     

    I want to check the against each admission the Previous appointment this patient attended, by comparing the Admission date with the Appointment Date. Ideally by making a reference to the AppointmentID in an additional column while loading the Admissions table.

    Can anybody give me some direction? 

    Show Less
  • forum

    New to Qlik Sense

    how to write multiple if conditions

    Hi Qlik Users,I would like to write below nested if condition up to next 120 months. Can any one suggest me to simplify this logic instead of writing ... Show More

    Hi Qlik Users,

    I would like to write below nested if condition up to next 120 months. 

    Can any one suggest me to simplify this logic instead of writing 120 times.

    If(MDate=MonthStart(Today()),Sales,
    If(MDate=MonthStart(Today(),1),Sales,
    If(MDate=MonthStart(Today(),2),Sales,
    If(MDate=MonthStart(Today(),3),Sales,
    If(MDate=MonthStart(Today(),4),Sales,
    If(MDate=MonthStart(Today(),5),Sales,
    If(MDate=MonthStart(Today(),6),Sales,
    .
    .
    .
    .
    If(MDate=MonthStart(Today(),120),Sales,

    0
    )
    ))))))))))

    Show Less
  • forum

    Qlik Sense App Development

    How to change axis labels?

    Hello,how can we change the label of an axis.I got a combochart with 6 measures, the y-axis is full of the measure-names.What i want is just two words... Show More

    Hello,

    how can we change the label of an axis.

    I got a combochart with 6 measures, the y-axis is full of the measure-names.

    What i want is just two words there. But i can only display or not the names of the measurement.

    Is there a possibility or a extension to customize the chart labels?

    Show Less
  • forum

    Scalability

    QV Scalability Tools (QV10,QV11,QV12)

    This package (referred to as QVScalabilityTools) contains a complete set of tools for easy creation, execution and analyzing of load/performance tests... Show More

    This package (referred to as QVScalabilityTools) contains a complete set of tools for easy creation, execution and analyzing of load/performance tests and regression tests.

     

    QlikView documents to help analyze result and log files(This was previously included in this package):Scalability Results Analyzer

     

    Older versions of the tool can be found here: Tool for easy creation of load/performance tests of QlikView (v.10 and 11)

    Tools for Qlik Sense can be found here: Qlik Sense Scalability Tools (Sense v2.0, v2.1, v2.2, v3.0, v3.1)

    QlikView Benchmarking tests: QlikView 12 Hardware Benchmarking Package and QlikView 11 Hardware Benchmarking Package

     

    Note: Using windows built-in unzip functionality will not allow the .exe to launch unless unblocking zipped package first (properties -> unblock).

     

    Included parts are:

    • Standalone application for creating a JMeter script
    • Support files for launching the script by utilizing the JMeter engine (JMeter installed is a pre-requisite)
    • Documentation on how to use the package

    Changelog 1.2.6->1.2.7

    • NTLM support removed due current solution broken and lack of a new secure solution.
    • Small updates for static content, for future product releases.

    2019-08-26

    Documentation updates due to:
    - New recommended JMeter version (4.0)
    - Changes to the licensing for the Oracle Java implementation (seehttps://www.oracle.com/technetwork/java/javase/overview/oracle-jdk-faqs.html)
    - Open-source Java Development Kits (JDKs) have been verified for use with JMeter and the QlikView Scalability Tools

    Changelog 1.2.5->1.2.6

    • Added support for QlikView 12.50 and 12.20SR10

    Changelog 1.2.4->1.2.5

    • Added support for QlikView 12.30

    Changelog 1.2.3->1.2.4

    • Added support for JMeter 4.0 and Java 9.
    • Bugfixes for regression testing
    • Added actions: Select Excluded, Select All, Select Possible
    • Added support for 12.20 SR3

    Changelog 1.2.2->1.2.3

    • Bugfix for export to excel action
    • Added transfer state (bookmark) support for document chaining
    • GUI: Template selection more accurately show supported Qv versions

    Changelog 1.2.1->1.2.2

    • Bugfixes, make sure minimum amount of selections are respected in certain corner cases

    Changelog 1.2->1.2.1

    • Improved performance for high throughput scenarios

    Changelog 1.1 -> 1.2

    • Improved assertions logic to show faulty actions as errors
    • Change JMeter template scripts to use groovy instead of beanshell
    • New prerequisites:
      • JMeter version 3.0
      • Java 64-bit JRE 8

     

    Your use of QVScalabilityTools will be subject to the same license agreement between you and QlikTech for QlikView Server. QlikTech does not provide maintenance and support services for QVScalabilityTools, however please check QlikCommunity for additional information on use of these products.

     

    PLEASE NOTE:

    The supported versions of Java are 8 and 9. Supported version of JMeter are 3.0 and 4.0, but not 3.2

    Show Less
  • forum

    New to Qlik Sense

    Sending Reports to Distribution List

    Hello,I want to send PDF to a ditribution list on Nprinting.I want to know how to do this?and if i could create a user with le email address ,I tried ... Show More

    Hello,

    I want to send PDF to a ditribution list on Nprinting.

    I want to know how to do this?and if i could create a user with le email address ,

    I tried to do this but i don't know what i should put on the field NT NAME  when i will create the user.

    Thanks

     

    Show Less
  • forum

    QlikView App Dev

    QV Loading Slower After Upgrade

    Recently we upgraded our QV version from 12.20SR9 to 12.50SR4. And we notice that some of our reload time increased drastically.Below is the compariso... Show More

    Recently we upgraded our QV version from 12.20SR9 to 12.50SR4. And we notice that some of our reload time increased drastically.

    Below is the comparison between the log files of 12.20 (left) vs 12.50 (right). It is using the exact same QVW, QVD and also same computer/server.

    728KSLbCsD.png

    Previously it took about 1 minute to load this QVD, but in the new  version it took 15mins! Anyone that experience this before?

    Show Less
  • forum

    QlikView App Dev

    Conntecting the calendar week to a crosstable with dates

    Hello i have a crosstable lookinkg like this. i got a value connected to a location on each date. how can i connect the calendar week / week number (l... Show More

    gustavofred_0-1614925050636.png

    Hello i have a crosstable lookinkg like this. i got a value connected to a location on each date. how can i connect the calendar week / week number (like the date 02.01.2021 would get the number 1, because its in the first week of the year) to each date? is there some way to "iterate" over the variable names, to do something like 

    calendar week = week([22.2.2021]), but for all imported dates?

    my Crosstable import looking like this:

    Directory;
    CrossTable(date, *value*)
    LOAD location,
    [22.2.2021],
    [23.2.2021],
    [24.2.2021],
    [25.2.2021],
    [26.2.2021],
    .......more dates

    FROM
    [***.xlsx]
    (ooxml, embedded labels, table is Sheet0);

     

     

    Show Less
  • forum

    Qlik Sense App Development

    Mulitple conditions for if clause

    Hello,I have a Bar chart where I want to show the dimensions only if it has two conditions (field MakeBuy should be 'make' and the calculated value sh... Show More

    Hello,

    I have a Bar chart where I want to show the dimensions only if it has two conditions (field MakeBuy should be 'make' and the calculated value should be ave 0.2

    =if((MakeBuy='make'and Sum({<Source={'AccountStructureSOW'}>} Value)/
    Sum({<Unit={'Costs'}>}Value)>'0.2'),SubCompetency)

    the formular is shown as OK but the dimension is not guilty. what did i wrong?

    Best regards

     

    Pia

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

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

750+ Members

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand