Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
4,454 online
Announcements
Attachments getting stuck in the virus scanner. The team is investigating.

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

    Flag and date generation for the days employee has not came to office

    Hi All,I want to get the days the employee has not come to the office. I have mentioned all the details in the excel shared. Thanks in advance.
  • forum

    New to Qlik Sense

    Problema ao consultar bases pelo banco de dados do Saas

    Ola a Todos, espero que estejam Bem!Estou tendo problemas ao consultar planilhas  no Qlick senseocorre que eu consigo executar a query (View) pelo des... Show More

    Ola a Todos, espero que estejam Bem!

    Estou tendo problemas ao consultar planilhas  no Qlick sense

    ocorre que eu consigo executar a query (View) pelo desktop ao banco de dados interno da empresa. 

    contudo,  pelo Saas, conecta mas não consigo executar a query (View) ao banco de dados da nuvem.

    ocorre o seguinte erro :

    (Connector error: ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-24347: Warning of a NULL column in an aggregate function)

    alguém consegue me explicar o por quê?

    abraços,

    Felipe Oliveira

     

     

    Show Less
  • forum

    New to Qlik Sense

    Sum Field based on other two fields aggregated

    Hello Qlik community !! I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount. My data consists of transactions between the buyers a... Show More

    Hello Qlik community !! 

    I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount. 

    My data consists of transactions between the buyers and sellers which can be interchangeable, in other words, entity X can appear both as seller and buyer. What i want to do is rank the buyers and sellers as a single entity  "Company" based on the Sum of the total amount, whether they acted as buyer or seller. 

    For example supposing I have this values in my Table:

    DateBuyerSellerAmount
    12/05/2020Apple Amazon2000
    13/05/2019 AmazonApple2500
    01/01/2020AppleMicrosoft1000

     

    I want a table-chart that displays: 

    RankCompanyTotal Amount Transactions
    1Apple5500
    2Amazon4500
    3Microsoft1000

     

    Will really appreciate it if someone can help me 🙂

     

    Show Less
  • forum

    New to Qlik Sense

    Where not exists

    Hi, I have gone through the concept of NOT Exists but it is throwing me off. Please help me in understanding how does NOT EXISTS work in the script. B... Show More

    Hi,

     

    I have gone through the concept of NOT Exists but it is throwing me off. Please help me in understanding how does NOT EXISTS work in the script. 

    Below is the pseudo-code I found on internet and I tried executing this code in QS . The result doesn't make  sense to me. 

    First:
    Load F1 As F1Reduce, F2;
    LOAD * INLINE [
    F1, F2
    1, North
    2, South
    ];


    Concatenate(First)
    LOAD * INLINE [
    F1, F2
    1, North
    2, South
    3, West
    4, East
    3, West1
    4, East1
    ]
    where not Exists(F1Reduce,F1); //Loads records where F1's value not present in Table : First

    drop Field F1Reduce from First;

     

    The output I get is 

    PrashantRupani_1-1600626881471.png

     

    I am not expecting the above output. What I am expecting is East, East1, West , West 1. How do I modify the script?

    My lack of understanding of NOT Exists is not helping me. 

    Show Less
  • forum

    Qlik Sense Data Connectivity

    Sum Field based on other two fields aggregated

    Hello Qlik community !! I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount. My data consists of transactions between the buyers a... Show More

    Hello Qlik community !! 

    I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount. 

    My data consists of transactions between the buyers and sellers which can be interchangeable, in other words, entity X can appear both as seller and buyer. What i want to do is rank the buyers and sellers as a single entity  "Company" based on the Sum of the total amount, whether they acted as buyer or seller. 

    For example supposing I have this values in my Table:

    Table:

    [ Date, Buyer, Seller, Total Amount 

      12/05/2020, Apple, Amazon, 2000

      13/05/2019, Amazon, Apple 2500

      01/01/2020, Apple, Microsoft, 1000

    ]

    I want a table-chart that displays: (Rank, Company, TotalAmountTransactioned)

    1 - Apple - 5500

    2 - Amazon - 4500

    3 - Microsoft -1000

    Will really appreciate it if someone can help me 🙂

     

    Show Less
  • forum

    Qlik Deployment Framework

    Your license quota has been met

    I was upgrading from a Qlik Sense Free Trial to Paid version. I recieved a welcome email that needed to be activated...once activated an error message... Show More

    I was upgrading from a Qlik Sense Free Trial to Paid version. I recieved a welcome email that needed to be activated...once activated an error message "You have met the allowable number of tenants you can create. To manage your license, contact Qlik Sales." is there any way to resolve this today without waiting for someone from sales to get back to me tomorrow? 

    Show Less
  • forum

    Qlik Sense App Development

    Create a custom chart MAP

    Hello,I have an exercise to perform which consists in creating a personalized map in order to add heat points according to the zones impacted by an in... Show More

    Hello,

    I have an exercise to perform which consists in creating a personalized map in order to add heat points according to the zones impacted by an indicator. To facilitate the work, I cut the map into 6 zones.

    football_stats.jpg

     

    Do you know if it is possible to do this with Qliksense please? If so, how please?

    thank you

     

    Show Less
  • forum

    New to QlikView

    Autocomplete empty records with a previous value

    HELOI have a little problem. I have two views: Master Calendar and TempLET vMinDate = Num(MakeDate(2020,9,18));LET vMaxDate = Num(Today()-1);LET vDays... Show More

    HELO

    I have a little problem. I have two views: Master Calendar and Temp

    LET vMinDate = Num(MakeDate(2020,9,18));
    LET vMaxDate = Num(Today()-1);
    LET vDays = vMaxDate - vMinDate + 2;
    Master Calendar:
    LOAD
    date(floor(TimeStamp,0.000694444446708076),'YYYY-MM-DD hh:mm:ss')as CreationDate
    ;
    LOAD
        Timestamp($(vMinDate) + (RecNo() - 1)/1440) as TimeStamp
    AUTOGENERATE 1440 * $(vDays);

    Temp:
      
    LOAD * INLINE [
         CreationDate, Stan
        2020-09-18 00:07:12, A
        2020-09-18 00:10:12, B
        2020-09-18 00:15:12, C
        2020-09-18 00:18:12, D
        2020-09-18 05:22:12, A
        2020-09-18 05:25:12, B
        2020-09-18 08:32:12, C
        2020-09-18 08:34:12, D
        2020-09-18 07:12:00, A
        2020-09-18 08:42:12, B
    ];
     
     
    After reloading the script, I have tables 

     

    CreationDateStan
    2020-09-17 23:59:12 
    2020-09-18 00:00:12 
    2020-09-18 00:01:12 
    2020-09-18 00:02:12 
    2020-09-18 00:03:12 
    2020-09-18 00:04:12 
    2020-09-18 00:05:12 
    2020-09-18 00:06:12 
    2020-09-18 00:07:12A
    2020-09-18 00:07:12 
    2020-09-18 00:08:12 
    2020-09-18 00:09:12 
    2020-09-18 00:10:12B
    2020-09-18 00:10:12 
    2020-09-18 00:11:12 
    2020-09-18 00:12:12 
    2020-09-18 00:13:12 
    2020-09-18 00:14:12 
    2020-09-18 00:15:12C
    2020-09-18 00:15:12 
    2020-09-18 00:16:12 
    2020-09-18 00:17:12 
    2020-09-18 00:18:12D
    2020-09-18 00:18:12 
     
     
     
     

    How to fill in empty fields in a table with an earlier value. I suppose you have to use the privus function.
    But how ???

     
     
    Show Less
  • forum

    New to QlikView

    Extract a list of fields from a Table (concatenated)

    HiPFAI am trying to extract a list of distinct Tablenames into a delimited string, and I'm not getting it right.I'm thinking I could probably use the ... Show More

    Hi

    PFA

    I am trying to extract a list of distinct Tablenames into a delimited string, and I'm not getting it right.

    I'm thinking I could probably use the current For..Next ("For Count...")loop to get this, and not to have another resident load.

    In fact, I would need to do exactly the same for the field REQ_DATE and REQ_HOUR (long story..... 🙂

    Please may you have a look - here is my model.

    Thanks

    Show Less
  • forum

    QlikView Scripting

    Case 935 How to Get Average amount = 12/2=6 ? Now Getting 3

    Hi AllBelow is the load script :-Accounts_001:LOAD * INLINE [DocNum,TotalSumSy,Customer_Name1,3,SERVO ENGINEERING SDN BHD1,3,SERVO ENGINEERING SDN BHD... Show More

    Hi All

    Below is the load script :-

    Accounts_001:
    LOAD * INLINE [
    DocNum,TotalSumSy,Customer_Name
    1,3,SERVO ENGINEERING SDN BHD
    1,3,SERVO ENGINEERING SDN BHD
    2,5,SERVO DYNAMICS SDN BHD
    ];


    For Each i in 501
    WhatIfDimension$(i):
    LOAD * INLINE [
    Pls select $(i)st Dim,Column$(i)
    SOURCE,SOURCE
    SQ_Num,DocNum
    Total,Total
    Customer_Name,Customer_Name
    ];
    NEXT i;

    My Table Dimension :-

    =$(ColumnDim501)

    My Table expression :-

    =pick(Match([Pls select 61st Dim],
    'Ave_SQ_Amt',
    'Total_SQ',
    'Total_Amount',
    ),
    sum($(ColumnDim61))/count(DISTINCT $(ColumnDim61)),
    count(DISTINCT $(ColumnDim61)),
    sum($(ColumnDim61))
    )

    Total Amount = 12 is correct :-

    paulyeo11_0-1600486608741.png

    Total number of Quotation = 2 is correct :-

    paulyeo11_1-1600486716231.png

    Base on above Total =12 And No of Quotation = 2 Average = 12/2=6 , But my result shown = 4 which is wrong :-

    paulyeo11_2-1600486811173.png

    Hope some one can advise me.

    Paul Yeo

     

    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

Data Revolution Virtual Summit

The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data.

October 27 - 29, 2020 Virtual Summit

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