Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,942 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

May Qlik Alert You – Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

Participate in Qlik Technical Previews, submit ideas, and review documentation.

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

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our ten unique blogs. Check out the new Product Insight & Ideas Blog!

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion Boards and Documents for Qlik Services.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

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

Recent Discussions

  • No Boards Found
  • forum

    Qlik Sense App Development

    Incremental load but just for some of columns

    Hi guys I need your help about incremental load. DATE             ID            MONEY              ATRIBUT1        ATRIBUT21.8.2020. 141306          7... Show More

    Hi guys I need your help about incremental load.

     


    DATE             ID            MONEY              ATRIBUT1        ATRIBUT2
    1.8.2020. 141306          70                        306                       1507

    Load is going every day from beginning.

    Let's start
    Someone changed for atribut1 on 2.8., instead 306, put 309
    Standard load:

    load
    date,
    id,
    money,
    atribut1,
    atribut2
    from table1.qvd: 1;

    store table into table1.qvd
    DATE                 ID                      MONEY                 ATRIBUT1              ATRIBUT2
    1.8.2020. 141306                        70                             309                          1507
    2.8.2020. 141306                       100                            309                          1507

    We see atribut 1 for 1.8. changed also.

    To avoid this situation I made incremental load.

    table:
    load
    date,
    id,
    money,
    atribut1,
    atribut2
    from table1.qvd: 1 where date<today()-1;

    concatenate(table)
    load
    date,
    id,
    money,
    atribut1,
    atribut2
    from table1.qvd: 1 where date=today()-1;

    store table into table1.qvd

    DATE               ID                                         MONEY                      ATRIBUT1                 ATRIBUT2
    1.8.2020. 141306                                           70                                   306                          1507
    2.8.2020. 141306                                       100                                    309                           1507

    Atribut1 is not changed and it is okay.

    Now I need situation. If someone on database changed atribut1, and I want it doesn’t affect older data, I will use this incremental, but what if someone change money on 1.8. How to put new calculation?


    DATE             ID                                          MONEY                            ATRIBUT1                      ATRIBUT2
    1.8.2020. 141306                                       80                                        306                                     1507
    2.8.2020. 141306                                    100                                        309                                      1507

    How to have 80 instead of 70 at 1.8., if I use incremental load?

     

    thanks

    Show Less
  • forum

    Qlik Sense App Development

    Tabular Hierarchical Data

    I'm currently working on a project where we are getting a single table to be turned into a report. The fields include a contract code, the parent cont... Show More

    I'm currently working on a project where we are getting a single table to be turned into a report. The fields include a contract code, the parent contract code, and the child contract code(s). We are trying to show the data in a hierarchical manner as a table, similar to how Excel can include plus signs to the left of the data. We have tried several different methods, including pivot tables, drill down dimensions, hierarchy and ancestor tables, and even just multiple tables to try to get this right. Nothing quite works. Has anyone else had to do anything like this?

    Show Less
  • forum

    Qlik Connectors Discussions

    Microsoft 365 beta connector

    I am trying to download an attachment from an email. I put in my credentials and I get this pop up:I have signed in with my credentials since I am an ... Show More

    I am trying to download an attachment from an email. I put in my credentials and I get this pop up:

    Mccutchan1_0-1596743030280.png

    I have signed in with my credentials since I am an admin on the server and I even signed in with a service account which also is an admin on the server.  The connectors were installed and executed with a login with admin rights. So.. how do I grant access to this connector?

    Show Less
  • forum

    New to Qlik Sense

    P&L pivot with color for two difference performance

    Hi there,I have to use a P&L pivot to represent different KPIs. The problem is that with P&L I can just set the colors for one performance, but I have... Show More

    Hi there,

    I have to use a P&L pivot to represent different KPIs. The problem is that with P&L I can just set the colors for one performance, but I have to set:

    • Green color for CapEx < 0 and Red color for CapEX > 0,  
    • Green color for another KPI when is > 0 and Red color when is < 0

    is set analysis a possible solution ? or maybe it can be the style csv that I use for  style template formt ?

    thanks for your time 

     

    Show Less
  • forum

    New to Qlik Sense

    Weekly count is different from individual day count

    Hi, I'm having this weird issue again where I do a distinct count for measure and a drill down of dates for dimensions, but the weekly count is differ... Show More

    Hi, I'm having this weird issue again where I do a distinct count for measure and a drill down of dates for dimensions, but the weekly count is different from the count added separately by date. 

    shirleyc40_0-1596728224236.png

    I don't have a pic for the individual dates, but I added them twice separately after selecting W32, and got 86 (which is correct). 

    The measure formula I use is Count({<PolicyStatus = {'Policy - Accepted'}>} distinct EventNumber)

    My data is formatted so that there could be repeating event numbers with the same status and dates. Like I could have two entries with the same eventnumber, status, and date

     

    Show Less
  • forum

    Qlik Sense Deployment & Management

    Error de autenticación

    Hola,Cuando abro Qlik Sense escritorio me sale el siguiente error:'error de autenticación en el servidor seleccionado. Asegúrese de que su conexión a ... Show More

    Hola,

    Cuando abro Qlik Sense escritorio me sale el siguiente error:

    'error de autenticación en el servidor seleccionado. Asegúrese de que su conexión a Internet funcione correctamente e inténtelo de nuevo.

    Adjunto la imagen.

    No me sale ni para poder hacer el inicio de sesión, el mensaje de venta cuando le doy una sesión de inicio, pero no puedo medir mi usuario y contraseña.

    La versión que tengo es Noviembre 2019 parche 13.

    muchas gracias

    Un saludo

    Show Less
  • forum

    Qlik Sense App Development

    KPI showing wrong count

     Hi Team,Below is the scenario. Expression in table : =If(Date([Consumption Date])=Date([Scheduled Date]),Date([Scheduled Date]))Expression in KPI:=su... Show More

     Hi Team,

    Below is the scenario.

    kiranb13_0-1596646202988.png

    kiranb13_1-1596646283823.png

     

    Expression in table : 

    =If(Date([Consumption Date])=Date([Scheduled Date]),Date([Scheduled Date]))

    Expression in KPI:

    =sum(If(Date([Consumption Date])=Date([Scheduled Date]),1))

    There are 12 records in table. But in KPI i am getting the value as 36. I tried with count expression as well.

    =count(If(Date([Consumption Date])=Date([Scheduled Date]),Date([Scheduled Date]))

    Can anyone help me out here with the correct expression to get value as 12 ?

    Show Less
  • forum

    Qlik Brasil

    Mostrar todo o conteúdo de um campo campos, inclusive os iguais

    Estou realizando a importação de uma planilha para o Qlik sense e ele me mostra que trouxe 172 linhas quando eu faço a extração e gero um QVD, Entreta... Show More

    Estou realizando a importação de uma planilha para o Qlik sense e ele me mostra que trouxe 172 linhas quando eu faço a extração e gero um QVD, 

    Entretanto ele só está trazendo paraa tabela no painel 65 linhas. Eu acredito que ele esteja agrupando linhas que sejam totalmente iguais.

     

    Tenho os campos

    Fabricante
    Saldo
    Localidade

    Como eu posso fazer para que o Qlik Sense traga os campos, mesmo os iguais em linhas diferentes, sem este agrupamento??

     

    Show Less
  • forum

    New to Qlik Sense

    Value list dimension for multi kpi, change formatting

    Hi. I have a multi kpi and I'm using a value list for the dimension. In the measures, I have specific calculations for each valuelist item, but I was ... Show More

    Hi. 

    I have a multi kpi and I'm using a value list for the dimension. In the measures, I have specific calculations for each valuelist item, but I was wondering if it is possible to set a different format pattern for one of them because I have a ratio field that is 0.56 but it rounds to 1.

    Show Less
  • forum

    New to Qlik Sense

    Bookmark and actual dymanic date

    Hi all, Would like to have a flag in a date filter pane, eg. 1 = the most actual available date. The formula below works fine:=If(Datum = Date(Floor(R... Show More

    Hi all, 

    Would like to have a flag in a date filter pane, eg. 1 = the most actual available date. The formula below works fine:

    =If(Datum = Date(Floor(ReloadDate)), 1, 0)

    2020.0730-132437.jpg

     

    But when I want to use it as a bookmark, and have ticked "1" then it does not work properly. Reason: In the filter will be saved the last actual date, so this date will remain for every new date (eg. below 28.07.2020). 

    2020.0730-132650.jpg

    Has anybody an idea how to implement it dynamicaly in the bookmark, so by clicking on it you always have the actual date?

    Thanks.

    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for April and May 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

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

Qlik Customers Share COVID-19 Supply Chain Strategies

Amazon Produce Network and Odyssey Logistics discuss how they’re using Qlik to help manage their operations during Covid 19

On Demand Webinar

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