Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,062 online
Announcements
3 Keynotes, 100+ Breakout Sessions, 1 New York Times bestseller, and you. QlikWorld Online, May 10-12: REGISTER NOW

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

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.

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.

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.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    Search the Community

    How to send automated email in Qlik Sense?

    Hello everyone,I'm looking for an easy to use solution to send my reports by email regularly.I would like to receive my reports by email once a month ... Show More

    Hello everyone,

    I'm looking for an easy to use solution to send my reports by email regularly.
    I would like to receive my reports by email once a month and take into account the modifications without having to recreate a sending each time.
    In short, I will need a solution to automate the sending of my reports by email.
    I've looked into NPrinting, but it's a bit out of my price range.

    Do you have another miracle solution for me?

    Thanks in advance!

    Quentin

    Show Less
  • forum

    New to Qlik Sense

    Ignore one dimension while doing the count

    Hello Everyone,Good day!!i have data like below,.i would like to do count of ID by ignoring the "App ID" column in script level.For example, in below ... Show More

    Hello Everyone,

    Good day!!

    i have data like below,.

    i would like to do count of ID by ignoring the "App ID" column in script level.

    For example, in below if i write code has Count(ID) by group by ID then for ID 250,400 i will get count has 2 and for remaining IDs will get count has 1. But here i would like to ignore the App ID column while doing the count then i will get count has 1 for ID 250.

    And this i wants achieve without using distinct , because in my data there are some cases where i have same ID for 2 Names (ex:- Id 400).

    Request you to help and let me know if you need any other information

    IDNameAPP ID
    250Hari102
    250Hari105
    350Sai103
    400Sat104
    400Sham109
    Show Less
  • forum

    GeoAnalytics

    Apresentar valor Travado

    Caros, Boa noite, Estou montando um Dashboard para empresa e temos que calcular remuneração de produto vendido, com isso temos varias regras e uma bas... Show More

    Caros, 

    Boa noite, 

    Estou montando um Dashboard para empresa e temos que calcular remuneração de produto vendido, com isso temos varias regras e uma basicamente é...

     

    Tenho a quantidade de Produtos vendidos e o valor unitário desse produto, em certo ponto preciso calcular um fator de Bônus que é baseado no resultado geral da empresa sem considerar resultado individual de produto. 

    Basicamente é que por um % atingido no calculo geral da empresa 19,51% deveria ter um fator de bônus 0.1 para todos os produtos, porem quando realizo a inclusão na tabela cada produto calcula um % em relação ao 19,51% (uma representação dentro desse universo de 100% (19,51%) com isso alguns ficam com bônus de faixa de 20% quando a empresa ganha pelo geral que seria 19,51%

    vou deixar uma imagem para facilitar, eu precisaria que cada produto em sua linha tenha o atributo do fator em relação ao geral da empresa (19,51%)

    Show Less
  • forum

    Qlik Replicate Discussions

    how to process null values from DB2 z/os to S3 bucket with replicate

    There is space value in db2 z/os (version 11 CM) columns,  our target end is s3 bucket below are our settings in the end point, and we have get weird ... Show More

    There is space value in db2 z/os (version 11 CM) columns,  our target end is s3 bucket below are our settings in the end point, and we have get weird values in our target csv files such as : "|||"US" , how should I change the settings to get the correct value? Thank you.

    Format: csv

    Field Delimiter: |

    Null value:

    Escape character:

    Record delimiter:\n

    Quote character: "

     

     

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    Way to schedule same report for diifferent surgeon ?

    Hi All,I have a report name Surgeon Level Report in Nprinting.How can I schedule reports for each surgeon that means each surgeon will only receive th... Show More

    Hi All,

    I have a report name Surgeon Level Report in Nprinting.

    How can I schedule reports for each surgeon that means each surgeon will only receive their report. Where their information is highlighted.

     

    Regards

    Show Less
  • forum

    App Development

    Pipefy and Qlik Sense Integration

    Here at our company NTech, we have developed Analytics projects for customers using Pipefy (https://www.pipefy.com) and Qlik Sense.  I didn't find any... Show More

    Here at our company NTech, we have developed Analytics projects for customers using Pipefy (https://www.pipefy.com) and Qlik Sense.  I didn't find any reading on the topic, so I decided to talk here a little about the use of Qlik Sense to build analytical panels with Pipefy data through GraphQL based APIs.

    Qlik Sense has the ability to access data from a wide list of data sources, whether structured or unstructured. To access Pipefy data via the GraphQL API, we use a REST connector, native to the tool. I even wrote an article some time ago called "GraphQL: How to use the Evolution of Web APIs in Qlik Sense" (written in Portuguese).

    In this article we will cover the basic concepts, since in Pipefy we have a series of objects such as Pipes, Cards, Phases, Phases History, Labels, Tables, Records, Cards Fields, among others, as well as issues such as data pagination.

    A nice thing about Qlik Sense is that we can read all these objects individually and then store them in QVD format (data file in Qlik format) and from these QVDs build the desired views integrating all objects.

    Initially we need to define our data loads and logically have the access token already in hand.

    1st Load: List of Pipes

    We built our GraphyQL Query, according to Pipefy documentation:

     

    {"query":"{ organizations { id name created_at pipes(include_publics: true) { id name } } }"}

     

    Then we created a REST connection, parameterizing it according to the images below:

    Inserting API URL and our GraphQL query into the Request Body:

     

    f33f6805-9e22-48a0-a62f-70eb6ae84567

     

    And Inserting you Token in Query Headers:

    a668a2e1-e7e4-4185-bdf9-42813d3a1056

    Then give your connection a name (like "pipes") and save.


    Then, create another REST connection, this time to consult the Cards of our Pipe "Gestão de Trabalho Remoto". It is important to know the Pipe ID.


    2nd Load: List of Pipe Cards "Gestão de Trabalho Remoto" ID 301532736

    Again, we built our new GraphyQL Query, according to Pipefy documentation:

     

    {"query":"{allCards(pipeId:301532736){ edges { node { id title due_date current_phase {name} pipe {id} } } } } "}

     

    In this case, follow all the procedures of the 1st Load, changing only the GraphQL query in the Request Body, and save as the connection with another name (like "cards").

    We can make several loads using only a single REST connection, dynamically changing the parameters in the load script, using the WITH CONNECTION statement. However, we will not cover the use of WITH CONNECTION in this article.

    Then build the script for the two loads (pipes and cards), through the automatic generation of the connectors (Select Data).

    4bf375f7-c427-4ab8-ab4f-e29d348bbb63

    It is necessary to adjust the names of the fields so that the data model does not have conflicts and to generate the associative model correctly.

    Here are the scripts for the 2 loads:

    Pipe Script:

     

    /*
    '
    LIB CONNECT TO 'Pipes';
    
    RestConnectorMasterTable:
    SQL SELECT 
        "__KEY_data",
        (SELECT 
            "id" AS "id_u0",
            "name" AS "name_u0",
            "created_at",
            "__KEY_organizations",
            "__FK_organizations",
            (SELECT 
                "id",
                "name",
                "__FK_pipes"
            FROM "pipes" FK "__FK_pipes")
        FROM "organizations" PK "__KEY_organizations" FK "__FK_organizations")
    FROM JSON (wrap off) "data" PK "__KEY_data";
    
    [organizations]:
    LOAD    
        [id_u0] AS organization_id,
        [name_u0] AS organization_name,
        [created_at] AS organization_created_at,
        [__KEY_organizations],
        [__FK_organizations] AS [__KEY_data]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_organizations]);
    
    [pipes]:
    LOAD    
        [id] as pipe_id,
        [name] as pipe_name,
        [__FK_pipes] AS [__KEY_organizations]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_pipes]);
    Left Join(pipes)
    LOAD 
        organization_id,
        organization_name,
        [__KEY_organizations]
    RESIDENT [organizations];
    
    DROP TABLE RestConnectorMasterTable;
    DROP TABLE [organizations];
    DROP Field [__KEY_organizations] From [pipes];
    '
    */

     

    Cards Script:

     

    /*
    LIB CONNECT TO 'Cards';
    
    RestConnectorMasterTable:
    SQL SELECT 
        "__KEY_data",
        (SELECT 
            "__KEY_allCards",
            "__FK_allCards",
            (SELECT 
                "__KEY_edges",
                "__FK_edges",
                (SELECT 
                    "id" AS "id_u0",
                    "title",
                    "due_date",
                    "__KEY_node",
                    "__FK_node",
                    (SELECT 
                        "name",
                        "__FK_current_phase"
                    FROM "current_phase" FK "__FK_current_phase"),
                    (SELECT 
                        "id",
                        "__FK_pipe"
                    FROM "pipe" FK "__FK_pipe")
                FROM "node" PK "__KEY_node" FK "__FK_node")
            FROM "edges" PK "__KEY_edges" FK "__FK_edges")
        FROM "allCards" PK "__KEY_allCards" FK "__FK_allCards")
    FROM JSON (wrap off) "data" PK "__KEY_data";
    
    [cardpipe]:
    LOAD    
        [id] as pipe_id,
        [__FK_pipe] AS [__KEY_node]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_pipe]);
    
    [current_phase]:
    LOAD    
        [name] as current_phase_name,
        [__FK_current_phase] AS [__KEY_node]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_current_phase]);
    
    
    [cards]:
    LOAD    
        [id_u0] as card_id,
        [title] as card_title,
        [due_date] as card_due_date,
        [__KEY_node]
    RESIDENT RestConnectorMasterTable
    WHERE NOT IsNull([__FK_node]);
    Left Join(cards)
    LOAD 
        current_phase_name,
        [__KEY_node]
    RESIDENT [current_phase];
    Left Join(cards)
    LOAD 
        pipe_id,
         [__KEY_node]
    RESIDENT [cardpipe];
    
    DROP TABLE RestConnectorMasterTable;
    DROP Table [cardpipe];
    DROP TABLE [current_phase];
    DROP Field  [__KEY_node]from cards;
    */

     

    Once the data model is loaded, it will look like this:

    167b6a6f-6ed9-42ae-a37e-1761275f80c4

    And finally we can make our panels, like the example below:

    14408d7a-5b20-4d24-a001-3c195a7cc809

    That's it! See you the next!

    Show Less
  • forum

    QlikWorld Discussions

    Introduction to Qlik Sense Enterprise SaaS - Hands-on workshop

    Hands-on workshops are back at QlikWorld Online!If you are new to Qlik Sense Enterprise SaaS, you might want to check out my hands-on session:  Introd... Show More

    Hands-on workshops are back at QlikWorld Online!

    If you are new to Qlik Sense Enterprise SaaS, you might want to check out my hands-on session:

      Introduction to Qlik Sense Enterprise SaaS 

    You will have access to our SaaS environment as well as assistance from a team of Qlik Experts.

    Looking forward to seeing you there!

    Show Less
  • forum

    Deployment & Management

    Qix/datafiles parameters

    Hi,I'm asked how to delete 7,000 files automatically at this post: https://community.qlik.com/t5/Deployment-Management/How-delete-7-000-files-inside-S... Show More

    Hi,

    I'm asked how to delete 7,000 files automatically at this post: https://community.qlik.com/t5/Deployment-Management/How-delete-7-000-files-inside-SaaS-DataFiles-Folder/m-p/1760320/highlight/true#M18887. The solution works great, but it just operate with Personal Space.

    How can I operate with other spaces? Where I can find qix/datafiles parameters ?

    Tks

    Pedro 

    Show Less
  • forum

    App Development

    Underscore character not displaying in Qlikview Accesspoint

    We've noticed a strange issue today. Underscores in straight tables are not always being displayed in ajax access point. However they do display in th... Show More

    We've noticed a strange issue today. Underscores in straight tables are not always being displayed in ajax access point. However they do display in the Qlikview application.

    I've tried changing font, font size, object style but nothing seems to help.

    See screenshot from accesspoint. You'll notice the listbox works fine. Even the straight table without lines has the same problem. 

    VivenReddy_0-1619136859467.png

    I have attached a sample qvw. Any suggestions would be appreciated.

      

    Show Less
  • forum

    New to Qlik Sense

    Rank

    Hello could anyone please help explain how Rank Function in load script editor works.is it the same as in SQL

Get Started On Community

Start Here Get Started On Community

Top Participants

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.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Register for QlikWorld Today

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand