Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
5,906 online
Announcements
Read about the latest Qlik Community enhancements on the Community News blog!

Welcome to Qlik Community

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

    Create field in script editor according to set analysis formula

    Hi all I have created the following formula in set analysis: if([operation number]=[max operation number] and [confirmed qty position]>0 or [goods iss... Show More

    Hi all

    I have created the following formula in set analysis:

    if([operation number]=[max operation number] and [confirmed qty position]>0 or [goods issued]>0
    ,[last OP],CONCAT({<[next OP'S]=>} DISTINCT [next OP'S],'/',[operation number]))

    This looks like:

    JoannaM_0-1634823470807.png

    What I am trying to do is to concatenate all the work center operations.

    I need to transfer this formula into script editor. How can i transfer the CONCAT({<[next OP'S]=>} DISTINCT [next OP'S],'/',[operation number]) part? I don't know where to start.

    Any suggestions? Unfortunately, I can't share any more data.

    Thanks for the input.

    BR, Joanna

     

    Show Less
  • forum

    New to Qlik Sense

    Join

    Hi, I have two tables with identical fields and want to join the fields to the first table, so that each record will have each record from the 2nd tab... Show More

    Hi,

    I have two tables with identical fields and want to join the fields to the first table, so that each record will have each record from the 2nd table. Created primary key field by using the script, RecNo() as Key. Both the tables loaded successfully and not sure why  showing script error as Key not found. Can somebody help me with the below error please. Thanks

     Product:

    SKU,

    [Standard Unit],

    RecNo() as Key

    from ........;

    Hierarchy:

    RecNo as Key,

    ProdID,

    ProductName

    From ........;

    Join Code 

    Left Join (Product)

    Load

    Key,

    Product ID,

    Product Name

    Resident Hierarchy;

    Show Less
  • forum

    Connectivity & Data Prep

    Qlik Data Modeling Training

    What some resources that have helped you develop your data modeling? I purchased a few Qlik tutorials on Udemy but find that the complexities of rea... Show More

    What some resources that have helped you develop your data modeling? I purchased a few Qlik tutorials on Udemy but find that the complexities of real world business application is hard to transfer.

    Just looking to the community for some advice on this and what has helped you regarding data modeling.

    Show Less
  • forum

    New to Qlik Sense

    Install qliksense on premise

    Hi All, I am interested to understand if qliksense can be installed on premise? If so, does it run only on Windows servers? Or can it be installed e... Show More

    Hi All,

    I am interested to understand if qliksense can be installed on premise? If so, does it run only on Windows servers? Or can it be installed even on Linux servers?

    Show Less
  • forum

    App Development

    Showing results based on dimension

    I'm guessing there's an easy solution to this.... Assume I have survey results showing who owns what kitchen items, e.g. in the table below a 1 is Yes... Show More

    I'm guessing there's an easy solution to this....

    Assume I have survey results showing who owns what kitchen items, e.g. in the table below a 1 is Yes:

    Item

    Respondent

    YesNo

    Pots

    John

    1

    Pots

    Sue

    1

    Pots

    Alan

    1

    Pans

    John

    0

    Pans

    Sue

    0

    Pans

    Alan

    1

    Forks

    John

    1

    Forks

    Sue

    0

    Forks

    Alan

    1

    Spoons

    John

    0

    Spoons

    Sue

    1

    Spoons

    Alan

    0

    Salt

    John

    0

    Salt

    Sue

    0

    Salt

    Alan

    1

    Pepper

    John

    1

    Pepper

    Sue

    0

    Pepper

    Alan

    0

     

    Next I create a bar chart with dimension Item vs sum(YesNo).

    Now suppose I create a dropdown where the user can select an Item, and I now want the bar chart to show the same distribution of sum(YesNo) for each Item, but only for those who responded Yes to owning the Selection in the drop dropdown.  In other words, if Fork is selected in the dropdown, the chart would show the distribution of all Items owned by John and Alan (who own forks).  How would I implement that?  

    I created a dropdown to populate a variable vItem, but wasn't sure how to use that in a bar chart expression.  Or should I be using an entirely different approach?

     

    Show Less
  • forum

    Search the Community

    Criação de qvd dando erro

    Boa tarde! Pessoal preciso de uma ajuda... Criei a conecção e fiz o load de uma planilha simples (teste.xlsx) e nomei a tabela como (dados:), deu cert... Show More

    Boa tarde!

    Pessoal preciso de uma ajuda...

    Criei a conecção e fiz o load de uma planilha simples (teste.xlsx) e nomei a tabela como (dados:), deu certo na hora da carga. Mas quando eu introduzi o código (usei o store...into) para gerar um arquivo qvd (teste.qvd) ele está dando um erro (Cannot open file...Native Path...), eu já o fiz de diversos modos, inclusive segui a sugestão de outros posts aqui de mesmo tema, mas nenhum resolveu.

    ThiagoGSilva_0-1635014165924.png

    ThiagoGSilva_1-1635013148131.png

    Desde de já agradeço!

    Show Less
  • forum

    New to Qlik Sense

    where not Exists

    Dear Experts, Can anyone please explain with example, how i can use where not exist statement in qlik. I know how we use that statement in SQL. But i ... Show More

    Dear Experts,

    Can anyone please explain with example, how i can use where not exist statement in qlik.

    I know how we use that statement in SQL.

    But i am confuse with qlik.

     

    Thanks in Advance😊

     

     

    Show Less
  • forum

    Qlik Cloud Data Services

    url / network path for images -Qlik Saas

    hi all, trying to add product / country image on a table through Qlik Saas.. i.e : 'https://cdn.countryflags.com/thumbs/zimbabwe/flag-400.png'   any ... Show More

    hi all,

    trying to add product / country image on a table through Qlik Saas..

    i.e : 'https://cdn.countryflags.com/thumbs/zimbabwe/flag-400.png'

    ilanbaruch_0-1634983857735.png

     

    any ideas ?

    advanced thanks

    Show Less
  • forum

    QlikView App Dev

    Stacked bar chart

    Hello guys. I am new at QlikView so i need a detailed description as possible. I want to create a stacked bar like the pic i will attached. (green=pas... Show More

    Hello guys.

    I am new at QlikView so i need a detailed description as possible.

    I want to create a stacked bar like the pic i will attached.

    (green=pass, yellow=maybe , red=not pass)

    Screenshot 2021-10-23 163004.png

     I want the average of 3 for each previous year and the average for every current month.

    Thanks in advance.

    Show Less
  • forum

    QlikView App Dev

    Generate a field

    Hi all, I have as an example the following table in excel to load: a b c d 1 1 0 3 2 1 0   3 1     4         I want to load this table a... Show More

    Hi all,

    I have as an example the following table in excel to load:

    a b c d
    1 1 0 3
    2 1 0  
    3 1    
    4      

     

    I want to load this table an to create new field DRIVER to it such that:

    DRIVER

    a b c d
    MAIN 1 1 0 3
    MAIN 2 1 0  
    MAIN 3 1    
    MAIN 4      

     

    How can I do it?

     

     

    Thanks in advance

    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