Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 187,399 members
  • 13,810 online
  • 1,743,201 posts
  • 133,789 Solutions
Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: 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!

Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.

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

    I only need MeasureValue where MeasureNo = 1,2,3,4,5

    I have a field 'MeasureNo ' , 'MeasureValue' , 'WorkOrder' in field  'MeasureNo' contains data  '1' , '2', '3' ,'4', '5', ' Tank' I only need Measure... Show More

    I have a field 'MeasureNo ' , 'MeasureValue' , 'WorkOrder'

    in field  'MeasureNo' contains data  '1' , '2', '3' ,'4', '5', ' Tank'

    Sxbbb_0-1679386426945.png

    I only need MeasureValue where MeasureNo = 1,2,3,4,5

     

    Now I tried the formula but the value is incorrect:

    Sum({<MeasureNo={1}, MeasureNo={2}, MeasureNo={3},MeasureNo={4},MeasureNo={5} > } (Aggr(if(Max(MeasureValue) <= CuMax and Min(MeasureValue) >= CuIMin ,Count(WorkOrder)),WorkOrder)))

     

     

     

     

    Show Less
  • forum

    Qlik NPrinting

    Error during report generation

    Sometimes (inconsistent) I get a warning about an exception during content resolution while processing request with id ......... Check engine logs for... Show More

    Sometimes (inconsistent) I get a warning about an exception during content resolution while processing request with id ......... Check engine logs for details. Error: Access to path ........... is denied. 

    This is followed by another message: 

    Failed generation of report .......... for user .............. ERROR: Exception during content resolution while processing request with id ...................... Check Engine logs for details. ERROR: Access to the path .............................. is denied.

    What can I do to make this task reliable and generate the reports more consistently?

    Show Less
  • forum

    Qlik Replicate

    failed to load data from SQL server to MYSQL

    Hi,  while replicating data from SQLServer to MYSQL, am facing the below issue.   Failure in starting (with TXN consistency...) Failure validating ini... Show More

    Hi, 

    while replicating data from SQLServer to MYSQL, am facing the below issue.

     

    Failure in starting (with TXN consistency...) Failure validating initial LSN 'anywhere existance' mssql_lsn_anywhere_validator(...)Failed in looking at Active TLOG lsn_exists(...)Failed in statement execution for looking at Active TLOG RetCode: SQL_ERROR SqlState: HY000 NativeError: 9003 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The log scan number (60:376:5) passed to log scan in database 'sample1' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. Line: 1 Column: -1 Failed (retcode -1) to execute statement: 'select top 1 [Current LSN] from fn_dblog('0x0000003c:00000178:0005','0x0000003c:00000178:0005')'

     

     

    Show Less
  • forum

    New to Qlik Sense

    How do split/convert data from a cell into specific length data?

    Say I have a field called account number and it is  "12398760234535345" but I want to convert it into "123-9876-023" in the script area. How would I d... Show More

    Say I have a field called account number and it is  "12398760234535345" but I want to convert it into "123-9876-023" in the script area. How would I do that? 

    Data is coming from excel, I would change the edited data to [Account Number] AS Account_Number

     

    Show Less
  • forum

    New to Qlik Sense

    How to load the data of latest date, then rename the sheet with latest data?

    How to load the data of latest date, then rename the sheet with latest data? Datasource: currently I need the data of "DC TJ Inventory_20230319", Loa... Show More

    How to load the data of latest date, then rename the sheet with latest data?

    Datasource:

    My_Rebecca_0-1679360620498.png

    currently I need the data of "DC TJ Inventory_20230319",

    Load

    ******

    FROM [DC TJ Inventory_*.XLSX]
    (ooxml, embedded labels, table is Sheet1)
    Where max(TextBetween(FileName(),'_','.') )

    But this does not work. How to script this?

    Then I need to rename the sheet like this, how to realize it? Many thanks.

    My_Rebecca_1-1679360837880.png

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Data load from flat file issue

    Hi When I am loading below pivot table from excel, the respective dimension details are not showing as in in qliksense. In qliksense I have taked two... Show More

    Hi 

    When I am loading below pivot table from excel, the respective dimension details are not showing as in in qliksense.

    Qlik_FZ_0-1679380609727.png


    In qliksense I have taked two filter object one for Department dimension and another is for OBJ_ID.
    If you can see both of the OBJ_ID associated with one department as information technology.

    So, If I select OBJ_11 then it is showing respective department as information technology but when I am selecting OBJ_12 none of the department is displaying.

    Show Less
  • forum

    Qlik Replicate

    How do I know data has changed?

    I am using an Oracle DB as source endpoint and replicate into a Microsoft SQL Server 2019 target endpoint. The documentation explicitly states that ql... Show More

    I am using an Oracle DB as source endpoint and replicate into a Microsoft SQL Server 2019 target endpoint.

    The documentation explicitly states that qlik replicate will not fire any triggers in the target DB.

    How do I keep track of changes and react to new/changed data?

    I need to process new data as soon as it is replicated into my target db, with minimum delay.

    Show Less
  • forum

    New to Qlik Sense

    Previous Month expression

    I have set the following  expression: (Sum({<Month={'$(=Max([Month], 'YYYY-MM'))'}>} Revenue)/Sum({<Month={'44927'}>} Revenue))-1 where {<Month={'$(=M... Show More

    I have set the following  expression:

    (
    Sum({<Month={'$(=Max([Month], 'YYYY-MM'))'}>} Revenue)
    /
    Sum({<Month={'44927'}>} Revenue)
    )
    -1

    where {<Month={'$(=Max([Month], 'YYYY-MM'))'}>} is Current Month

    How can I set a similar expression for calculating Previous Month?  I tried this but it doesn't work:

    {<Month={'$(=Max([Month]-1, 'YYYY-MM'))'}>}

    Show Less
  • forum

    New to Qlik Sense

    How to get total sales amount by sales person and cust. And also get sum of top ...

    Hi everyone, I am trying to show  sales amount of total by customer and also sum of top 10 sales person's sales amount. then calculating the percentag... Show More

    Hi everyone,

    I am trying to show  sales amount of total by customer and also sum of top 10 sales person's sales amount. then calculating the percentage like-top 10 sales amt/Total sales amt.

    I need to calculate all the 3 measures.

    I have sales person as well in dataset but do not want to show in table.

    I used rank function but failed to do that.

    Please provide your help. sample of data are given below.

    Customer Total Sales amt
    by sales person
    top 10 sales amt
    by sale person
    top 10 sales amt/Total sales amt
    cust1 1,000.0 800.0 80.0%
    cust2 800.0 500.0 62.5%
    cust3 600.0 300.0 50.0%
    cust4 700.0 100.0 14.3%
    cust5 200.0 180.0 90.0%
    cust6 500.0 400.0 80.0%
    cust6 100.0 60.0 60.0%
    Grand Total 3,900.0 2,340.0 60.0%

     

    Show Less
  • forum

    Reporting Service

    QLIK Sense upgrade

    Hi i have Qlik Sense June 2019 version how to upgrade to the latest version??

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, Technical Workshops!

10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!

Choose your workshops

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