Qlik Community

Welcome to Qlik Community

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

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.

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

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

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

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

Discussion board and documents related to Qlik Associative Big Data Index.

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.

Recent Discussions

  • Qlik Sense App Development

    Join / Lookup

    Hi all,Have to do a Lookup to find out the Name of the case handler. Each case handler has an abbreviation (KURZZEICHEN) and all specific details are ... Show More

    Hi all,

    Have to do a Lookup to find out the Name of the case handler. Each case handler has an abbreviation (KURZZEICHEN) and all specific details are locatated in Table "SB".

    The Table "PE" has order information. Each order has one case handler and two contact persons. The abbreviations of the contact persons are located in Table "ST". All Details of contact persons and case handlers are in the Table "SB".

    Goal:

    Would like to do a Lookup to find out which person has the specific abbreviations (Table "ST" ST_KURZZEICHEN1 & ST_KURZZEICHEN2) from Table "SB".

    Would like to have an output with all Dimensions information in one table. With this Data Model I get an cartesian product. Thank you for your help.

    2019.1118-203656.jpg

    Show Less
  • QlikView App Development

    Cómo sumar el total individual de los posibles clientes por categorias

    Hola! Favor su ayuda con este problema. Cómo puedo, en una tabla pivot, hacer referencia por cada fila al código del cliente para obtener la misma fór... Show More

    Hola! Favor su ayuda con este problema. Cómo puedo, en una tabla pivot, hacer referencia por cada fila al código del cliente para obtener la misma fórmula que al filtrar cada uno de los clientes.

    Así se ve la tabla cada vez que filtro un cliente, mostrando las ventas de los otros clientes que coinciden con su categoría

    Customersum(#Kilos)Sum({<Category=P({<[Customer Code]={"(A)"}>}Category)>}Total_sales)
    Customer A10.00010.000
    Customer B010.000
    Customer C015.000
    Customer D03.000
    Total10.00038.000
       
    Customersum(#Kilos)Sum({<Category=P({<[Customer Code]={"(B)"}>}Category)>}Total_sales)
    Customer A05.000
    Customer B20.00020.000
    Customer C025.000
    Customer E03.000
    Total20.00053.000
       
    Customersum(#Kilos)Sum({<Category=P({<[Customer Code]={"(C)"}>}Category)>}Total_sales)
    Customer A08.000
    Customer B015.000
    Customer C30.00030.000
    Customer F03.000
    Total30.00056.000

     

    Lo que necesito es que sin filtrar clientes, en cada fila me sume el total de ventas de cada cliente que coincide con sus categorías.

    Customersum(#Kilos)Sum(Category=P({<[Customer Code]={"(A|B|C|D|E|F)"}>}Category)>}Total_sales) 
    Customer A10.00038.000Sum({<Category=P({<[Customer Code]={"(A)"}>}Category)>}Total_sales)
    Customer B20.00053.000Sum({<Category=P({<[Customer Code]={"(B)"}>}Category)>}Total_sales)
    Customer C30.00056.000Sum({<Category=P({<[Customer Code]={"(C)"}>}Category)>}Total_sales)
    Total60.000147.000 

     

    Se agradece cualquier tipo de idea para obtener el resultado, muchas gracias!!

    Show Less
  • New to Qlik Sense

    Join Multiple Tables in Qlik

    Hello,I am new to Qlik and having difficulty in joining tables. Below is my code in SQL, can you please help to write in Qlik language?SELECT C.Custom... Show More

    Hello,

    I am new to Qlik and having difficulty in joining tables. Below is my code in SQL, can you please help to write in Qlik language?

    SELECT C.Customer_ID, C.Customer_Name, C.Address_ID, O.Product_Name, A.Address_ID, A.City
    FROM
    Customers AS C
    LEFT JOIN Orders AS O ON C.Customer_ID = O.Customer_ID
    LEFT JOIN Addresses AS A ON C.Address_ID = A.Address_ID

     

    Thank you

    Show Less
  • New to Qlik Sense

    Default recent 3 yrs of data in filter pane

    Hi All,I have a field 'Year ' in filter pane and I have to default this filter to recent 3yrs of date(2017,2018 and 2019) .How can I do it?Thank you i... Show More

    Hi All,

    I have a field 'Year ' in filter pane and I have to default this filter to recent 3yrs of date(2017,2018 and 2019) .
    How can I do it?

    Thank you in advance

    Show Less
  • QlikView Creating Analytics

    Count of the max records date

    Hi,I have a table like this:MARITAL STATUSPATIENTSMarried196Widowed75Single70Divorced14Stable Union2 357 I would like to count how many ID_USERS are i... Show More

    Hi,

    I have a table like this:

    MARITAL STATUSPATIENTS
    Married196
    Widowed75
    Single70
    Divorced14
    Stable Union2
     357

     

    I would like to count how many ID_USERS are in each marital status, but annually the patients are monitored and the question about marital status is asked again, so the status can change. I need an expression that count the max date record for my patient not to duplicate. 

    ps: i don't use the date in my dimension

    Show Less
  • New to QlikView

    Conditional KPI Color

    I have below KPI , its not changing color as per the conditions specified in the code Text object prop-> Background -> color> calculated Conditions: D... Show More

    I have below KPI , its not changing color as per the conditions specified in the code 

    Text object prop-> Background -> color> calculated

     

    Conditions: Display RED if % > 70 (default)

    Display Red if % > 20 (when anything else is selected on the block chart)

     

    Capture.JPG

     

    Show Less
  • New to QlikView

    Transpose from Columns to Rows

    Hi,  I have the following xls table :  12345aaa *                  -                -                   -                -  bbb *         12,995      ... Show More

    Hi,  I have the following xls table :

     

     12345
    aaa *                  -                -                   -                -  
    bbb *         12,995       6,445          4,885       3,235
    ccc         -            7,970       6,385          3,460          145
    ddd *                  -         3,045          2,250       2,310
    eee         -          15,070       3,110          5,495       1,165
    fff         -               540            55             345             45
    ggg         -               955            95             730             20
    hhh         -               160              -               280             55
    iii         -               115            70             170             80
    jjj         -                   -                -                   -                -  
    kkk         -               305              -            2,280          325
    lll         -                   -                -                  30              -  
    mmm         -                   -                -                   -                -  
    nnnn     230                 -                -                   -                -  

     

    Is it possible to transpose this during the load so I can get :

    CODEIDValue
    aaa1              21
    bbb1 * 
    ccc1               -  
    ddd1              22
    eee1                2
    fff1               -  
    ggg1              12
    hhh1               -  
    iii1               -  
    jjj1            443
    kkk1               -  
    lll1              23
    mmm1              32
    nnnn1            230
    aaa2            234
    bbb2       12,995
    ccc2         7,970
    ddd2               -  
    eee2       15,070
    fff2            540
    ggg2            955
    hhh2            160
    iii2            115
    jjj2               -  
    kkk2            305
    lll2               -  
    mmm2               -  
    nnnn2               -  

     

    etc

    etc

     

    Many thanks for any help

     

    Phil

    Show Less
  • New to Qlik Sense

    If date is greater than the other..

    I have written this script to create one column with most recent updateIf(Oppty.Date >= Contact.Date, [Oppty.Date], [Contact.Date])as LAST_ACTION_DATE... Show More

    I have written this script to create one column with most recent update

    If(Oppty.Date >= Contact.Date, [Oppty.Date], [Contact.Date])
    as LAST_ACTION_DATE

    Now some values of [Oppty.Date] and [Contact.Date] are null.

    I want to introduce another line of code to take the field with a date if the other is null. Please help

    Show Less
  • QlikView App Development

    Finding values from one column in other column

    Dear friends,Suppose I have three columns like this:NAMEVALUE1VALUE2AAA11BBB21CCC22DDD13EEE32FFF41GGG35So, my goal is to know which NAMES has values f... Show More

    Dear friends,

    Suppose I have three columns like this:

    NAMEVALUE1VALUE2
    AAA11
    BBB21
    CCC22
    DDD13
    EEE32
    FFF41
    GGG35


    So, my goal is to know which NAMES has values from VALUE1 that also appear in VALUE2. I wish to have a result like this:

    NAMEVALUE1VALUE2FLAG
    AAA11yes
    BBB21yes
    CCC22yes
    DDD13yes
    EEE32yes
    FFF41no
    GGG35yes


    Note that EEE's FLAG value needs to be NO, since his VALUE1 (4) does not exists in VALUE2 column,

    Anyone can help me? many thanks in advance.

    Show Less
  • New to Qlik Sense

    Condição de soma de valores distintos numa mesma coluna

    Boa tarde.Peço ajuda para conseguir somar valores distintos numa mesma coluna. Apliquei a seguinte fórmula, mas o resultado apresentando é diferente d... Show More

    Boa tarde.

    Peço ajuda para conseguir somar valores distintos numa mesma coluna. Apliquei a seguinte fórmula, mas o resultado apresentando é diferente do que deveria ser, fosse calculado pelo excel:

    count({<[TEM NA PLANILHA DA NATÁLIA?]={"SIM","SIM - 16.10.2019"}>}[TEM NA PLANILHA DA NATÁLIA?])

    Na coluna existem 03 (três) valores distintos: "SIM" , "SIM - 16.10.2019" e "NÃO".

    Necessito de apresentar através do campo KPI apenas os dados "SIM" e "SIM - 16.10.2019".

    No excel o resultado apresentado foram 69. Já no Qlik Sense foram 245.

    Att.;

    SLRMenezes

     

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

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 Insider Webinar

Join the last Qlik Insider Webinar of 2019, where our experts will discuss the latest features and capabilities in Qlik's platform.

November 20, 2019 Webinar

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Data Revolution Tour

Discover how to transform your entire data value chain for deep insights at unprecedented speed.

Find a location One Day Event