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)

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 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 ?

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!

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

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.

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

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

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

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

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.