Hi,

I'm successfully able to trigger on OnDemand Report using the API from a Javascript action using the following code :

function(){   

var data = JSON.stringify({"type":"report","config":{"reportId":"87d35c6-0b10-201p-edf5-7239562219e2","outputFormat":"PDF"}});

var xhr = new XMLHttpRequest();

xhr.open("POST", "https://mynprintserver.com/api/v1/ondemand/requests");
xhr.withCredentials = true;
xhr.setRequestHeader("Content-Type", "application/json");
xhr.send(data);
 
  }   

Can any help with the code for passing any user selections across also? 

Many thanks,

Dai

I have a setup of values in a table that looks like this, but with more rows:

test1:
LOAD * INLINE [
Participant, Date
a, 2020-12-07
a,2020-12-08
a, 2020-12-09
b, 2020-12-07
b, 2020-12-09
c, 2020-12-08
c, 2020-12-09
c, 2020-12-10
d, 2020-12-10
e, 2020-12-07
];

I want to make a bar diagram that shows the mean paticipants per day for a whole month. I can count participation per day, but not the mean value for the month.

Hello Everyone,

I'm new to QS, but seasoned in QV.  I have migrated my first QS app to the cloud.  I am not using Section Access.  I have published it to a stream called Human Resources and have assigned my users to that stream.  When I open the app in the cloud I get the message "An Error Occurred - Access is denied".  I can click on the close button and proceed around the app.  It only happens on the first screen.  Any ideas what I might be missing?

Hi,

I am using Printing 18.0.1 version in designer and server.I need to create table details in Nprinting  which same as my Qlik Sense App (3+ version).I cant get the completed table data in NPrinting in details level.When i am checked in community We need to add the object levels for getting detail reports.

NPrinting 17 - pixel perfect levels

but in my designer i try to search the table objects in Levels .There is no object is showing  me.but those objects i can add in Table objects.

Please help me is there any bug present in my tool for not showing the tables objects in Levels.

Hi there,

We recently upgraded to Qliksense November 2020 Patch 2 from Qliksense June 2020.  We had a MongoDB connection running prior to the upgrade.  After the upgrade, the extract started crashing.  When I tried to test the connection, I got the following error:

ERROR [HY000] [Qlik][MongoDBODBC] (110) Error from MongoDB Client: Authentication failed. (Error Code: 11)

I tested this on an older version of Sense and had no issues.  I see that changes have been made to the connector where more parameters are available, but don't see anything in the docs about changed behaviour.  Is this a bug, or do I need to adjust something on the config of this connection?

Hello,

I upgraded from Qlik Feb 2019 to Qlik Nov 2020.  I have noticed a new hover menu that appears larger on my filters, etc.

The solution is to disable the Hover Menu for each filter.  I need to now review all my Dashboards and change this setting.

Has anyone else experienced this new feature?  I find that the larger hover menu with the additional option interferes with users making selections.

Thank You,

Michael

I am trying to get the table with all my current filters and their values. 

I have already gotten to the point of pulling all my users, and their corresponding filter selections, but getting the values of those filters is eluding me. 

Does anyone have a sample script for pulling the nested fields / values tables from the filters data?

RestConnectionMasterTable:
SQL SELECT
"__KEY_data",
(SELECT
	"id" ,
	"name",
    "description",
    "enabled",
    "appId",
    "connectionId"
FROM "items" FK "__FK_items")
FROM JSON (wrap off) "data" PK "__KEY_data"
WITH CONNECTION( URL "https://qlik-nprint.mycompany.cloud:4993/api/v1/filters", HTTPHEADER "cookie" "$(vCookie)",QUERY "Limit" "10000") );


NPrint_Filters:
NoConcatenate LOAD 
*
RESIDENT RestConnectionMasterTable;
drop table RestConnectionMasterTable;

Hi all,

I need some help with creating a security rule or changing an existing security rule.
Somehow, all professional users can edit the public sheets in our published apps.
All our public sheets have been approved, so in order to prevent (accidental) edits we require professional users to only be able to edit their own and community sheets.

Furthermore, they should also be able to copy public sheets.

Can anyone help me with the security rule that complies with these requirements?

With kind regards,

Martijn

Hello,

I am analysing new customers brought in to the company for a specific product range.

The goal is to determine which sales person made the 1st sale within the criteria and give him/her 1 point per new customer. 

Dimensions: Product type, Customer, Salesperson

Range: Current Month/Year vs Previous Month/Year

Lets say we have 3 different product types.

If the customer did not buy anything last year within these product types, but bought it this year, then give +1 to the sales person who made the 1st sale this year. 

My current issue is correctly assigning the point to the salesperson with the first sale.

Code example below for MTD:

Aggr(Sum({$<Year={"$(=Max(Year))"}
,Month={"$(=Only(Month))"},[Product_Type]={'Heater'}
,ProductDriver={'=Sum({$<Year={"$(=Max(Year))"},Month={"$(=Only(Month))"}>}
Aggr(Sum({$<Year={"$(=Max(Year))"},Month={"$(=Only(Month))"}>} InvoiceValue_),ProductDriver))>0'}
,Customer_KEY = E({<Year={'$(=Max(Year))-1'},Month={"$(=Only(Month))"}
,[Product_Type]={'Heater'}
,ProductDriver={'=Sum({$<Year={"$(=Max(Year))-1"},Month={"$(=Only(Month))"}>}
Aggr(Sum({$<Year={"$(=Max(Year))-1"},Month={"$(=Only(Month))"}>} InvoiceValue_),ProductDriver))>0'}>} Customer_KEY)
>}Customer_Count),Customer_KEY,[Doc Created By])

Attached current result vs expected.