Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
4,249 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

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

    Brasil

    Função Above em Datas

    Bom dia a todos. Tenho uma tabela que mostra o Código de um chamado e todos os status que este chamado passou. Eu precisava gerar uma coluna na tabela... Show More

    Bom dia a todos. 

    Tenho uma tabela que mostra o Código de um chamado e todos os status que este chamado passou. 

    Eu precisava gerar uma coluna na tabela onde ele calculasse o tempo em que o chamado ficou em cada status (acredito que teria que usar a função ABOVE para realizar esta tarefa. Mas não entendi como ela pode ser usada.

    Depois que eu calcular esses tempos totais de cada chamado eu preciso exibir a soma de todos os tempos subtraindo o tempo em que o chamado ficou com o Status 'AGUARDANTO TERCEIROS' 

    Não sei se no próprio ABOVE eu posso gerar um IF para que quando a coluna de status for Aguardando terceiros ele coloque o tempo a seguir como ZERO.

    paulokpk_0-1632316234823.png

     

    Show Less
  • forum

    New to Qlik Sense

    Number Format

    Hi Qlik,I've below two columns in my Dimension value which needs to be format to 00.0% format. Ex: 23.1%  (Need one decimal with %).My original value ... Show More

    Hi Qlik,

    I've below two columns in my Dimension value which needs to be format to 00.0% format. 

    Ex: 23.1%  (Need one decimal with %).

    My original value is 

    MuraliPrasath_0-1632407088618.png

    Any help would be highly appreciated. thanks!

    Show Less
  • forum

    Brasil

    Vencimento de contrato

    Bom dia, pessoal! Estou trabalhando com dados de estagiários da empresa que trabalho e preciso contabilizar em KPIs a quantidade de contratos que irão... Show More

    Bom dia, pessoal! 

    Estou trabalhando com dados de estagiários da empresa que trabalho e preciso contabilizar em KPIs a quantidade de contratos que irão vencer dentro de 20, 60 e 90 dias. Minha dificuldade é que cada estagiário pode ter até 4 renovações de contrato ou seja, 4 datas de vencimento de contrato. Preciso pegar a última data de vencimento e verificar se está para vencer dentro dos prazos informados. Poderiam me ajudar? Obrigado!

    Show Less
  • forum

    QlikView App Dev

    Reccurence from past 12 months to current month (then storing the data)

    Hello,I am trying to basically get 12 months of past data and compare that 12 months of data to the current month. After I do that, I need to keep tha... Show More

    Hello,

    I am trying to basically get 12 months of past data and compare that 12 months of data to the current month. After I do that, I need to keep that value.

    So, we are currently in September 2021, I need the data dating back from August 2021 - September 2020. Taking that data with the Primary Key of CustomerID, I need to know if from those dates in Aug 2021-Sept 2020, if that CustomerID shows up there, I need to know if it shows up in Sept 2021. If it does, then I will need to count it for September 2021.

    The tricky part is then once we are through Sept 2021, we will be in Oct 2021, so from there we need the data dating back from Sept 2021 - Oct 2020, and to compare that past 12 months of data to current month of Oct. Then I need to know which CustomerID's reoccurred in month of Oct from the past 12 months... then storing that data and also keeping the underlying data as well so we can see which ones reoccured.

    Anyone know of any way to do this?

    Show Less
  • forum

    Qlik NPrinting Discussions

    Qlikview User name in Footer

    Hi Team,                I am new to NPrinting and i am facing the issue on User name in NPrinting Footer. Tasks : Need to show QVuser name in NPrintin... Show More

    Hi Team, 

                   I am new to NPrinting and i am facing the issue on User name in NPrinting Footer. 

    Tasks : Need to show QVuser name in NPrinting. 

    Please refer below my Steps(but i am not getting what i am expected)

    1. Created One variable in Qlikview (vPrepared By = 'Prepared By: ' & Subfield(OSUser(),'\',2) 

    2. Value is showing as Prepared By: Sakthivel. Selvaraja 

    3. Taking this variable in Nprinting Variable. 

    4. If I Use this variable in Qlik Nprinting it is showing as NPAdmin(which is Nprinting Admin User)

    5. But what my expectation is shown as the same above which is Prepared By: Sakthivel.Selvaraja. 

     

    Will anyone help me to resolve this . It is very urgent

     

    Thanks and Regards, 

    Sakthivel.S

    Show Less
  • forum

    New to Qlik Sense

    How create a country selection by flag icon

    Hi everyone, I am looking for a way to create a country selection by cliking on flag icon. The goal is to allow the user to clik on a flag to filter t... Show More

    Hi everyone,

     

    I am looking for a way to create a country selection by cliking on flag icon. The goal is to allow the user to clik on a flag to filter the country. 

    I don't know how to do this, or maybe there is an extansion with this fonctionnality.

    Thank you for you're help.

    Show Less
  • forum

    New to Qlik Sense

    QlikSense Data modelling

    Hello All,I'm working on a QlikSense app which sources data from multiple views and dim tables created in SQL server. When I try to create a flat tabl... Show More

    Hello All,

    I'm working on a QlikSense app which sources data from multiple views and dim tables created in SQL server. 

    When I try to create a flat table I often encounter that few fields does not got with each other, i.e. one field will have a NULL value when other has a value and vice versa for the same id. 

    E.g. the id 'Cash receipt gl date' and 'cash app gl date' value but 'Trans Due date' is null.

    How, can I overcome this and create a table to have all non-nulls in one row. I want to calculate difference between cash receipt gl date and due date for each id.

     

    SR2_0-1632408150547.png

     

    Any help is highly appreciated.

    Thanks,

     

     

    Show Less
  • forum

    Deployment & Management

    Replacing Qlik Sense proxy SSL certificate causes 500 error on SAML authenticati...

    I have a QSE Windows implementation that uses SAML authentication against Google Workplace.When we attempt to update the SSL certificate on the server... Show More

    I have a QSE Windows implementation that uses SAML authentication against Google Workplace.

    When we attempt to update the SSL certificate on the server and paste the new thumbprint in the proxy config, authentication via the SAML Virtual Proxy starts returning a 500 error.

    There are no changes to the SAML configuration (which has its own certificate).  Every post I find online references 500 errors related to the SAML certificate specifically.

    Has anyone experienced similar issues?  I do not know how replacing the SSL cert on the proxy would cause a problem with the existing SAML configuration.

    I understand the SP metadata could change in this scenario, but Google did not require us to upload the SP metadata into the SAML app.

    I appreciate any advice/experience/guidance. Thanks!

    Show Less
  • forum

    Integration, Extension & APIs

    SAML certificate

    Hi,I'm currently trying to implement SAML authentication on our Qlik Sense dev platform.So I followed the steps described in the Knowledge Base, but I... Show More

    Hi,

    I'm currently trying to implement SAML authentication on our Qlik Sense dev platform.

    So I followed the steps described in the Knowledge Base, but I encountered difficulties on the SAML signing algorithm : I need to implement the SHA-256, which requires a certificate, but I can't find what certificate is needed, or where to upload it.

    Can somebody help me on this ?

    Best regards,

    Martin.

    Show Less
  • forum

    New to Qlik Sense

    Concatenation

    I have two tables [Stage 1] and [Stage 2].I have to concatenate [Stage 2] to [Stage 1], I wrote the following commands but in the result, the values f... Show More

    I have two tables [Stage 1] and [Stage 2].

    I have to concatenate [Stage 2] to [Stage 1], I wrote the following commands but in the result, the values from [Stage 2] is not showing.

    First I wrote this 

    Concatenate ([Stage 1])

    [Stage 3]:
    Load *
    Resident [Stage 2];

     

    Drop table [Stage 2];

    After that i wrote this

    [Stage 1]:
    Load *
    Resident [Stage 1];
    Concatenate ([Stage 1])
    Load *
    Resident [Stage 2];

     

    Drop table [Stage 2];

     

    But in both cases, I am just getting from the stage 1 and stage 2 values are missing, but when I run them separately it works fine.

     

    Plzz help.

    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