Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
1,532 online
Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now

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 QlikWorld 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.

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 Compose for Data Lakes Discussions

    How to include partition/bucket parameter when writing file to HDFS

    Currently we have been using compose to transfer the data from storage layer to provision layer(HDFS in parquet format)By default it is using the belo... Show More

    Currently we have been using compose to transfer the data from storage layer to provision layer(HDFS in parquet format)

    By default it is using the below command for writing the file to HDFS.

    <D_F>.write
    .mode("Overwrite")
    .format("PARQUET")
    .save("hdfs:///....")

    We need to include partition/bucket parameter based on some column to write the parquet files in HDFS based on partition/bucket key.

    Kindly advise if there any way to do.

     

    Show Less
  • forum

    Qlik Sense App Development

    Applymap error field not found

    I have below script using applymap. But I get error that Field Nomaff not found. Hope I can get some advice why on how to fix it. [GRCA]: Mapping LOA... Show More
    I have below script using applymap. But I get error that Field Nomaff not found. Hope I can get some advice why on how to fix it.
    
    [GRCA]:
    Mapping
    LOAD
        NomAff as NomAff,
        grca_acct
    FROM [lib://Fusion/Qlik Logic.xlsx]
    (ooxml, embedded labels, table is [grca map]);
    
    
    
    [Fusion]:
    LOAD
         Month(ACCOUNTING_DATE)&Year(ACCOUNTING_DATE) as period,
      
         NOMINAL&'_'&AFFILIATE as NomAff,
       Applymap('GRCA', NomAff) as GRCA,
      
    // Below fields are originally from transaction list
        LEGAL_ENTITY,
        SERVICE,
        COST_CENTRE,
        NOMINAL,
        AFFILIATE,
        AFFILIATE_FUNCTION,
        ANALYSIS,
        SPARE1,
        SPARE2,
    
    FROM [lib://Fusion/GL Transaction Extract LM.xlsm]
    (ooxml, embedded labels, table is HBAP);
    Show Less
  • forum

    QlikView App Development

    Numbers of Field are align sometimes right and sometimes Left

    Hi everyone, I stored a Field in QVD Table , and when I try to read it in my Report i see that the Values are align sometimes right and sometimes left... Show More

    Hi everyone, 

    I stored a Field in QVD Table , and when I try to read it in my Report i see that the Values are align sometimes right and sometimes left.
    i think that Qlikview considers some Values as number and some of them as String !!

    How can i fix this Issue ? I try to multiplie the Field with other Field and i get false Results . should i convert the Field to number or how can I fix this Problem ? 


    Show Less
  • forum

    QlikView App Development

    OLEDB Connection string missing out values when ODBC works fine with the same ex...

    OLEDB Connection string missing out values when ODBC works fine with the same extract file. I have a simple extract file with 1 query: QUALIFY *; MyQ... Show More

    OLEDB Connection string missing out values when ODBC works fine with the same extract file.

    I have a simple extract file with 1 query:

    QUALIFY *;

    MyQVTable:
    LOAD *;

    SELECT * FROM MyTable;

    STORE MyQVTable INTO $(vQVDDirectory)\MyQVTable.qvd;

    DROP table MyQVTable;

    If I use the OLEDB connection string:

    OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=USERNAME;Data Source=SERVER;Extended Properties=""] (XPassword is PASSWORD);

    It doesn’t return ALL my data but it does if I use ODBC

    ODBC CONNECT TO [SERVER;DBQ=SERVER] (XUserId is USERNAME, XPassword is PASSWORD);

    Show Less
  • forum

    QlikView App Development

    Last n Months in Script

    Hi,I have a need to calculate the last 6 months (excluding the reported month) Sales for a given reported date in the sample provided. For instance, C... Show More

    Hi,

    I have a need to calculate the last 6 months (excluding the reported month) Sales for a given reported date in the sample provided.

    For instance, Customer 20170 will have the following details once completed in the data model.

    11/2017 - $343,913

    10/2017 - $343,562

    I have tried the concept with a IF...previous and RangeSum with Peek but I cannot do something similar to Above function in Script.

    Appreciate your assistance.

    Show Less
  • forum

    Qlik Sense App Development

    Porcentaje

    Hola a todos! soy nueva en Qlik sense y estoy tratando de sacar el porcentaje de aprobación, rechazos etc.. Tengo lo siguiente: Para TOTAL APROBADAS a... Show More

    Hola a todos! soy nueva en Qlik sense y estoy tratando de sacar el porcentaje de aprobación, rechazos etc.. Tengo lo siguiente:

    Shir2806_1-1591395179725.png

     

    Para TOTAL APROBADAS arme la medida maestra:

    COUNT ({<EstadoAutomatico={"TRMITP","TRMITR","TRMITA"},Progress ={"40"},LoanProduct = {"Prendarios"},
    [Opportunity.TransDate.autoCalendar.YearsAgo] = {0}>} EstadoAutomatico)  

    Para el porcentaje de aprobadas estoy usando lo siguiente y no me funciona:


    Sum ({<EstadoAutomatico={"TRMITP","TRMITR","TRMITA"},Progress ={"40"}, LoanProduct = {"Prendarios"},
    [Opportunity.TransDate.autoCalendar.YearsAgo] = {0}>} EstadoAutomatico)

    / Sum ({<EstadoAutomatico= {"TRMITP","TRMITR","TRMITA"},LoanProduct = {"Prendarios"},
    [Opportunity.TransDate.autoCalendar.YearsAgo]= {0}>} TOTAL EstadoAutomatico)

     

    Ojala me puedan ayudar.

    Gracias de Antemano.

     

     

     

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Cumulative Sum in the bar char

    Hello Everyone,Below is my sample data and expected output is if i select  last 2 days, in the bar graph , it should show Load values as 86915,88665 i... Show More

    Hello Everyone,

    Below is my sample data and expected output is if i select  last 2 days, in the bar graph , it should show Load values as 86915,88665 in the Y -axis. I know how to get last 2 days, but couldnt able to get cumulative sum if i use 

    RangeSum(Above(Sum(Records), 0, RowNo()))

    as it shows 1710, 3460 for the last 2 days.

    DateLoadCumulative Sum
    5/22/20211425014250
    5/23/20211429028540
    5/24/20211433042870
    5/25/20211437057240
    5/21/202048057720
    5/22/202052058240
    6/12/2020131059550
    6/13/2020135060900
    6/14/2020139062290
    6/15/2020143063720
    8/31/2020441068130
    9/1/2020445072580
    9/2/2020459077170
    9/3/2020463081800
    6/20/2020170083500
    6/21/2020170585205
    6/22/2020171086915
    6/23/2020175088665

     

    Please provide the solution if possible

    Thanks

    Chris

    Show Less
  • forum

    Qlik Sense App Development

    Set Analysis with missing dates

    Hi All,I am trying to get the count of the items where the open date is not missing and the Close date is missing.ItemOpen DateClose date16/5/2020 26/... Show More

    Hi All,

    I am trying to get the count of the items where the open date is not missing and the Close date is missing.

    ItemOpen DateClose date
    16/5/2020 
    26/4/2020 
    36/3/20206/4/2020
    46/2/20206/3/2020
    56/1/20206/2/2020
    65/31/2020 
    7  
    86/5/2020 
    96/4/2020 
    10  
    116/5/20206/6/2020
    126/4/20206/5/2020

     

    I have tried the following

    Count({<FIRST_OPEN_HSC_DATE={"*"},FIRST_CLOSE_HSC_DATE-={"*"}>}FIRST_CLOSE_HSC_DATE) 

    and also

    Count({<FIRST_OPEN_HSC_DATE={"*"},FIRST_CLOSE_HSC_DATE=e({<FIRST_CLOSE_HSC_DATE= {'*'}>})>}FIRST_OPEN_HSC_DATE) 

    I don't have a problem with this first part (Open Date), but I can not get the right count of items where the close date is missing.

    How can I count missing values on a set analysis?

    Thank you so much

    Pamela

    Show Less
  • forum

    Qlik Sense Integration, Extensions, & APIs

    Qlik-cli bad request

    Hi,I'm trying to configure Qlik-cli in our server .I connect successfully to it but then when executing commands like start-qliktask I'm getting bad r... Show More

    Hi,

    I'm trying to configure Qlik-cli in our server .

    I connect successfully to it but then when executing commands like start-qliktask I'm getting bad request (400) error.

    Other api calls like getAbout or so are working correctly.

    I followed the steps to install the certificates from GitHub page and qlik help.

     

    Any clues?

    Thanks

    Show Less
  • forum

    Qlik Sense App Development

    Complicated issue

    See attachment. QVD atttached too

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for December 2019 and January 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

Qlik Insight Bot

Join the Qlik Insight Bot Group and bring the power and simplicity of natural-language, conversational analytics to everyone in your organization

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

The Human Impact of Data Literacy

Boosting the data skills of your entire workforce can exponentially increase your data’s value. In this webinar, discover the big opportunity in data literacy.

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

What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

Now Available on Demand