Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have created a set expression for table object in Qlik sense. The same object when i am tried to generate the report in ##Nprinting , it is not getting generated.
Set Expression used is : only(
{<[Delivery Service Code]={$(=$(vSupportingServices))}>}
[Supplier Function])
variable used vsupportingservices : concat(distinct(chr(39)&[Supporting Services]&chr(39)),',')
Please assist in priority.
Please provide more detail as to where you are using the described syntax. Is it as:
Also
Lots of folks here will be able to advise...
Kind regards...
How do you define in NPrinting what is selected in [Supporting Services] field?
Also are you sure that your Qlik Sense application meets all requirements:
cheers
Lech
Frank,
I have tried this as calculated dimension at first, since the object havent got captured in Nprint development, I have applied same as calculated measure, then object got captured and placed in the template as required.
The error which i got then is "cycle expansion produces empty filter".
I have even tried this as text object, the result remains same.
The Field Supporting services is derived from another field DS ,with the above set analysis in Qlik app. To put in other words, supporting services are part of DS and present in same column labelled DS. then we derive it.
I am using DS as level for report generation. So when i dragged in above expression as calculated measure, Nprint gives "cycle expansion produces empty filter" error.
Could the set analysis i have written be taken into load script (need to write a logic) as an alternative way.?
Hi,
Lets get naming convention straight:
only({<[Delivery Service Code]={$(=$(vSupportingServices))}>}[Supplier Function])
The above expression in Qlik Sense can only be in:
now the question is how you define field DS you are using in LEVEL?
Since it is level I would assume it is not calculation (calculated dimension), but simple field loaded in script.
Otherwise as per documentation it will not work, right? https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Qlik-objects...
The DS field is nothing but Delivery Service code. it is a straight field, that i am using as level.
ok then... so lets start over..
Since you are talking about level I am assuming you are using a excel template.
In that excel template you have Level based on DS field. DS field in Level meant to loop through and I guess your Idea isto be able for each value derive [Delivery Service Code] based on function.
So in theory it should work, but I guess there are other things which we dont see like:
<DS_Level>
<Table> where measure is using set expression:only({<[Delivery Service Code]={$(=$(vSupportingServices))}>}[Supplier Function])
<DS_LEVEL>
To be 100% honest I am little bit lost with what you are trying to achieve and I am also 100% sure that there are easier ways of doing it. This however is little bit like rabbit hole. We are focusing on your approach and not the best approach we can provide to deliver solution.
I would suggest you start over by describing in details (including detaileds screenshots) each step:
in other words provide us with the steps to replicate your issue...
in this question you can find a sample on how to ask question with all steps required to replicate issue: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Chart-Legend-containing-Date-has-different-...
Btw: what is your Qlik Sense exact version?
cheers