Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
3,808 online

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

Qlik Academic Program

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

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.

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

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.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    App Development

    Need incremental flag based on Rank value.

    Hi All, Hope all is well,Please help me on one scenario where I need a code which provide me incremental Flag numbers based on id , Date and Rank.For ... Show More

    Hi All,

     

    Hope all is well,

    Please help me on one scenario where I need a code which provide me incremental Flag numbers based on id , Date and Rank.

    For example

    if a id have four zero ranking then it should be show the result like for first Zero the flag will be  Issue1 for second zero rank Flag will be  Issue2..  and so on.

    I am attaching a sample data with expected result column.

     

    manojin123_0-1627503171907.png

     

    Show Less
  • forum

    Connectivity & Data Prep

    multiple SQL lines (; ) in Qlik Script

    hi all, I'm trying to run a SQL statement that creates a few TEMP tables and then applies some joins to those tables. The query runs just fine in the ... Show More

    hi all, 

    I'm trying to run a SQL statement that creates a few TEMP tables and then applies some joins to those tables. 

    The query runs just fine in the IDE but when running it in Qlik Sense script, the reload fails. the reason is that the query contains multiple semicolons (;), indicating the end of the SQL, or at least that's what Qlik thinks and ignoring the rest of the SQL, causing a syntax error at the reload time. 


    here's a simplified version of the SQl I'm trying to run in qlik:


    CREATE TEMP TABLE Eng as (

    select distinct FIELD_A
    from SCHEMA.fact_table

    );  // first semicolon 


    CREATE TEMP TABLE phone_calls as (

    SELECT das.*
    FROM SCHEMA.fact_table_TWO das
    ); // second semicolon 

     

    select *
    from Eng
    left join phone_calls on phone_calls.key_field_1 = Eng.key_field_2
    ; // last semicolon 

     

     

    thank you all!

    Show Less
  • forum

    QlikView App Dev

    In stocked bar chart getting miscellaneous bar

    Hi All,In 100% stocked bar chart im getting miscellaneous bar after 100%, i have unchecked the Include null values as well for the dimensions. how to ... Show More

    Hi All,

    In 100% stocked bar chart im getting miscellaneous bar after 100%, i have unchecked the Include null values as well for the dimensions. how to get rid of this unwanted bars. developing this chart in Qliksense

    stocked bar.JPG

    Thanks in Advance.

     

    Show Less
  • forum

    App Development

    Is it possible to view the source code of an app created through the QLIK GUI in...

    Hi,I am a new user to QLIK and I want to find a way to view the source code for an app developed with the GUI interface ( creating plots, bar charts, ... Show More

    Hi,

    I am a new user to QLIK and I want to find a way to view the source code for an app developed with the GUI interface ( creating plots, bar charts, etc)  within QLIK.

    I am developing apps with QLIK desktop on secure databaseand cannot send the app  to the QLIK sense due to secuirty. I can however send text from my secure network to the network with QLIK sense. 

    Would it be possible to develop an app  (using the GUI interface) with QLIK desktop, obtain the source code , and copy & paste that source code into a text file, and use that source code to generate the same APP i developed on QLIK desktop? 

    Show Less
  • forum

    Deployment & Management

    Manage QMC Access

    Hello Qlik experts,Is there a security rule that prohibits the user from viewing the most important factors in the QMC for certain tasks/apps etc.? Fo... Show More

    Hello Qlik experts,

    Is there a security rule that prohibits the user from viewing the most important factors in the QMC for certain tasks/apps etc.? For example, the user is only allowed to see a group of elements.

    Best regards

    Son

    Show Less
  • forum

    New to Qlik Sense

    Price history in visualexpression

    Hi,I would like to show a simple price history in a table and diagram.For this I have a date and a part number as the dimension and the price. The dat... Show More

    Hi,

    I would like to show a simple price history in a table and diagram.

    For this I have a date and a part number as the dimension and the price. The date is linked to the master calendar.

    In the raw data there are part numbers with several dates with the same price and different prices (see table).

    Example:

    PartNoDatePrice
    1100001.01.202115,50
    1100003.01.202115,50
    1100004.01.202116,00
    1100006.02.202116,10
    1100007.02.202116,10
    1100009.04.202116,10
    1100010.04.202113,00

     

    In the price history, only one price change should be used.
    If the price remains the same at another point in time, it should not be displayed.

    The result should then look like this:

    PartNoDatePrice
    1100001.01.202115,50
    1100004.01.202116,00
    1100006.02.202116,10
    1100010.04.202113,00

     

    Does anyone have any idea how I can do this?

    Show Less
  • forum

    QlikView App Dev

    Qlikview Personal Edition cant open any files

    Hi! I had a few dashboards that I'd made with Personal Edition for a portfolio, and came to want to re-use them since I'm looking for work again. Unfo... Show More

    Hi! 

    I had a few dashboards that I'd made with Personal Edition for a portfolio, and came to want to re-use them since I'm looking for work again. Unfortunately trying to open them I was just met with "Failed to open" errors. 

    Hang on though! I can almost hear you linking the usual methods to fix this from here! Thank you, but none of those work! What's more, if I create a new dashboard, save it, and go to open it? I get the same issue.

    I've uninstalled QV and restarted, no good. 

    I've uninstalled, manually purged all instances of anything mentioning 'Qlik' from the registry, and restarted, no good.

     

    Qlikview just doesn't seem to be able to open any files on my machine at all? What's super frustrating is that about a month ago I managed to open one of them just fine. 

    Anyone got any other tips or suggestions? I'm kind of at my wit's end since I've got interviews coming up and I'm fairly sure they're going to ask me to see some of my work. Any help would be massively appreciated!

    Show Less
  • forum

    App Development

    Circular Loop

    Hello All,Can anyone please help me with the below scenario :-This is my Data model          I want to achieve below association:-User table linked wi... Show More

    Hello All,

    Can anyone please help me with the below scenario :-

    This is my Data model

    Aspiring_Developer_0-1627538445568.png

     

     

     

     

     

     

     

     

     

     

    I want to achieve below association:-

    User table linked with ID Card table on %IDCard

    User table linked with Activity table on %userID

    Activity table linked with ID card table on %projectID

    Right now it is creating circular. Can anyone please help me to achieve this relationship by eliminating circular loop ?

    Please help

    Thank You

    Show Less
  • forum

    New to Qlik Sense

    Monitoring App reload error

    Hello Qlik Experts,The "License Monitor" and "Operations Monitor" tasks have not been working for a few days.When I start the load script for the "Lic... Show More

    Hello Qlik Experts,

    The "License Monitor" and "Operations Monitor" tasks have not been working for a few days.

    SonPhan_0-1626957166701.png

    When I start the load script for the "License Monitor" task manually, the following error occurs:

    SonPhan_1-1626957202842.png

    Does anyone knows how to solve this problem?

    Best regards Son

    Show Less
  • forum

    New to Qlik Sense

    Compare 2 dates using IF

    Hi ExpertI have the data as below and is trying to compare the 2 dates using IF function. If Schedule End date is later than Next Due Date then it wil... Show More

    Hi Expert

    I have the data as below and is trying to compare the 2 dates using IF function. 

    If Schedule End date is later than Next Due Date then it will be Miss

    If Schedule End date is same or earlier than Next Due Date then it will be Done

    My function is as below but have problem with same month. Please help

    =If ([Schedule End Date] > [Next Due Date], 'Done', 'Miss')

     

    Schedule End DateNext Due DateMiss/Done
    25 Jan 202101 Feb 2021Done
    09 Feb 202117 Feb 2021Miss
    11 Aug 202019 Aug 2020Miss
    01 Sep 202008 Sep 2020Miss
    19 Feb 202122 Feb 2021Miss
    01 Sep 202008 Sep 2020Miss
    19 Feb 202122 Feb 2021Miss
    01 Oct 202012 Oct 2020Miss
    29 Mar 202101 Apr 2021Done
    01 Oct 202012 Oct 2020Miss
    29 Mar 202101 Apr 2021Done
    10 Feb 202118 Feb 2021Miss
    11 Aug 202019 Aug 2020Miss
    10 Feb 202118 Feb 2021Miss
    11 Aug 202019 Aug 2020Miss
    10 Feb 202118 Feb 2021Miss
    11 Aug 202019 Aug 2020Miss
    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

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.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region