Qlik Community

Welcome to Qlik Community

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

Discussion board and documents related to Qlik Associative Big Data Index.

Find a forum to ask a question or start a discussion.

Information about additional Qlik opportunities and offerings.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion Boards and Documents for Qlik Services.

View our Technical Blogs for updates and information.

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.

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.

Register for Qonnections


Register for Qonnections
Save $100


Follow your data to the biggest places imaginable. Join Qonnections in Dallas, Texas May 13-16. Get insights to help you and your team drive real transformation. Register by April 28 for your last chance to save $100.

Recent Discussions

  • New to Qlik Sense

    Can I use report results as data source?

    I have a table which contain complex logic, the logic are not written in script but are written in visualization. Other apps want to use this table re... Show More
    I have a table which contain complex logic, the logic are not written in script but are written in visualization. Other apps want to use this table results. Can I use report results as data source for other apps use? Thank you in advance. Show Less
  • New to Qlik Sense

    Set Analysis not working in MAP visualization

    Hi,I have build a map visualization where I am trying to color by measure (and than put values in every dimension value), and I put this set analysis:... Show More

    Hi,

    I have build a map visualization where I am trying to color by measure (and than put values in every dimension value), and I put this set analysis:

    sum({1} {<Regione>} Dipendente)

    I use this because I want that when I click on a Regione Value then it will keep the same dimension values displayed.

    If I use this formula on a table it works, but when I put it in a MAP Visualization it apply the selection and doesn't work like in a table.

     

     

    Show Less
  • Qlik NPrinting Discussions

    Connection metadata reload "randomly" fails with error NPrinting Engine failed t...

    Hi everyone!Do any of you ever experienced random connection metadata reload errors? NPrinting Engine failed to open documentGiven the same qvw f... Show More

    Hi everyone!

    Do any of you ever experienced random connection metadata reload errors? NPrinting Engine failed to open document

    Given the same qvw file (no changes), one time fails and the next succeeds:

    2019-04-12 13_55_52-Qlik NPrinting.png

     

    Heres my spec:

    NPrinting version: Sept 2018 SR2

    Server: dedicated machine, 32GB ram, avg used memory 20%

    Connection Type: Local

    Section Access in document: No

    Connection Verification: Success

    Reload Trigger: Daily

     

    I can solve by attempting a new manual reload but it is annoying because we run daily reports that must rely on updated information out of the qlikview dashboards.

    Please let me know if you have any ideas, thanks in advance!

     

     

    Show Less
  • New to QlikView

    Definition in Pareto

    Dear all, Can someone tell me whats wrong in this definition:RangeSum(Above(Sum(Sum([Lengte])*[effective width]/1000),0,RowNo()))/Sum(TOTAL(Sum (... Show More

    Dear all,

     

    Can someone tell me whats wrong in this definition:

    RangeSum(Above(Sum(Sum([Lengte])*[effective width]/1000),0,RowNo()))/Sum(TOTAL(Sum ([Lengte])*[effective width]/1000)

     

    Thank you in advance!

    Show Less
  • QlikView Scripting

    QVD losing formats of dates when concatenating

    Hello everyone,I'm facing an issue with an incremental load in Qlikview.The troubles started when I have been changed the source file from .txt to .xl... Show More

    Hello everyone,

    I'm facing an issue with an incremental load in Qlikview.

    The troubles started when I have been changed the source file from .txt to .xlsx therefore I had to slightly modify the script to reload it correctly. The issue is however related to the QVD with the historical data.

    Here's what happens:

    If I load the QVD with a LOAD * or a LOAD with explicit field names it loads with the correct formats without any problem.

    But I need it to be concatenated to the new data I'm pulling off my excel file. 

    During the script the excel is loaded in memory, I add a comparison field for the NOT EXISTS clause and finally

     

    Concatenate (In memory table)

    LOAD * FROM [QVD.QVD] (qvd)

    WHERE NOT EXISTS (KEY,COMPARISONFIELD);

     

    The comparison field happens to be a Date in DD/MM/YYYY format. 

    But whenever I concatenate it turns into a number (and obviously fails the check of the NOT EXISTS).

    Any idea on how to solve that? 

    I even tried loading explicit field names with the date() function with no success.

     

    Show Less
  • New to QlikView

    Need help in Incremnetal load

    Hello all, Please answer my query below and give me the solution..question: : we will get the latest file everyday from thespecific location and we wi... Show More

    Hello all, Please answer my query below and give me the solution..

    question: : we will get the latest file everyday from thespecific location and we willconcatenate with the existing QVD. Nowt,The challenge is for Monday we get 3 excel files  (as saturday and Sunday are holidays) and the script loads only the latest file and skips 2 files.

     

    // To find the Latest file and time in a folder

    for each File in filelist ('..\Desktop\testsample\sample*.*')

    Folder:
    Load '$(File)' as FileName,
    FileTime( '$(File)' ) as FileTime
    autogenerate 1;
    next File


    LatestFile:
    first 1
    Load
    FileName,
    FileTime,
    1 as dummy
    Resident Folder
    Order By FileTime DESC;
    drop table Folder;


    Let vLastReload=Peek('FileTime',0,'LatestFile');
    LET vFileNamenew = subfield(File,'\',SubStringCount(File,'\')+1);



    //After getting  find the latest file name concatenate with existing QVD....



    Sample1:

    LOAD S_no,
         Name,
         [Roll no],
         DOJ,
         marks
    FROM
    testsample\sample1.qvd
    (qvd);

    FOR EACH File in ('..\Desktop\testsample\sample*.xlsx')

    //Exit Script;

    Concatenate(Sample1)

    LOAD S_no,
         Name,
         [Roll no],
         DOJ,
         marks

      FROM [testsample\$(vFileNamenew)] (ooxml, embedded labels, table is Branch);

    NEXT

    Store Sample1 into [testsample\sample1.qvd].(qvd);


    Exit Script;

     

    Show Less
  • New to Qlik Sense

    Profiling error qlik sense Feb 2019

    Hi all,can someone tell me what this error means? my version qlik sense enterprise is feb 2019 
  • New to Qlik Sense

    Display Pie Chart with the Count of some data values in one color and the rest i...

    Hello, I have a Data file which includes the occurrence of several different values. I want to group some of those values to be displayed all tog... Show More

    Hello,

     

    I have a Data file which includes the occurrence of several different values. I want to group some of those values to be displayed all together in the same pie sector, while the remaining would be displayed as the leftover sector of the pie chart.

    Simplified Example:

    'Command' values can be: LAYER, PEDIT, 3DORBIT, EXTRUDE.

     

    I want LAYER, PEDIT to be displayed in the color blue and in percentage (e.g. 76%).

     

    I want the remaining values (which are basicaly 3DORBIT, EXTRUDE) to be displayed in the color red and in percentage (remaining 24%).

     

    Qlik Sense 61.png

     

    I have tried:

     

    If(Command = 'LAYER' OR Comando = 'PEDIT', Count(Command), Count(Comando))

    However, it does not distinguish between the first group LAYER and PEDIT from the remaining.

     

    Then I added this to the colors and legend expression:

    if([Comando]='LAYER' OR [Comando]='PEDIT', blue(), red())

     

    Qlik Sense 62.png

     

    Which is pretty close to what I want. However, I want the chart to group the blue percentages and to group the red percentages.

     

    How can I do this?

     

    Many thanks

     

    Show Less
  • New to Qlik Sense

    Evolution by Year, month, week and day

    Hi,I want to show in a pivot table evolution of sales (%) by year, month, week and day.Evolution on year is for example : 2018 vs 2017Evolution on mon... Show More

    Hi,

    I want to show in a pivot table evolution of sales (%) by year, month, week and day.

    Evolution on year is for example : 2018 vs 2017

    Evolution on month is : March 2019 vs March 2018

    Week 21 2019 vs Week 21 2018

    ....

    And for day, 2 possibilities : 27/03/2019 vs 27/03/2018 or  27/03/2019 vs 28/03/2018.

     

    Example for years and months in xls :

    2019-04-19_094601.jpg

    Can we do a pivot table like this in QlikSense?

    Thank you guys !!

    Show Less
  • QlikView App Development

    Particular field values retrive at a time

    Hi,I Have an a field,on that field i have 1000 records for example 1-1000.when i want multiple values to select at a time just drag and drop and rando... Show More

    Hi,

    I Have an a field,on that field i have 1000 records for example 1-1000.

    when i want multiple values to select at a time just drag and drop and randomly selected values purpose we need to check one by one.

    but my user want hey need some input box on that he just pasted the values and automatically retrive all matching values.

    i.e., 1,4,13,67,234,655,6789

     

    these values pasted into particular input box then he retrive all the related data.

     

    Thanks. 

    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.