Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
7,808 online
Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

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

QlikWorld 2022

This year’s go-to data event is full of inspiring speakers, informative sessions, ideas for up-leveling your data integration and analytics.

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

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

  • No Boards Found
  • forum

    Brasil

    Somar todos os totais de Saldo

    Boa tarde, Preciso de uma ajuda da comunidade, parece ser simples a solução porém oque eu fiz não deu certo aqui. O que tenho hoje é essa tabela, e o ... Show More

    Boa tarde,

    Preciso de uma ajuda da comunidade, parece ser simples a solução porém oque eu fiz não deu certo aqui. O que tenho hoje é essa tabela, e o resultado final que preciso é a abaixo:

    grazielegretter_0-1638818726178.png

    O que acontece, tenho somente a ligação do código do item entre as duas tabelas, os campos Saldo Material e Quantidade Material pertencem a tabele estoque, e os campos pedido quantidade e pedido saldo a tabela Pedido Compra.

    O resultado final que preciso é esse abaixo, onde o Saldo Material e Quantidade Material  devem aparecer indepentede do filtro nesse valor, o valor total do que há. Pois minha ideia é mostrar o valor total de estoque, comparado o que foi pedido (Pedido Compra, Mês-Ano, item)

    grazielegretter_1-1638818963190.png

     

    Show Less
  • forum

    Brasil

    Totalizando Soma

    Bom dia, Algumas vezes noto que quando faço uma simples expressão como: sum(qtd)*preço  o campo totalizador da tabela aparece em branco. mudo para sum... Show More

    Bom dia,

    Algumas vezes noto que quando faço uma simples expressão como:

    sum(qtd)*preço 

    o campo totalizador da tabela aparece em branco.

    mudo para

    sum(qtd*preço)

     e ai funciona, mas as vezes o valor está errado.

    Parto para uma expressão com o AGRR, mas que quando preciso fazer com uma multiplicação acabo me perdendo.

    Qual seria a forma correta para usar em uma tabela dinâmica?

     

     

    Show Less
  • forum

    New to Qlik Sense

    Azure blob storage folders

    Hello everyone,Has anyone ever needed to recursively read folders in azure blob storage? There is a difference between reading folders/files in this l... Show More

    Hello everyone,
    Has anyone ever needed to recursively read folders in azure blob storage?
    There is a difference between reading folders/files in this location, than reading locally using filelist.

    Show Less
  • forum

    App Development

    Qlik Sense App crashes the engine when setting field as always one value selecte...

    Hello, we recently upgraded from April 2020 to Nov 2021. We found that when we set a field as "Always one value selected" in a particular app, the Eng... Show More

    Hello,

    we recently upgraded from April 2020 to Nov 2021.

    We found that when we set a field as "Always one value selected" in a particular app, the Engine soon crashes.

    We also tried using a backup saved before the upgrade, but the problem persist.

    We didn't experience engine crashes with April 2020.

    Is there a way to diagnose the problem?

    Thank you very much,

    Gianluca Ferri

     

    Show Less
  • forum

    QlikView App Dev

    QlikView Set Analysis AND OR Conditions

    HI Can someone help me with set expression for below   Sum(sales)WHERE exclusion_category = 'Exception' AND SEGMENT = 'Banking' AND(mrkr_set = 'Y'or o... Show More

    HI

    Can someone help me with set expression for below

     

    Sum(sales)
    WHERE exclusion_category = 'Exception' 
    AND SEGMENT = 'Banking' 
    AND
    (mrkr_set = 'Y'
    or offset_ind='Y'
    or dbt_ind='Y'
    or actv_acct='Y'
    or mgmt_ind = 'Y'
    or refer_mrkr=0
    )


     written expression like below , didn't get the desired results

    sum({<exclusion_category={'Exception'},SEGMENT={'Banking'}> *
    <mrkr_set_S={'Y'}> + <offset_ind={'Y'}> + <dbt_ind={'Y'}> + <actv_acct={'Y'}> + <mgmt_ind={'Y'}> + <refer_mrkr={'0'}>}sales)

    Show Less
  • forum

    Integration, Extension & APIs

    Creation of slides, slideItems and embedded snapshots

    Hi ! I am trying to create stories from a mashup, after spending days  trying from nebula.js, I followed the instructions at https://help.qlik.com/en-... Show More

    Hi !

    I am trying to create stories from a mashup, after spending days  trying from nebula.js, I followed the instructions at https://help.qlik.com/en-US/sense-developer/November2021/Subsystems/EngineAPI/Content/Sense_EngineAPI/BuildingAStory/add-snapshot.htm  and followed it step by step from the Engine Api Explorer.

    I succeeded in creating the stories, and slides.  Both appear in the front end, but the final 2 steps (create the slideItem and embed the snapshot in it) don't work. Also, when I try to add objects from the frontend to the created slides, they don't show.

    Do anybody had a successful experience with creating slides and embedding snapshot from nebula or from the rpc-json API ?

    Thanks in advance for any help

    I use Qlik sense server v. 13.102.5

    Show Less
  • forum

    New to Qlik Sense

    Overall Percentage for current month in KPI

    Hii, I want  to show the comparison of Budget Vs sales in dashboard for current month . my requirement is show in KPI for Overall budget %, Overall sa... Show More

    Hii,

    I want  to show the comparison of Budget Vs sales in dashboard for current month .

    my requirement is show in KPI for Overall budget %, Overall sales % and Overall Budget vs sales % for current month.

    Overall means (including all items )

    my current Year = 2009

    my current month= Apr

    help me ..

    Thanks in advance...

     

    my data like this..my data like this..

    Show Less
  • forum

    New to Qlik Sense

    NPrinting Excel reports

    Hi All, I am new to NPrinting so please help me in resolving below error IN Qlik NPrinting when we drag a column to the excel template then after prev... Show More

    Hi All,

    I am new to NPrinting so please help me in resolving below error

    IN Qlik NPrinting when we drag a column to the excel template then after previewing the data comes in a column but my requirement is that I need this data in a row. Like we do the transpose operation in excel while pasting.

    EG: IN QS I have a column, when I drag it to Nprinting it comes as

    RollNo

    1

    2

    3

    But I want this column to be displayed as row

    like : RollNo 1 2 3

    How can I achieve in Qlik NPrinting itself or any perfect solution with work around

     

    Show Less
  • forum

    QlikView App Dev

    Problem storing QVW file (Qlik Desktop and Qlikview Server)

    Hi, We have 2 diferente servers with Qlikview server April 2020 Sr3 and Qlikview Desktop 12.50. One of them was installed a feew days ago to replace t... Show More

    Hi,

    We have 2 diferente servers with Qlikview server April 2020 Sr3 and Qlikview Desktop 12.50. One of them was installed a feew days ago to replace the old one. Every month qlikview run a process to cosolidate historial information in a single qvw, this file size is over 27 GB.

    On the old server, the process runs without problems, RAM resources and CPU goes to 100% but it works fine and system stores qvw without problems. in the new machine this process takes the same time when it runs on Qlikview desktop but the problem occurs when we try to store this qvw file becase it stops on 2GB and information is not stored completely.  Additionally if the qlikview administration console is open, it closes when trying to record the  qvw  file even while saving operation is processed by qlikview desktop.

    The new machine has 180GB of disk free space and the old one has only 55GB.

    Attached to this message you can see the machine resources and their differences are locaten on windows server version because the new one has Windows Server 2019 and the old one has Windows Server 2008.

    When this new server are storing the and ends this storing process

    Somebody can help me?   

     

    Show Less
  • forum

    New to Qlik Sense

    Count Unique Match and Exclude in the same set analysis

    Hi all, I am needing to count distinct account_num but from three different tables but I also need to exclude the count if they appear in another tabl... Show More

    Hi all,

    I am needing to count distinct account_num but from three different tables but I also need to exclude the count if they appear in another table. I have been using P() for those that match up, but I am having issues on count distinct excluding those in common.

    For example: table1 = new customer, table2 = existing customer, table3 = lost customers. 

    count({<Table3_account_num=P(table1_account_num), table3_account_num=-P(table2_account_num)>}distinct table3_account_num)

    I put a '-' before the P because E() was returning zero and thought at a strech this might work, which it doesn't. 

    I should mention all my tables are separate, they are linked by any key. 

    essential I want to say, count distinct all account_nums that are in table 3 that are also in table1, but if an account_num is in table 2 then ignore it from the count. 

     

    Any help would be great,

    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