Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,662 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

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

    New to Qlik Sense

    If calculation

    Hi Everyone,I am trying to set the background color based on the IF statement. I'm not sure if I can combine multiple conditions within the IF stateme... Show More

    Hi Everyone,

    I am trying to set the background color based on the IF statement. I'm not sure if I can combine multiple conditions within the IF statement or not? Because calculation works fine when I run it separately along with the indicator, it doesn't work while I combine it with the IF clause. Please see the calculation below, and help me with fixing it. I have set up the indicator as a variable.

    if (Only({<Goal_Metric={'Computer'}>} [Goal]) > sysvalue >= Sum({< Plan_Quarter ={'$(=MaxString(Plan_Quarter))'},[Plan_Metric]={'Computer'}>} [Plan_Value]), '$(vC_LightIndicator)')

    Note: sysvalue is also a calculated field.

    I'm trying to calculate if goalvalue > sysvalue >= planvalue then show this background color

    Any suggestion is greatly appreciated!

    Show Less
  • forum

    Qlik Replicate

    Salesforce to MSSQL (Replicate)

    Hi ,I am replicating data from Salesforce to MSSQL.When I start the task it runs successfully but when I stop the same task and resume it I get the be... Show More

    Hi ,

    I am replicating data from Salesforce to MSSQL.

    When I start the task it runs successfully but when I stop the same task and resume it I get the below error.

    nikhilraorane_0-1632459269193.png

    on checking the logs I get the below error.

    nikhilraorane_1-1632459445263.png

     

     

    Thanks & Regards,

    Nikhil Raorane

    Show Less
  • forum

    QlikView App Dev

    Data Mapping Issue

    Hi All,Can some help me with below scenario..I have 2 tables 1. Employ table with employ no, country and date(date when he was present in that country... Show More

    Hi All,

    Can some help me with below scenario..

    I have 2 tables 

    1. Employ table with employ no, country and date(date when he was present in that country).

    Emp_NoEmp_Start_DateCountry
    10017/05/2008UK
    10004/02/2009US
    10009/07/2010AUS

      2. Insider table with employ no, incident number(issues he worked on) and incident_created_date(when that issue was raised).

    Emp_NoIncident NumIncident_Created_date
    1001017/05/2007
    1002017/05/2007
    1003031/07/2007
    1004007/05/2008
    1002311/06/2008
    1003211/06/2008
    1001112/01/2009
    1002104/02/2009
    1003114/01/2010
    1002418/06/2010
    1005309/07/2010

     

    Now i want to join both the tables and get Country field in Insider table. 

    Based on Incident_Created_date <= Emp_Start_Date

    i.e.  for Incident_Created_date <= 17/05/2008 Country should be UK

             Incident_Created_date <= 04/02/2009 Country should be US

            Incident_Created_date <= 09/07/2010 Country should be AUS

    Emp_NoIncident NumIncident_Created_dateCountry
    1001017/05/2007UK
    1002017/05/2007UK
    1003031/07/2007UK
    1004007/05/2008UK
    1002311/06/2008US
    1003211/06/2008US
    1001112/01/2009US
    1002104/02/2009US
    1003114/01/2010AUS
    1002418/06/2010AUS
    1005309/07/2010AUS

     

    Thanks in Advance,

    Show Less
  • forum

    New to Qlik Sense

    Sum YTD

    I'm trying to create a cumulative sum for YTD based on a user's selectionThe user selects PeriodYear (an integer value), PeriodMonth (integer from 1-1... Show More

    I'm trying to create a cumulative sum for YTD based on a user's selection

    The user selects PeriodYear (an integer value), PeriodMonth (integer from 1-12), so I would like the sum(Amount) from month 1 to the users selection. I've been trying solutions suggested online and I simply can't get this to work, any help would be really appreciated.

    Show Less
  • forum

    Qlik Replicate

    Replicate data to azure Synapse

    Getting below error after I run my task to replicate data from MSSQL db to Azure synapse analytics. Failed to check if credential 'ATTREP_CN_G2_Landin... Show More

    Getting below error after I run my task to replicate data from MSSQL db to Azure synapse analytics.

     

    Failed to check if credential 'ATTREP_CN_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc' exists
    Failed to drop external data source: 'ATTREP_DS_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc'
    Failed to create and execute: 'DROP EXTERNAL DATA SOURCE [ATTREP_DS_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc];'
    RetCode: SQL_ERROR SqlState: 42000 NativeError: 15151 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the object 'ATTREP_DS_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc', because it does not exist or you do not have permission. Line: 1 Column: -1
    Failed (retcode -1) to execute statement: 'DROP EXTERNAL DATA SOURCE [ATTREP_DS_G2_LandingDB_a64ccacb_b768_f449_b56c_40a50a2a2cbc];'
    Show Less
  • forum

    New to Qlik Sense

    Without selection previous quarter in pie chart dynamically

    Hii Guys,I have pie chart, I want to show the previous quarter values in pie chart without any selection by expression its change dynamic,when user op... Show More

    Hii Guys,

    I have pie chart, I want to show the previous quarter values in pie chart without any selection by expression its change dynamic,when user open the dashboard ,with selection it's show accordingly.

    Can help me this anyone please.

    Thanks in advance.

    Regards,

    Subba

    Show Less
  • forum

    App Development

    QlikSense load and use images from database

    Does anyone know how to load and render images from some database in Qlik Sense?I tried to follow steps from the brochure "Qlik Sense Loading Images f... Show More

    Does anyone know how to load and render images from some database in Qlik Sense?

    I tried to follow steps from the brochure "Qlik Sense Loading Images from Databases", but didn't get any result (Map Object doesn't render anything).

    Show Less
  • forum

    App Development

    Script Load rows for to 4 Values in field

    I need to load only rows which fall into the top 4 values in a fieldRisks:RiskIDScore123450123524123645123745123827123932124035 So for the above table... Show More

    I need to load only rows which fall into the top 4 values in a field

    Risks:

    RiskIDScore
    123450
    123524
    123645
    123745
    123827
    123932
    124035

     

    So for the above table, I only need to load RiskID 1234, 1236, 1237, 1239, 1240 as the scores fall into the top 4 for the field

     

    |Regards

     

    Show Less
  • forum

    New to Qlik Sense

    Sum YTD

    I'm a little embarrassed to be asking, but I'm having some issues creating a year to date sum using Set Expression. I have a field Amount that I would... Show More

    I'm a little embarrassed to be asking, but I'm having some issues creating a year to date sum using Set Expression.

     

    I have a field Amount that I would like to do a YTD sum, with dates ranging from 01/2021 to 12/2021 called FinPeriod. I've been scratching my head all afternoon trying to come up with the expression and it's just not coming together, could someone please point me in the right direction?

     

    Cheers

    Show Less
  • forum

    New to Qlik Sense

    How to create a stacked bar chart coming from 2 tables - Qlik sense

    Hi All! I have a two tables. I have created stacked bar chart from 1 table. I want to add one more on this stacked bar chart and the amount is coming ... Show More

    Hi All! 

    I have a two tables. I have created stacked bar chart from 1 table. I want to add one more on this stacked bar chart and the amount is coming from a different table. 

    manisha10_0-1632381448504.png

    Stacked bar chart from table 1: 

    manisha10_1-1632381472191.png

    Desired Output: 

    manisha10_2-1632381522587.png

     

    Thank you!

    Qlik Sense Business 

    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