I wanted to mention that this is confusing to see references to before and after NPrinting 16 and 17 in the May 2021 NPrinting qlik help page.  I started with Qlik NPrinting Feb 2020 and now we are at June 2020 SR1 looking to move to May 2021.  

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Introduction/Version-differences.htm

The am in the link for May 2021 help and when it says comparing features of 17 and newer with 16. Per the release notes May 2021 is version 21+  (May 2021 Technical Preview (21.14.1))  what is the significance of dividing 17 and newer with 16 and older?

I am using NPrinting with Qlik Sense - It would be nice to have some new updated videos to watch around the topics of Conditions, Filters with variables (see below snap) rather than fields defined and when to use evaluate, image sizing specific to qlik sense and other than excel examples (most of my business users want ppt/pdf) - I have read the help on image sizing and it is still confusing.  Also business users want to see totals -- you cannot get totals on a native table to ppt and that leaves images and then we are back to the sizing dilemma.  

I would like a good example for variable created under the filters tab.  And when to check the evaluate box - what the difference is.  

Thank you.

Hello, I would like to filter out this data by year using the set expression below. However, when I add year to the set analysis, it returns a value of zero. 

Here is the set analysis as it stands. This correctly generates numerical values. 

count(distinct(if([CONTRIB_CODE-CONTRIB_CODE1]='07' or [CONTRIB_CODE-CONTRIB_CODE1]='19' or[CONTRIB_CODE-CONTRIB_CODE1]='60.88'
or CONTRIB_CODE2= '07' or CONTRIB_CODE2='19' or CONTRIB_CODE2='60.88' or CONTRIB_CODE3='07'or CONTRIB_CODE3= '19' or CONTRIB_CODE3='60.88'
or DISTRACTED_BY_CODE='01' or DISTRACTED_BY_CODE='02' or DISTRACTED_BY_CODE= '03' or DISTRACTED_BY_CODE= '04' or DISTRACTED_BY_CODE= '05' or
DISTRACTED_BY_CODE='06'or DISTRACTED_BY_CODE= '07' or DISTRACTED_BY_CODE= '09' or DISTRACTED_BY_CODE='10'
or DISTRACTED_BY_CODE= '12' or DISTRACTED_BY_CODE='13' or DISTRACTED_BY_CODE='14' or DISTRACTED_BY_CODE='15'
or DISTRACTED_BY_CODE='16'or DISTRACTED_BY_CODE= '88' or DISTRACTED_BY_CODE='18'or DISTRACTED_BY_CODE= '17',OVERALL_REPORT_NO)))

Here is the set analysis where I attempted to further filter the data by date. It consistently returns 0 as a value. When I use the set analysis as a measure and year as a dimension however, it returns values for 2015. So I know that the answer is not actually 0. 

count(distinct(if([ACC_DATE.autoCalendar.Year]='2015',[ACC_DATE.autoCalendar.Year] and(if([CONTRIB_CODE-CONTRIB_CODE1]='07' or [CONTRIB_CODE-CONTRIB_CODE1]='19' or[CONTRIB_CODE-CONTRIB_CODE1]='60.88'
or CONTRIB_CODE2= '07' or CONTRIB_CODE2='19' or CONTRIB_CODE2='60.88' or CONTRIB_CODE3='07'or CONTRIB_CODE3= '19' or CONTRIB_CODE3='60.88'
or DISTRACTED_BY_CODE='01' or DISTRACTED_BY_CODE='02' or DISTRACTED_BY_CODE= '03' or DISTRACTED_BY_CODE= '04' or DISTRACTED_BY_CODE= '05' or
DISTRACTED_BY_CODE='06'or DISTRACTED_BY_CODE= '07' or DISTRACTED_BY_CODE= '09' or DISTRACTED_BY_CODE='10'
or DISTRACTED_BY_CODE= '12' or DISTRACTED_BY_CODE='13' or DISTRACTED_BY_CODE='14' or DISTRACTED_BY_CODE='15'
or DISTRACTED_BY_CODE='16'or DISTRACTED_BY_CODE= '88' or DISTRACTED_BY_CODE='18'or DISTRACTED_BY_CODE= '17',OVERALL_REPORT_NO)))))

If anybody can provide any insight on how to solve this I would greatly appreciate it!

In addition, I am new to QLIK and largely self taught so new information or pointers are always welcome!

We are using NPrinting June 2020 SR1 with NPrinting Designer Client June 2020 SR1.   (you can see in the launch below)

When user tries to edit a template, he gets this error trying to launch the Designer Client

@Lech_Miszkiewicz  @Frank_S 

Hi to everyone!

I am struggling to understand how to use filters in Qlik NPrinting,

in particular Advanced Research and Evaluate Value.

For example if I want a range of period for a string field, let's say : YearMonth,

I tried to write these expressions  using Advanced Research:

=Num#(left(YearMonth,4))<=2015

or

=Num#(left(YearMonth,4))<=2017 and Num#(left(YearMonth,4))>=2012

But them didn't work.

Could you someone help me, for that specific question and give me general advices to use  Advanced Research and Evaluate Value. 

I already read the official manual, and saw some videos tutorial.

Thanks a lot!

Hello,

System: Qlik Sense Enterprise Cloud 4/2020

Over the last year we developed a robust framework around Qlik for our clients.  However one issue remains due to our industry and data security.  We have a couple of scripts that are loaded as includes that pertain to data security access.  I can find no way to secure them from a developer and/or sponsor(we allow clients to develop apps).

We secure data at both the database levels and application-section access.  

There are two issues:

(1) Anyone can simply comment out the lines (in DLE) and our security is non-existent. While there are some protections in that we have hooks to certain objects that won't work right without them and/or database roles that block data manager row level access, etc., it's not enough.

(2) The debugger loads the scripts and walks through each line.  This scripts are tested and placed in secure paths on servers with hidden(can't see through folder connection that way or access through the other debug tool).  But I cannot stop the debugger in DLE from walking through each line of these scripts.

I've tried to review most all Qlik API's, REST, SDK's, etc. and I can see no real way to do this.  I've also tried OS level file permissions.

The primary is to block the debugger from showing the script or block the include from being debugged.

The secondary would be to lock sections that would just have our one include line from being accessed and/or deleted, ie protected.

The final issue we don't want anyone accessing code they can copy and debug and reveal security details which the above achieves.

What are the possibilities?  

This is now a security issue as we have upcoming FISMA audits and we could potentially expose data to unauthorized personnel in a clinical setting.  

Thanks

Hi guys, 

How to re render visualizations when api call is done without resizing and clicking ?

Nothing is working:

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Promise

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-render-Export-to-Image-after-getData-has-finished/m-p/1263168

Paint render only when some click on sheet

Hi all,

I have a table which consists of 2 expressions Actual Cost and Revenue.

Issue is Actual Cost value appears correctly only when date field Project Start Month is used as dimension while Revenue value appears correctly when CALDATE is used as dimension.

I want to show both expressions in a single table but both should work as per their respective date field.

I cannot use both the dimensions together.

Is there way to show correct values in above situation in a single table only?

Hello All,

I have created several custom themes to use in Qlik Sense but the themes are not working as desired.
I'm using "_inherit: false" in 2 of 3 of the custom themes but I'm having the same issues with all of the themes.
The custom theme will not load with existing objects in a sheet without manually refreshing each object.
The background color of the entire sheet will update but no other graphs/objects on the page will change.
There are times where adding another object to the sheet will "refresh" the other objects and the theme will be applied.
Other times entering "Edit Sheet" and then changing the theme will allow the theme to update.
It is often that these methods do not work.
Another user attempted to use the custom themes and experienced the same issues.

The JSON & CSS file appear to be written & working correctly because the appropriate changes are shown when the theme does load.

Is there anyway to ensure the theme will load properly every time it is selected ?

I have attached the JSON file below. 

Thanks!