Qlik Community

Welcome to Qlik Community

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

  • Qlik Sense Integration, Extensions, & APIs

    QRS POST Node js

    I'm trying to call this post / app / content / table method in nodejs, but I get the error: Missing parameter value (s). What am I doing wrong? v... Show More

    I'm trying to call this post / app / content / table method in nodejs, but I get the error: Missing parameter value (s). What am I doing wrong?

     

    var https = require('https');
    var fs = require('fs');
    var options = {
    "rejectUnauthorized": false,
    hostname: 'test.test.com',
    path: '/qrs/app/content/table?xrfkey=0123456789abcdef&name=FindLongLatImported',
    method: 'POST',
    port:4242,
    headers: {
    'x-qlik-xrfkey' : '0123456789abcdef',
    'X-Qlik-User' : 'UserDirectory= Internal; UserId= sa_repository',
    'Content-Type': 'application/json'
    },
    key: fs.readFileSync("C:\\Users\\myuser\\nodeJS\\certificates\\client_key.pem"),
    cert: fs.readFileSync("C:\\Users\\myuser\\nodeJS\\certificates\\client.pem"),
    ca: fs.readFileSync("C:\\Users\\myuser\\nodeJS\\certificates\\root.pem")
    };
    var req = https.request(options, function (res) {
    var responseString = "";
    res.on("data", function (data) {
    responseString += data;
    });
    res.on("end", function () {
    console.log(responseString);
    });
    });
    req.write('"41439c69-2091-4d5c-9dcc-a39431caa9d4"');
    req.end();

     

    Error: Missing parameter value(s)

     

    Show Less
  • Qlik Sense Advanced Authoring

    Count number of days for available rooms

    I'm building a dashboard for hotel purpose and I have this data set I having a problem here to come up with a formula how to calculate available ... Show More

    I'm building a dashboard for hotel purpose and I have this data set 

    as.PNG

    I having a problem here to come up with a formula how to calculate available room on the given date since there are many different people check out on a different date.

    I tried Googling it and I found a solution where COUNTIFS is being used in excel. Anybody know how can I solve this in qlik sense measure ?

    Show Less
  • Qlik Sense App Development

    Qlik Sense-Set analysis-number range

    Hi,I need to create a measure to count customers who aged between 10 and 50 using set analysis, here's my script:Count({$<Age={">10<50"}>}... Show More

    Hi,

    I need to create a measure to count customers who aged between 10 and 50 using set analysis, here's my script:

    Count({$<Age={">10<50"}>}distinct(CustomerId))

    The script looks ok, however the result I get is the total  number of customers, not those who aged 10-50.Can someone tell me what's wrong?Thanks a lot!

    Show Less
  • New to Qlik Sense

    Qlik Sense Cloud Business Microsoft SQL Server Connector

    Hi I am testing out connecting to our SQL Server using the Qlik  MS SQL Server Connector in Qlik Sense Cloud Business.I am able to connectin... Show More

    Hi

     

    I am testing out connecting to our SQL Server using the Qlik  MS SQL Server Connector in Qlik Sense Cloud Business.

    I am able to connecting by filling in the yellow highlighted fields (attached jpg)

    My question is do we need to ensure we either tick the Trusted Connection or NTLM connection to make the connection more secure in any way or is that not necessary?  

    Thanks

    Jo

    Show Less
  • Qlik NPrinting Discussions

    How to repeat first level in every page of teh pixel perfect report?

    Hello,I am using Nprinting pixel perfect report to print profiles of employees. I have created Detail Report- emp id as my first level. In this level ... Show More

    Hello,

    I am using Nprinting pixel perfect report to print profiles of employees. I have created Detail Report- emp id as my first level. In this level I am populating emp name and few other objects. There are 4-5 more levels to populate tables after that.

    I want to repeat the contents (name etc) in Detail1 of level 1 to every page for an employee. Wanted to check if we can repeat teh contents of first level in page top for every page for an emp id.

    Show Less
  • Qlik Sense App Development

    Usage of fields tags and field comments in QlikSens

    Hi AllI don't understand the usage of tags and field comments in QlikSense. I get the part where the $dimension tag and the $measure tag facilitate ea... Show More

    Hi All

    I don't understand the usage of tags and field comments in QlikSense. I get the part where the $dimension tag and the $measure tag facilitate easier browsing in the chart creation dialogs, but that is about what I understand.

    My confusion relates to the tags and comments created in the script, i.e. during loading. My problem is that I don't see them in the sheet design process. I can verify the tags and comments created in the script using the data model viewer, but I don't see the big advantage in this.

    1) I expected the tags and comments to be shown in the sheet-design where fields can be dragged in. Instead, only the field name and the table it belongs to are shown in the comment popup. The tags are not searchable.

    2) I expected the comments and field tags to be "inherited" by the dimension/measure I created. Instead I have to re-create tags and comments, which will then be shown as comment and can be searched.

    What am I missing? What is the power of tags/comments if they cannot be used in the sheet design?

    Given that 1) and 2) does not seem to be implemented, I think it gives app developers a lot of extra work when they struggle to make the data model easily accessible, but then again, I may be missing the big picture 🙂

    Hope you can give me some clues

    Thank you

    Thomas

    Show Less
  • Qlik NPrinting Discussions

    Export Report in failure

    Hello.Under Nprinting fev 2019 sr1I want to export a report under :  C:\NPrintingServer\QV Documents\RapportsI receive the message "myfile.zip co... Show More

    Hello.
    Under Nprinting fev 2019 sr1

    I want to export a report under :  C:\NPrintingServer\QV Documents\Rapports
    I receive the message "myfile.zip could not be downloaded"
    The explanation is probably in the log (attach) but I can not interpret.
    Can you help me

    Jacques

     

    Show Less
  • New to Qlik Sense

    Cummulative Bar Chart - 2 Dimensions

    Hi -  I've been working for hours to create a cumulative bar chart that has 2 dimensions and coming up flat.Dimensions:MonthRoot CauseMeasur... Show More

    Hi -  

    I've been working for hours to create a cumulative bar chart that has 2 dimensions and coming up flat.

    Dimensions:

    Month

    Root Cause

    Measure:

    Case Number

     

    I've read and read and read on this and can't get it to work.  I'd like to see the culmination of the case number of each root cause category by month.

    My Root Cause are the carious lines (i have about 4) and i'd like them to be culminated by month (if that helps).

    here's my current equation

    Aggr(RangeSum(Above(Count([Case Number]),0,RowNo())),[Root Cause], [Action Closure Date.autoCalendar.Month])

     

    please help!

    Lauren

    Show Less
  • Qlik NPrinting Discussions

    Skipping slides inside paging funciton in Power Point for particular dimension v...

    Hi guys,I'm developing an NPrinting Report (April 2019) in Power Point and then exported to pdf. I've created a template that has 10 slides. The first... Show More

    Hi guys,

    I'm developing an NPrinting Report (April 2019) in Power Point and then exported to pdf. I've created a template that has 10 slides. The first two slides are an overview and  from slide 3 to 10 I have configured it as a page for dimension country  so it is looping for each country (6). The structure of the final report has 2 overview slides and then 8*6 slides(8 slides * 6 countries).

    My question is: unfortunatly some countries doesn't have information for some slides, is it possible to programe in NPrinting: if country is "Italy"  do not generate slides 5 to 8.

    I can't move it to pixel perfect and I don't want to remove page function because the maintenance will take years.

    Thank you.

    Pau

     

     

    Show Less
  • Qlik Sense App Development

    Limit the number of records in Qlik sense visualization control

    Hi,I have a requirement to show dates in Table or as a individual field (by dragging it to sheet) to use it as date filter on my qlik sense dashboard.... Show More

    Hi,

    I have a requirement to show dates in Table or as a individual field (by dragging it to sheet) to use it as date filter on my qlik sense dashboard.

     I want to show only 5 dates greater than particular date say it is stored in some variable.

    I was able to show dates greater than particular date but how can I limit them to 5?  

    I am using this expression =if([SETTLE_DATE]>='$(MyDate)',SETTLE_DATE)

    How can I change this expression so that It will show only top 5 dates.

    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.