Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 182,371 members
  • 2,686 online
  • 1,735,937 posts
  • 132,848 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

    App Development

    How can we use small function from Excel into Qliksense

    How can we use small function from Excel into Qliksense 
  • forum

    Qlik Enterprise Manager

    LSS task not capturing "updates"

     Hello  i have a task setup from source (Microsoft SQL server) to target (Microsoft SQL server). there are three tables of which two are transactional... Show More

     Hello 

    i have a task setup from source (Microsoft SQL server) to target (Microsoft SQL server). there are three tables of which two are transactional data and i have noticed that for one of the tables, updates are not captured. Inserts and deletes are the only change processing that the LSS captures for one of the tables. This has led to discrepancies when queries are run and comparedon both the source DB and the target DB as the updates made on the source DB are not captured on the LSS task. 

    A column in the table on the source DB may have 0 as the value but later it gets updated to a 1, this action/change doesnt get effected on the target DB so that particular records remains 0 on the target DB.

    Has any encountered this challenge before 

    Show Less
  • forum

    New to Qlik Sense

    Need correct syntax for date modifier

    I'm trying to create an expression that says - if the field [Projected Close Date] is 370 days or more in the future, sum the combined_amount. Here is... Show More

    I'm trying to create an expression that says - if the field [Projected Close Date] is 370 days or more in the future, sum the combined_amount. Here is what I've written, but it isn't correct. What am I doing wrong?

     

    Sum({<Date#([Projected Close Date])>={Date#(Today())+370}>}Combined_Amount)

    Show Less
  • forum

    App Development

    Set anaylisis for Pivot Table

    Hello to all   I have a list of cusomer with quantity, date, region, sub region and Sales responsible. I woul like to do a pivot table  with region, s... Show More

    Hello to all

     

    I have a list of cusomer with quantity, date, region, sub region and Sales responsible. I woul like to do a pivot table  with region, sub region and Sales reps in row and column of month. The data to be displayed are the sum of quantities realized in 2023 for the customer that did not had any sales during the last to years (Q= 0)

     

    i have tried the follong formula bu it does not work at all

    =if(aggr(sum({< YEAR= {"<=$(Vannee-1)"},NO_CUST=,MONTH=>}Q),NO_CUST<=0,
    sum({< YEAR= {"$(Vannee)"}, NO_CUST=, MONTH=>}
    Q),0)

     

    I have added in excel cause it shows in the pivot what i want.

     

    Thanks in advance....

    Show Less
  • forum

    App Development

    if statement

    Hello, I have default data that looks like below, where for each order id i can have multiple values in field (Initial Status): OrderID Initial Sta... Show More

    Hello,

    I have default data that looks like below, where for each order id i can have multiple values in field (Initial Status):

    OrderID Initial Status New Status Orders
    Order 1 Approved Approved 1
    Canceled Approved 0
    Declined Approved 0
    WIP Approved 0
    Order 2 WIP WIP 1
    Canceled WIP 0
    Declined WIP 0
    Order 3 Declined Declined 1
    Canceled Declined 0
    Order 4 Canceled Canceled 1

     

    I want to count unique orders depending on values inside status field : if status = approved, count it only once, no matter what other status this order has or return a new status as 'approved';  The 4 orders from above are 4 situations possible.

    Thank you in advance for your help!

    Show Less
  • forum

    Qlik Replicate

    File Source: Processing full load files using Qlik Replicate

    Hi Team, I am facing issues while loading full loading file with Qlik Replicate. I have explained the issue in given steps below: Full File load every... Show More

    Hi Team,

    I am facing issues while loading full loading file with Qlik Replicate. I have explained the issue in given steps below:

    Full File load every time >> Frequency will be for every one hour  >> Need to process latest files for every one hour

    In my requirement, we used to receive the files from vendor with full set of files for every one hour, in that case they used to keep on appending the files in same location for every one hour, so Qlik replicate either to identify the latest files & to process them, or i do need to archiving the files manually after processing through Qlik Replicate every one hour which is again tricky since we don't predict when files arrives at source.

    I am facing issue in identifying the options for full load with given options in Qlik Replicate, hoping can someone from Qlik support could help me on this.

    Thanks in advance!!!

    Show Less
  • forum

    Qlik Replicate

    File Sources: How do we move the files after processing them?

    Hello, we have some tasks that read delimited text files as sources and put them into MS SQL target. Is there a way to move the files to a different l... Show More

    Hello, we have some tasks that read delimited text files as sources and put them into MS SQL target.

    Is there a way to move the files to a different location(Folder) after they have been processed successfully?

    E.g. The files are dropped in F:\Share\Source and then after processing must be moved to F:\Share\Processed

    I have tried to set the values that I found on the Endpoint Connection itself, Under Change Processing Cleanup, but this doesn't seem to want to work for me. Nothing happens.

    We are using: Qlik Replicate May 2021 (2021.5.0.1272), running on Windows Server 2019 in Azure

    Qlik Replicate 

     

     

    Show Less
  • forum

    New to Qlik Sense

    QMC application blank search

    I have an application in the name like as "application  1" but when i search like  "  " the application "application  1" is not picked up.    why just... Show More

    I have an application in the name like as "application  1"

    but when i search like  "  " the application "application  1" is not picked up. 

     

    why just space is allowing to pickup the application that has a space.  

     

    even in the root admin column of qmc application, I am unable to sort by blank values? is there a way to accomplish this . 

     

     

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    DW lookup - I want to lookup in the target DB (not source)

    I want to map a column using a lookup to a view column located in the DW (not in the source). The GUI does allow the Data Warehouse to be selected as ... Show More

    I want to map a column using a lookup to a view column located in the DW (not in the source). The GUI does allow the Data Warehouse to be selected as a source for the lookup. Please advise.

    Show Less
  • forum

    New to Qlik Sense

    How to get the stock value from previous row

    Hi Everyone, Please help me to find the formula script based on previous row. Now I want to calculate the stock for all the months and the formula is ... Show More

    Hi Everyone,

    Please help me to find the formula script based on previous row.

    Now I want to calculate the stock for all the months and the formula is :

    ((currentMonthProduction * Previous month stock) + (current month Sell )) / (Previous month production - current month production)

    Let me give an example of how the data is

    eddykwan__0-1658130982450.png

     

    Please help me to write this script?

    Thank you

    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