Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,413 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

  • New to Qlik Sense

    Sum a column based on the values in another column

    Hi Everyone,I am trying to sum values based on the GL Account for multiple rows. Similar to the below: NameGross AmountGL AccountJoe1000408000Betty150... Show More

    Hi Everyone,

    I am trying to sum values based on the GL Account for multiple rows. Similar to the below:

     

    NameGross AmountGL Account
    Joe1000408000
    Betty1500408005
    Frank12000577209
    Louisa5022408000
    John4545408008
    Cathy5868408004

     

    So basically I want to sum the Gross Amount, but only for GL Accounts '408000', '408004', '408005', and '408008'. So I don't want to include '577209'.

    So my column should display a total of 17,935.

    Could you help me write a function to capture the appropriate data?

     

    Show Less
  • New to Qlik Sense

    Connection failed in Log server folder in license Monitor Application in Qliksen...

    Hi Team,  In Qliksense License Monitor Application the below error occurs. Please help on this ..The following error occurred:Connection not found: Se... Show More

    Hi Team,

      In Qliksense License Monitor Application the below error occurs. Please help on this ..

    The following error occurred:
    Connection not found: ServerLogFolder
     
    The error occurred here:
    for each textFile in FileList(logName & '*.' & extension)
     
    Data has not been loaded. Please correct the error and try loading again.
     
     
     
    Capture1.PNG

     

     

    Show Less
  • New to Qlik Sense

    The total option isn't totaling the column and I dont know why

     Here is the underlying script(FABS(Sum([Actual Units])-Sum([Forecasted Units]))/Sum([Actual Units]))*(Sum([Actual Units])/Sum(total<[Date]>[Actual Un... Show More
     

    Qlik total.PNG

    Here is the underlying script

    (FABS(Sum([Actual Units])-Sum([Forecasted Units]))/Sum([Actual Units]))
    *
    (Sum([Actual Units])/
    Sum(total<[Date]>[Actual Units]))

     
    Show Less
  • QlikView App Development

    QV12.30SR3 - QMC displaying “Cluster is down” and the status of all tasks is “Un...

    QV12.30SR3 - QMC displaying “Cluster is down” and the status of all tasks is “Unrunnable"Description: We have observed that for a few minutes the QV d... Show More

    QV12.30SR3 - QMC displaying “Cluster is down” and the status of all tasks is “Unrunnable"

    Description: We have observed that for a few minutes the QV distribution service shows as down and all the tasks in the QMC display the status as "Unrunnable".

    And within some 3-4 minutes the QV distribution service resumes automatically and tasks status also changes back to previous status.

    We have also observed, that there were two tasks which went into long running state since the "Unrunnable" error occurred on QMC.

     

    Show Less
  • QlikView Deployment

    Change the location of source documents

    Hellowe are working on Qlik View server 12 SR3we already have a lot of source document with so many tasks definedNow we want to change the location of... Show More

    Hello

    we are working on Qlik View server 12 SR3
    we already have a lot of source document with so many tasks defined
    Now we want to change the location of the source documents; now if we change path of the source folder will the tasks still be runnable on the documents actually defined on?
    Kindly advise on how to do so without losing the tasks and their triggers etc...

    Show Less
  • QlikView Layout & Visualizations

    Bar Chart y-axis meet x-axis

    Somewhat new to this and could not find any similar articles.I have a list in column A that have multiple values. I'm trying to create a bar graph whe... Show More

    Somewhat new to this and could not find any similar articles.

    I have a list in column A that have multiple values. I'm trying to create a bar graph where the x-axis is any unique values in column A. Y-axis is to be a total count if that unique value shows up. I've created something in excel, attached, to show what I'm trying to depict as the final graph; however, I'm unable to do it in Qlikview.  Any help would be great, thanks in advance!

    Show Less
  • QlikView Security & Governance

    Security Access QlikView

    Hello,I'm new in this Community and i would like to submit a question about Security Access in QlikView.Is it possibile to define an access security o... Show More

    Hello,

    I'm new in this Community and i would like to submit a question about Security Access in QlikView.

    Is it possibile to define an access security on a Dataset based on a specific Field? I would create a single Dashboard, but more than one user could use and interact with it.

    I need that every users must see the Dashboard filtered by a specific Field for them (for example "Italy Area Manager" must see only data filterd by Field country = Italy and not other countries, but an Executive must be able to see the Dashboard without any restrictions on country).

    is it possible to manage in QlikView and how can I Implement it?

    Thank you.

    Federico

    Show Less
  • New to Qlik Sense

    Load only data that exists in spreadsheets

    Hi all, I have one large data table with unique reference numbers for all events but I only want to load the data for those reference numbers that exi... Show More

    Hi all, 

    I have one large data table with unique reference numbers for all events but I only want to load the data for those reference numbers that exist in three separate spreadsheets (keeping the data from each spreadsheet separate). 

    e.g. 

    Data Table Spreadsheet ASpreadsheet BSpreadsheet C
    1  1
    22 2
    3 3 
    44 4
    5   
    6  6
    7 7 
    8  8

     

    So I only want the following loaded:
    Spreadsheet A = reference numbers 2 and 4 (loaded as Ref A)
    Spreadsheet B = reference numbers 3 and 7 (loaded as Ref B)
    Spreadsheet C = reference numbers 1, 2, 4, 6 and 8 (loaded as Ref C)

    Hoping this makes sense to someone! 

    Show Less
  • QlikView App Development

    QlikView 12.30SR3 - Extra decimal places while exporting data in excel

    QlikView 12.30SR3 - Extra decimal places while exporting data in excelDescription - When trying to do an excel download for a straight table having th... Show More

    QlikView 12.30SR3 - Extra decimal places while exporting data in excel

    Description - When trying to do an excel download for a straight table having the 'Number Format Settings' as "Expressions Default" the values are showing up with 14 decimal places in the excel.

    We have also tried changing the format to "Fixed to" 5 decimal places and it gave number with only 1 decimal place.

    Whilst in 12.10 the decimal places for such straight table setting was 4.

    Is there any manual setting where we can change the decimal places to 4 for a straight table?

    Show Less
  • Qlik NPrinting Discussions

    NPrinting On Demand: change sorting export list

    Hi,is it possible to change the sort order in the export list of the on demand control? HTML is currently standard. Xlsx should appear as the first va... Show More

    Hi,

    is it possible to change the sort order in the export list of the on demand control? HTML is currently standard. Xlsx should appear as the first value. 

    Thanks for your help.

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

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 World 2020

Get the most value from your data and see the hottest trends in data and analytics. Join us in Phoenix, AZ. Register by December 31 to save $400.

May 11- 14, 2020 Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Data Revolution Virtual Forum

An exclusive online event where industry experts share practical advice to help your entire team take charge of their data.

Find a location December 3, 4 and 5th