Qlik Community

Welcome to Qlik Community

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

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

    New to QlikView

    Show Average by month

    Hi,I have a line chart which shows the trend of  sales by week . I used the data refreshed date  as date field , it was every monday . So , my requirm... Show More

    Hi,

    I have a line chart which shows the trend of  sales by week . I used the data refreshed date  as date field , it was every monday . 

    deepakkrish_0-1594820153926.png

    So , my requirment is I have to show the Average trends by month using the Date . How to show the avg percentage by month ? Pls let me know if you required details.

    For example june month Avg will be = 96.60+96.64+96.69+96.78+97.06/5  

                                                            =96.75

     

    Thanks,

    Show Less
  • forum

    New to Qlik Sense

    Pivot Table Background Color by measure

    Hi all.I have pivot table like below.  I want to color background min and max number by month(Ay) or  like picture right. I used  formula like this.  ... Show More

    Hi all.

    I have pivot table like below.  I want to color background min and max number by month(Ay) or  like picture right. 

    I used  formula like this.  =colormix1(sum(Sales)/Max(TOTAL aggr( Sum(Sales),Month,CategoryName)),yellow(),lightred())

    fatihtomruk_0-1593270282431.png

    But my pivot tables formula very long as below.  so could you plase help me. 

    my pivot table formula:  

    if([Net/Brut]='NET', sum(if(month(Veri_Kesit_Tarihi) = Month(Today()) and ([Ürün Durumu]='paymentrequired' or [Ürün Durumu]='continue')
    ,[Finans Tutarı])),
    sum(if(month(Veri_Kesit_Tarihi) = Month([Proje Gerçekleşme Tarihi]) and ([Ürün Durumu]='paymentrequired' or [Ürün Durumu]='continue')
    ,[Finans Tutarı])))/1000

    Thank you.

    My Pivot Table: 

    WhatsApp Image 2020-06-27 at 17.56.20.jpeg

    Show Less
  • forum

    New to QlikView

    Default X-axis on Bar Chart to minimize scrolling to the most recent date

    Hello All,Customer is requesting if it's possible to have the the bar chart default to the most recent date so they don't have to scroll to the right ... Show More

    Hello All,

    Customer is requesting if it's possible to have the the bar chart default to the most recent date so they don't have to scroll to the right everytime they open the Qlikview app.  By default, the Bar chart displays on the first date data is available (see screenshot #1), what we'd like it to default to the current date (screenshot #2).  Any assistance would be greatly appreciated.

     

    Thanks!

    Show Less
  • forum

    Qlik Sense App Development

    Qliksense Session Access with error: Access Denied

    Hi dears, hope everyone be safe in your houses 🙂I am finishing an App in prototype and going to industrialization and that's why I am including SESSI... Show More

    Hi dears, hope everyone be safe in your houses 🙂

    I am finishing an App in prototype and going to industrialization and that's why I am including SESSION ACCESS with Reduction (this last one is working fine )

    Issue: Some users cannot access the App (error: Access Denied), but other users can. Obviously I have checked like 3 times to make sure the users are into the table of users

    How am I loading the Users?: As we have some different countries and each one share/access data, we got different folders in the network and the idea is that any country could see only the information of its on country. That's why I created a file inside this folder where I expect the local "app owners" can include the users they want to have access. When someone needs global access, I am the responsible for giving access and I include the user in the appropriate table where only I have access.

    Attached the script and also the files I am using. Could someone give me some direction of where should I start looking for?

    Thanks, Andrey

    Show Less
  • forum

    Qlik NPrinting Discussions

    Fewer Records Than Expected with On-Demand

    Has anyone ever come across this?  I have a straight table that contains 50 rows and when I use NPrinting On-Demand to generate an Excel report using ... Show More

    Has anyone ever come across this?  I have a straight table that contains 50 rows and when I use NPrinting On-Demand to generate an Excel report using this same table, I only get 35 rows in the report.  However, if I export the table from Qlik Sense directly to Excel, I get all 50 rows.

    My company is currently on the April 2020 Release.

    Show Less
  • forum

    New to QlikView

    Average calculation at the script level

    Dear All!Appreciate, if I'm helped with, to calculate average at the script level so that I need to be able to write a nested if statement to prepare ... Show More

    Dear All!

    Appreciate, if I'm helped with, to calculate average at the script level so that I need to be able to write a nested if statement to prepare a class  like (>30000, 20000-30000,10000-20000 ) etc ,based on the average computed at the script level. Since the value given is not the average the class function to be based on the average. Also, the average here should be the half of the value of each employee.

     

    Thanks in advance

     

    Neville

    Show Less
  • forum

    QlikView App Development

    Set Analysis Help Needed

    Hi Team, I have  EID,Date(multiple months) and TeamCode. If i want to check if TeamCode or that EID for that month is same as previous or mentioned mo... Show More

    Hi Team,

     

    I have  EID,Date(multiple months) and TeamCode.

     

    If i want to check if TeamCode or that EID for that month is same as previous or mentioned month , how do i do it in set anlaysis.

    I want count of those EID, whose teamcode for that month is not same as previous/variable month.

    Show Less
  • forum

    Qlik Sense Deployment & Management

    Qlik Sense Operations Monitor (and Others) Not Reloading

    About a month ago, our virtual server that houses Qlik encountered a low drive situation where it hit less that 10% available.  While I figured 25GB w... Show More

    About a month ago, our virtual server that houses Qlik encountered a low drive situation where it hit less that 10% available.  While I figured 25GB was still plenty, Qlik didn't like it, and it crashed on me.  We recovered the entire virtual machine from a backup, I cleared out TONS of old logs, and freed up over 80GB of space.  Ever since this event, several of my monitoring apps won't reload.  Most of their error logs are showing a version of this:

    20200715T164146.440-0700 0557 SELECT * FROM "public"."view_audit_activity_audit_security"
    20200715T164146.440-0700 0558 WHERE entry_timestamp >= '2020-04-15 00:00:00'
    20200715T164147.171-0700 Error: Field 'entry_timestamp' not found

    I figured since we were running on the November 2019 release, and I needed to perform an upgrade, things would resolve themselves when I went to February 2020.  I've done that this past Monday, and it's still having issues.

    So here's my question:  I believe there are QVDs or other supporting data on the Qlik server that I can remove & the apps will rebuild the data sources that they need.  Based on that, can someone point me to links or information on what to remove?  I've done multiple searches, but feel like I can't find specifically what is necessary.

    Thank you in advance, and I appreciate your efforts to guide me!

    Apps Currently Failing:

    1. License Monitor
    2. Log Monitor
    3. Operations Monitor
    4. Reloads Monitor
    5. Sense System Performance Analyzer
    6. Sessions Monitor

    Successful Apps:

    1. App Metadata Analyzer (newly installed)
    2. Connector Logs Analyzer
    Show Less
  • forum

    New to QlikView

    Set analysis help Expression

    AsOfDateEmployeeIDTeamCodeRegionDepartmentTeam2020-05-311111012CSouthRetail ADigital A2020-05-312222132VNorthRetail BDigital B2020-06-302222472HEastRe... Show More
    AsOfDateEmployeeIDTeamCodeRegionDepartmentTeam
    2020-05-311111012CSouthRetail ADigital A
    2020-05-312222132VNorthRetail BDigital B
    2020-06-302222472HEastRetail CDigital C
    2020-06-303333475UEastRetail CDigital F
    2020-06-304444413NWestRetail DDigital G
    2020-07-312222763IEastRetail DDigital H
    2020-07-315555472HEastRetail CDigital C
    2020-07-304444472HEastRetail CDigital C

     

    This is the employee data, i want create headcount analysis.

    I cannot do anything in the script. All data will just get appended anymonth.

    User will select 2 months for comparison and 

    They want get  New to the company, Retained , Resigned from the company, Internal transfer

    this should be valid based on selection of Region, Department and Team

    So when i compare June and July Month i  select  only Team (Digital C ), I should get output

    New to Bank: 1 (Employee 5555)

    Resigned from Bank: 0

    Internal Transfer: + 1 (Employee 4444)

    Internal Transfer: -1(Employee 2222)

     

    So when i compare June and July Month i  select only Region (East) , I should get output

    New to Bank: 1 (Employee 5555)
    Resigned from Bank: 1 (Employee 3333)
    Internal Transfer: +1 ( Employee 4444 )
    Internal Transfer: -0

    Note: Any two months can be selected for comparison, Jan Mar, Jan Nov, Feb Apr, June Nov, etc

    Hint: Lowest grain is Team Code, If team code of employee is present and not present in last month , he is new to the bank,
    if team code of employee is not present this month but present in last month, his has resigned

    if team code is present for both month but different and it is same as filter selection, +ve internal transfer,

    if team code is present for both month but different and it is  not same as filter selection, -ve internal transfer

     

    I have a composite key of EmployeeID,Teamcode at the backend if useful

    Show Less
  • forum

    New to Qlik Sense

    Qliksense pivot table Create column based on measures

    Hi all,we want to create column  based on measures, for sample as below, could you help to share some ideas? Thanks in advance.For below screenshot wh... Show More

    Hi all,

    we want to create column  based on measures, for sample as below, could you help to share some ideas? Thanks in advance.

    For below screenshot what we can achive in Qliksense now, we want to create column, for column C(Budget) and D(Consumption) we create column'A' for them, for E(Scan),F(Second_scan) and G(Retailer_Scan), we create column 'B', for H(Budget%),I(Second_Scan%) and J(Retailer%) we create column 'C'.

    zhaohaifeng_0-1594862401248.png

    Below screenshow was what we want to achive,

    zhaohaifeng_1-1594862676129.png

     

    Is it possible for this setting in visualization level? Thanks.

    Best Regards,

    Haifeng

     

    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

Qlik Customers Share COVID-19 Supply Chain Strategies

Amazon Produce Network and Odyssey Logistics discuss how they’re using Qlik to help manage their operations during Covid 19

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

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