Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 181,393 members
  • 9,644 online
  • 1,734,208 posts
  • 132,671 Solutions
Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

QLIKWORLD 2023!

A live, in-person thrill-ride - full of insights, learning, and peer-to-peer connections.

Analytics

Forums for Qlik Analytic 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

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.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

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

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.

About Qlik Community

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

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

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

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

Recent Discussions

  • forum

    QlikView App Dev

    Want to show past four months and coming eight months data in Trend combo chart

    I have date field " Expiration Date" I want to show the Expiring Tickets counts and its Value in a Combo Chart for past four months and coming eight m... Show More

    I have date field " Expiration Date"

    I want to show the Expiring Tickets counts and its Value in a Combo Chart for past four months and coming eight months

    Fields :

    Ticket ID

    Value

    Expiration Date

    Show Less
  • forum

    QlikView App Dev

    Difference qvf and qvw

    Hello together, For some time now it has been possible to use the formats qvf and qvw within QV. Unfortunately, I have not yet been able to identify a... Show More

    Hello together,

    For some time now it has been possible to use the formats qvf and qvw within QV.

    Unfortunately, I have not yet been able to identify any differences or what advantage the new format is supposed to have within QlikView.

    Does anyone have any advice?

    Thank you and greetings

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense not working after installation using AWS Marketplace May 2022 version

    Hi Team,  I installed Qlik sense using AWS marketplace : https://aws.amazon.com/marketplace/seller-profile?id=ba4c05a7-e7ff-462b-a4d6-99d3f6e77d1f   A... Show More

    Hi Team, 

    I installed Qlik sense using AWS marketplace :

    https://aws.amazon.com/marketplace/seller-profile?id=ba4c05a7-e7ff-462b-a4d6-99d3f6e77d1f

     

    After the installation, all the services are up and running but I am not able to hit :

    http://localhost/qmc

    Can you please help here?

     

    Thanks,

    Anmol

    Show Less
  • forum

    QlikView App Dev

    COMPARAISON PLUSIEURS CHAMPS

    Bonjour,  je voudrais comparer tous les champs existant dans deux QVD, sachant que les deux QVD contenants les mêmes champs mais pas toujours les même... Show More

    Bonjour, 

    je voudrais comparer tous les champs existant dans deux QVD, sachant que les deux QVD contenants les mêmes champs mais pas toujours les mêmes valeurs.

    J'ai essayé avec NOT MATCH mais ça prend beaucoup du temps. 

    Est-ce que vous avez une autre solution pour comparer les champs entre les QVD et afficher seulement les lignes différentes. 

    Merci d'avance pour votre aide 

    Show Less
  • forum

    New to Qlik Sense

    OLEDB Connection issue

    while connecting the DB, below error getting. Kindly advise   OleDb error Connector connect error: IDataInitialize::GetDataSource. HRESULT = 80040E4E.... Show More

    while connecting the DB, below error getting. Kindly advise

     

    OleDb error

    Connector connect error: IDataInitialize::GetDataSource. HRESULT = 80040E4E. ErrorSource: OraOLEDB, ErrorMsg: The system cannot find message text for message number 0x80040e4e in the message file for OraOLEDB.

    CONNECT TO ***

    Show Less
  • forum

    QlikView App Dev

    The Crazy Resigners

    Hello, I have a problem like this: I have a table of resigners whose fields are student ID, surname, name, date of resignation and job code. My aim is... Show More
    Hello, I have a problem like this: I have a table of resigners whose fields are
    student ID, surname, name, date of resignation and job code. My aim is to create a table in which, to these fields, I have to add another field called status in which the serial number can become ceased or terminated based on the selection date in qlik which I call competence date. In practice, if the resignation date is greater than the accrual date selected, the enrollment must have ceased. If the resignation date is less than or equal to the accrual date, the enrollment must have ceased. I need these data because I have to create, and this is the real objective, a dynamic table in which I have, for each job code, the count of the number of freshmen who are ceased or terminated. thanks for whoever can help me.
    Show Less
  • forum

    QlikView App Dev

    Create table of date with roster hours - based on roster template and startdate

    I want to create a report to analyse worked hours compared to an employee’s assigned roster per day.  Therefore I need to create a table with the amou... Show More

    I want to create a report to analyse worked hours compared to an employee’s assigned roster per day. 

    Therefore I need to create a table with the amount of hours per date according to the assigned roster

    I have the following tables:

    ROSTERSETTINGS

    Employee_id

    Roster_id

    Startdate_roster

    Enddate_roster

     

    ROSTERHOURS

    Roster_id

    Roster_name

    Roster_days

    Roster_day_sequencenumber

    Roster_hours

     

    ROSTERSETTINGS EXAMPLE:

     

    Employee_id

    Roster_id

    Startdate

    Enddate

    Startday

    999

    123

    1-12-2022

    31-12-2099

    4

     

     

    ROSTERHOURS EXAMPLE:

    Roster_id

    Roster_name

    Roster_day

    Roster_day_sequencenumber

    Roster_hours

    123

    Roster 40

    Mon

    1

    8

    123

    Roster 40

    Tue

    2

    8

    123

    Roster 40

    Wed

    3

    6

    123

    Roster 40

    Thu

    4

    8

    123

    Roster 40

    Fri

    5

    6

    123

    Roster 40

    Sat

    6

    0

    123

    Roster 40

    Sun

    7

    0

     

    The employee started on 1-12-2022, this is the 4th day of the assigned roster, therefore the “startday” of the ROSTERSETTINGS record is “4”.

    The table I want to create is the following:

    Date Roster_day_sequencenumber Roster_hours Roster_id Employee_id
    1-12-2022 4 8 123 999
    2-12-2022 5 6 123 999
    3-12-2022 6 0 123 999
    4-12-2022 7 0 123 999
    5-12-2022 1 8 123 999
    6-12-2022 2 8 123 999
    7-12-2022 3 6 123 999
    8-12-2022 4 8 123 999
    9-12-2022 5 6 123 999
    10-12-2022 6 0 123 999
    11-12-2022 7 0 123 999

     

    Many thanks in advance for your help!

    Show Less
  • forum

    QlikView App Dev

    How to count only the filtered month

    I'm working on a ticket panel, where I have the opening date and closing date of tickets. I would like to create a chart that compares these 2 values ... Show More

    I'm working on a ticket panel, where I have the opening date and closing date of tickets. I would like to create a chart that compares these 2 values ​​- Number of open calls and number of closed calls.

    342dssf_0-1672019366659.png

    I'm working on a ticket panel, where I have the opening date and closing date of tickets. I would like to create a chart that compares these 2 values ​​- Number of open calls and number of closed calls.

     

    The number of open calls is correct. The number of calls closed is being divided between Sep, Oct and Nov, and it would be necessary to count everything in November, adding the 3 the result is correct, but it would need to count everything in November.

     

    Here are the parameters used to build the graph:

    Dimension: Month Opening

    Measure - Open calls: Count({$<Status2 = {'New', 'Processing','Pending','Concluded','Resolved'}, SEMANA_FECHAMENTO=,Dt_Closing=, YEAR_CLOSING=, MONTH_CLOSING=, DAY_CLOSING>} Status2 ) -IT'S OK

     

    Measure - tickets closed: Count({$<Status2 = {'Concluded'}, SEMANA_ABERTURA=,Dt_Abertura=, ANO_ABERTURA=, MES_ABERTURA=, DIA_ABERTURA>} Status2) - WRONG

     

    Analyzing the data in table format, I identified that there are calls that were opened between Sep, Oct and Nov and that were closed only in November, but since I am using the filter Month closing = November it should be adding everything for the closing month.

     

     

     

     

    342dssf_1-1672019445070.png

     

     

     

    Show Less
  • forum

    QlikView App Dev

    Data Lineage / Data Semantic chart

    Hi all, I wanted to check if there is a chart object available in Qliksense that let's us create a data lineage or data semantic layer display, lettin... Show More

    Hi all,

    I wanted to check if there is a chart object available in Qliksense that let's us create a data lineage or data semantic layer display, letting us display the flow of data in the underlying source database?

     

    Say if we are getting data from 4 tables and merging to one final table in source database, i want to create a data semantics chart depicting the same and if some data is not available in one of the tables, highlight that semantic connection in red and etc,

    Regards,

    Darpan

    Show Less
  • forum

    QlikView App Dev

    Rate calculation total is not giving the results and showing null symbol in tota...

    Hi All, I have 4 measure calculations i need to divided by column(3) expression divide by column(2) to calculate. need to display the values based on ... Show More

    Hi All,

    I have 4 measure calculations

    i need to divided by column(3) expression divide by column(2) to calculate.

    need to display the values based on range.range values in script i stored in variable and using in table.

    set vRangeTest = '<= $5M',
    '> $5M and <= $10M',
    '> $10M and <= $15M',
    '> $15M and <= $20M';

    i need to get column(3) total value divide by column(2) total value in Rate total

    locationpremimun/TIv

    HarishM07_1-1674152024326.png

     

    i dont want sum for Rate totals

    Expected resulst:0.0158699

    HarishM07_0-1674151706629.png

     

    Show Less

Blogs

Community News

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

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

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

Events and Webinars

QlikWorld 2023!

Get ready for QlikWorld: The Conference for Data Thrill-Seekers. From exciting innovations to spine-tingling keynote presentations and lots of peer networking, you'll discover how you and your data can help your business succeed.

Find your city

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming