Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,813 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.

This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.

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.

Discussion Boards and Documents for Qlik Services.

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 nine unique blogs. Check out the new Customer Success Blog!

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

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

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

  • New to Qlik Sense

    Blank Column in table

    Hi guys,Is there any way to get rid of the additional blank column within a table.  I haven't set it, so I guess this is a default setting from somewh... Show More

    Hi guys,

    Is there any way to get rid of the additional blank column within a table.  I haven't set it, so I guess this is a default setting from somewhere.

    Capture.PNG

    I only want to show 4 columns !

    Thanks

    Show Less
  • New to Qlik Sense

    How to remove the most right column in the Qlik sense table?

    In Qlik sense table, there is a default empty column in the most right. How to remove that default empty column?Thanks!
  • Qlik Sense Data Connectivity

    Photo Recovery Software

    I am a careless person and always make a mistake. Once I deleted my traveling photos on my phone, that was precious memory! I asked on many websites b... Show More

    I am a careless person and always make a mistake. Once I deleted my traveling photos on my phone, that was precious memory! I asked on many websites but all I got was a complicated method.

    So I had to pay for recovery. I found this software has a very low price, so I tried. try Stillbon Photo Recovery Software. Surprisingly my photos were all back with its help! 

    Show Less
  • New to QlikView

    How to open a pdf or word document by clicking a button?

    Hi,Is there any way to open a word document or excel file or pdf file by clicking on a button?Thanks,Sandip.
  • New to QlikView

    Criar qvd de dados do oracle

    Preciso de ajuda, para criar um qvd de dados que eu leio do Oracle, e com isso eu consigo otimizar minhas cargas, pois toda vez que preciso atualizar ... Show More

    Preciso de ajuda, para criar um qvd de dados que eu leio do Oracle, e com isso eu consigo otimizar minhas cargas, pois toda vez que preciso atualizar meu painel, preciso esperar carregar todos os dados e isso está levando em média 45 minutos, depois disso ainda tenho que subir o arquivo qvf, para a versão Cloud.

    Show Less
  • New to QlikView

    I can help ... for next

    Hi, I have problems with this process. does not respect my condition if it comes in red.I can Help, Please tmp_Cuotas_Sucursal:LOAD distinct%Pto_vta_I... Show More

    Hi, I have problems with this process.

    does not respect my condition if it comes in red.

    I can Help, Please

     

    tmp_Cuotas_Sucursal:
    LOAD distinct
    %Pto_vta_ID,
    Clasificación_Cuotas,
    CuotaUnidades,
    Fecha,
    // Año,
    ValorPorcentual2
    FROM
    Transformación\Fact\Cuotas_DiariasUnidades2.qvd (qvd)
    where %Pto_vta_ID='54NG364' and Clasificación_Cuotas='Mac'
    and Fecha>='12/01/2020';


    NoConcatenate

    Cuotas_Sucursal:
    LOAD %Pto_vta_ID,
    Clasificación_Cuotas,
    CuotaUnidades,
    Fecha,
    ValorPorcentual2
    Resident tmp_Cuotas_Sucursal
    where %Pto_vta_ID='54NG364' and Clasificación_Cuotas='Mac'
    and Fecha>='12/01/2020'
    order by ValorPorcentual2,
    Clasificación_Cuotas ,
    %Pto_vta_ID
    desc
    ;

    Drop table tmp_Cuotas_Sucursal;

    //Variable de cuota Total
    Ciclo_CuotaTotal:
    Load Distinct CuotaUnidades
    Resident Cuotas_Sucursal;

    Let v_CuotasTotal = peek('CuotaUnidades',0,'Ciclo_CuotaTotal');


    trace $(v_CuotasTotal);

    //drop table Cuotas_Sucursal;

    Drop Table Ciclo_CuotaTotal;

     

    If $(v_CuotasTotal) <= 7 Then

    for i= 0 to $(v_CuotasTotal)

    Trace $(v_CuotasTotal);

    // if '$(i)' <= '$(v_CuotasTotal)' then
    //
    // let cuota_diaria= 1; Else
    // Let cuota_diaria= 0;
    //
    // trace $(cuota_diaria);
    //
    left join (Cuotas_Sucursal)
    LOAD
    %Pto_vta_ID,
    Fecha,
    Clasificación_Cuotas,
    ValorPorcentual2,
    CuotaUnidades,
    // '$(cuota_diaria)' as ValorPorcentual3,
    if($(i)<$(v_CuotasTotal), 1,0) as ValorP,
    // ValorPorcentual2
    1 as diferente
    Resident Cuotas_Sucursal
    order by
    ValorPorcentual2,
    Clasificación_Cuotas ,
    // Fecha,
    %Pto_vta_ID
    desc
    ;

    //ENDIF
    NEXT

    ENDIF

    Show Less
  • New to QlikView

    Comparar valores de la misma columna

    Que tal!Tengo un problema y espero puedan ayudarme.Necesito encontrar los clientes repetidos en mi tabla clientes que tienen la misma informacion pero... Show More

    Que tal!
    Tengo un problema y espero puedan ayudarme.
    Necesito encontrar los clientes repetidos en mi tabla clientes que tienen la misma informacion pero diferente ID.

    ¿Que función podría utilizar para comparar los valores de una misma columna y me resulten los repetidos?

     

    Show Less
  • New to QlikView

    User Named cal issue Qlikview

    Hello,I have some trouble.One user have Doc and Named cal's.We delete doc cal from the assigned users list in qmc, it goes to carantine.After user sti... Show More

    Hello,

    I have some trouble.

    One user have Doc and Named cal's.

    We delete doc cal from the assigned users list in qmc, it goes to carantine.

    After user still having Named cal, but it have an error message when entering app ( no user cal for your account ).

    How can we fix it?

    Show Less
  • New to Qlik Sense

    Sum of next colum Divided by total sum of all columns Qlik Script

    Hi Folks, Please assist how can i achieved this,i want to make a dimension category  by calculating the scenario given below.Total = R2 to R7   Total ... Show More

    Hi Folks, 

    Please assist how can i achieved this,

    i want to make a dimension category  by calculating the scenario given below.

    Total = R2 to R7  
     Total = R2 to R7 / R2 to R7100%
     Total /Sum(R3+R4+R5+R6+R7)90%
     Total /Sum(R4+R5+R6+R7)80%
     Total /Sum(R5+R6+R7)70%
     Total /Sum(R6+R7)60%
     Total /Sum(R7)50%

     

     

    I have to calculate this on bases of dimension suppose ID - Retailer

    The sample is calculating the value against 1 ID with multiple Retailer.

     

    Please suggest how can i calculate this.

     

    Regards 

    Show Less
  • Qlik Sense App Development

    Add calculated field in a table that look string in a fiel (Column)

    Dear all,I am new with Qlik Sense and I want to ask you for an issue that I have.I have loaded a table in Qlik and I want to add a calculated column (... Show More

    Dear all,

    I am new with Qlik Sense and I want to ask you for an issue that I have.

    I have loaded a table in Qlik and I want to add a calculated column (Add field).

    The expression should:

    If SySStatus = “TSCO” OR “TSOS” 

    then

    lookup                  Noti&”_QMAR_”&Task                 Or                           Noti&”_QMAR_”&Task

    Lookup in             Offer

    if found returns SySStatus

    If not returns      Empty

                   Else

                                    Returns                Empty

    Which should be the expression in Qlik to do it?

    Thanks

    Capture.PNG

     

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

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

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

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

750+ Members

Events

Qlik World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by January 31, and save $300.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Customer Spotlight Series

Discover the secrets behind data-driven transformation with real-world examples from Qlik customers.

Watch the Series Today