Qlik Community

Welcome to Qlik Community

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

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 eight unique blogs. Check out the new Architecture Deep Dive 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.


WEBINAR SERIES: THE DX FILES

When disruption is nonstop, how do you compete – and thrive? Digital Transformation is a must, and data is at the heart of it. To pull ahead of the pack, stay in front of the trends, and keep pushing innovation further, you have to consistently reinvent your business – fast – with a modern approach to data. When it comes to Digital Transformation, the truth isn’t out there – it’s in here. Join us July 30 – August 28, 2019, for 5 tracks of insight-packed webinars.

Recent Discussions

  • New to Qlik Sense

    How to replace a null chart

    I created a hotel dashboard myself and I made a filtering on some dates and some times not all corporate guest made a booking on that date. How d... Show More

    1.PNG

    I created a hotel dashboard myself and I made a filtering on some dates and some times not all corporate guest made a booking on that date. 

    How do I replace this blank chart with a message that is saying 'No corporate booking in this period' 

    Thanks

    Show Less
  • New to QlikView

    Help with Invoice equal to zero

    Hello community!!I am currently working on a dashboard that allows me to identify invoices that are equal to zero.I have noticed the existence of some... Show More

    Hello community!!

    I am currently working on a dashboard that allows me to identify invoices that are equal to zero.
    I have noticed the existence of some charges in the invoices that not in all cases is correct to be billed as "shipping cost invoice" and "delinquency cost". Then I should be able to calculate two KPI'S:

    1) when the invoices are equal to zero.
    2) and when the sum of "Total Invoive Charge" in field
      INVOICE_NUM is equal to zero, assuming there are no charges: "shipping cost invoice" and "delinquency cost"

    Point 2) will help me establish more precisely the service charges that really are zero. 

    Example 1.jpg

     The previous example shows a case that when adding the threes charges of the invoice the total is 8, but really the charge is zero, since it includes the items not to be considered for the analysis.

    The third requirement is not a KPI, but I would like to be able to write a field from the script in order to have the "Total Amount of the Invoice". Currently the data brings the total but at the level of charge.

    Finally, I have included a ready list related to point 1) and allow filtering the cases with invoices equal to zero, with the following expression: = Aggr (if (sum ([Total Invoice Charge]) = 0, 'Invoice Equal to zero ',' N / A '), [Invoice-Num]). I would like those cases only to be in a pivot chart (try it but it shows me the rest of the cases) and also in a bar chart.

    Thanks again, counting on your usual help

     

     

     

     

    Show Less
  • Qlik NPrinting Discussions

    Qliksense Native Straight Table data + NPrinting + Output format PPT Issues

    Hi, We have Qliksense Tabular Data in Qlik native straight table and need PPT Output format using NPrinting. Need to Display table only when it has da... Show More
    Hi, We have Qliksense Tabular Data in Qlik native straight table and need PPT Output format using NPrinting. Need to Display table only when it has data Qliksense and NPrinting both are NOV 18 versions. Issue: Shows table header, even if it does not have data. We can add condition in setup to not generate report if particular table does not have data, but we do not see option only not to display that particular table in report generated. Please help how to solve this Thanks, Narayana Show Less
  • Qlik NPrinting Discussions

    Qliksense + NPrinting + Output format PPT Issues

    Hi, We have Qliksense Tabular Data in Qlik native straight table and need PPT Output format using NPrinting.Need to use some variable data as headers ... Show More

    Hi,

    We have Qliksense Tabular Data in Qlik native straight table and need PPT Output format using NPrinting.

    Need to use some variable data as headers in PPT output report.

    Qliksense and NPrinting both are NOV 18 versions.

    Issue:

    Variable name also appears along with variable data when variable used in ppt template

    Please help how to solve this.

    Thanks,

    Narayana

    Show Less
  • Qlik GeoAnalytics Discussions

    Why is GeoAnalytics slower than Original Map?

    Hi I'm load a Line Layer of 70,000 lines into GeoAnalytics Line Layer. Each line has its color defined by a measure (0.3-0.6).I found the loading... Show More

    Hi 

    I'm load a Line Layer of 70,000 lines into GeoAnalytics Line Layer. Each line has its color defined by a measure (0.3-0.6).

    I found the loading and response time of GeoAnalytics is about 5 times slower than the old map. Is this normal?

    Thanks

    Bing

    Show Less
  • New to QlikView

    help with rolling period calculation

    Hi All,I'm trying to do a pretty straight forward rolling period calculation in Qlikview - at least it's pretty easy to do in ExcelI'm calculating a r... Show More

    Hi All,

    I'm trying to do a pretty straight forward rolling period calculation in Qlikview - at least it's pretty easy to do in Excel

    I'm calculating a rolling 4 week period - as per the below -  the percentages are the answer i'm trying to achieve

    i.e - after the completion of  previous week, sum(last 4 weeks)/4

    Saturday  
     0% 
     0% 
     0% 
    125% 
     25% 
    150% 
     50% 
    150% 
    175% 
    175% 
     75% 
     50% 
     25% 
     0% 
    125% 
    150% 
    175% 
     75%COUNT(CD38:CD41)/4
     50% 
     25% 
     0% 
     0% 
    125% 
     25% 
     25% 
     25% 
    125% 
     25% 
    150% 
    175% 
    175% 
    1100% 
    1100% 
    1100% 
     75% 
     50% 
     25% 
     0% 
     0% 
     0% 
     0% 
     0% 
    125% 
    150% 
    175% 
    1100% 
     75% 
    Show Less
  • New to Qlik Sense

    Ranking customers both on the current and previous years in one table (and restr...

    Hi everyone, I hope the title is not too confusing, but basically I have a table looking like following: Table: [date, sales volume, custome... Show More

    Hi everyone, 

    I hope the title is not too confusing, but basically I have a table looking like following: 

    Table:
    [date, sales volume, customer
    01.01.1970, 100, A
    01.01.1970, 200, B
    ...
    31.12.1970, 500, C
    31.12.1970, 550, D
    ...
    01.01.1971, 120, A
    01.01.1971, 230, B
    ...
    31.12.1971, 550, C
    31.12.1971, 650, D
    ]

    What I need to do is to have table which basically shows 10 clients with biggest sum([sales volume]) this year,

    and shows those clients' ranks in the previous year.

     

    I do understand how I rank current year (with set analysis), but can't get my head around how to rank the previous year's sales in the same table

    Any help would be really appreciated,

    Thanks in advance 

    Show Less
  • QlikView Creating Analytics

    Intersecting Values with Set Analysis

    Hi All,I have attached a Test.qvw and Test.xlsx to make this request a bit easier hopefully. I need to, using a pivoted spreadsheet find the inte... Show More

    Hi All,

    I have attached a Test.qvw and Test.xlsx to make this request a bit easier hopefully. 

    I need to, using a pivoted spreadsheet find the intersecting values between 2 calculated expressions (for convenience i have simplified these in the example) - Turnover and Margin%. If the Turnover is between the threshold provided and the intersecting Margin% falls in one of the Margin Tiers the intersecting value must be provided as the result. 

    Capture.JPG

    I am not considering Intervalmatch because the Turnover and Margin% are actually complex calculations calculated in the frontend and there is no link to this spreadsheet using store or any other field. It is a global guideline.

    Capture2.JPG

     

     

     

     

     

     

     

    Thank you in advance!

    Regards,

    Richard

    Show Less
  • Qlik Sense Advanced Authoring

    X-axis in bar graph

    Can anyone tell me why the negative months aren't ascending? =Replace(Class([Req Projected Need Lead Time Days]/30, 3), '<= x <','-')
  • Qlik Sense App Development

    Pivot table export in merged format in QlikSense

    Hello Friends,Appreciate your time.  I am using a Pivot table for one of my chart , but is it possible to export the same in a merged format as l... Show More

    Hello Friends,

    Appreciate your time.  I am using a Pivot table for one of my chart , but is it possible to export the same in a merged format as like a straight table  data while exporting alone anything using native QlikSense or Vizlib is ok.

     

    Thank you,

    Kiruthiga

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.