topic Re: Nprinting 17.6 Excel Expand Range Issue in Qlik NPrinting

Nprinting 17.6 Excel Expand Range Issue

grs_venki — Mon, 26 Mar 2018 13:21:36 GMT

Hi Team,

Currently I am using Nprinting 17.6 with November 2017 release, I have a problem with my excel template where I have been using Expand Range (Unchecked). But in my previous Nprinting 16.6 version which was working fine. But recently we have been migrated from 16.6 to 17.6 and I have been encountering the issue with expand range. As its not working as expected. Even if I am checked or unchecked the option from designer property as unchecked still I have a same problem. Could you please advise is there any solution for this issue ?

Qlik NPrinting November 2017 Version: 17.6.0000.0 - Microsoft Excel 2013 - Qlikview 12

Thanks

Venki

Re: Nprinting 17.6 Excel Expand Range Issue

Chanty4u — Mon, 26 Mar 2018 13:34:32 GMT

did you tried with unchecking of Keep source format and preview?

Re: Nprinting 17.6 Excel Expand Range Issue

grs_venki — Mon, 26 Mar 2018 13:44:43 GMT

Yes, tried both options. But no luck so far.

Re: Nprinting 17.6 Excel Expand Range Issue

Lech_Miszkiewicz — Mon, 26 Mar 2018 22:18:58 GMT

Please also check if Expand range checkbox is unticked in particular field properties. Do you uncheck it in a table properties or field properties?

regards

Lech

Re: Nprinting 17.6 Excel Expand Range Issue

grs_venki — Tue, 27 Mar 2018 03:34:31 GMT

Hi, I have tried all the way to achieve this Expand Range. But so far I haven't got an idea to fix it. I did checked in Qlikview property as well. but I didn't find the way.

If you look at my screenshot I had unchecked expand range in specific to object in Nprinting designer 17.6. But its not working. I did tried the same in 16.6 which is working fine. I did checked Excel setting as well. All my homework done.

Let me know is there any way to fix it.

Re: Nprinting 17.6 Excel Expand Range Issue

Lech_Miszkiewicz — Tue, 27 Mar 2018 03:53:21 GMT

Yes - I agree that you have shown on your screenshot that you have this unchecked it on TABLE level. What i was asking is particular field level like: Datapoint or If(Table11='Analy.....etc"

Now please select the column from the table in NPrinitng designer (for example Datapoint) and see if the "Expand Range property is disabled there as well. If it is then i would try to achieve the same with different apporach which leads to my point below:

My question is - can you use different solution? Instead of hardcoding values 1.2.3.4.... etc in Static Value column maybe all table can come from Qlik?

regards

Lech

Re: Nprinting 17.6 Excel Expand Range Issue

grs_venki — Tue, 27 Mar 2018 04:41:36 GMT

Yes, I agree with your point. We can achieve this way in Qlikview level and can be used in Nprinting. However I have already designed the excel template around 50 sheets and currently its in PROD. If we are going with this approach, then I have to rebuild Qlik apps and Nprinting template to meet my requirement. moreover we have many project which is running with same functionality used across template, Also, we have huge impact if this functionality doesn't work out. My question why this functionality is not working in 17.6 ?

Also, I remember Expand Range option will be available in Object level and not to specific to field property.

Already, we were facing multiple issue like (Import/ Export) is not working from 16.6 to 17.6. Only template objects are being exported and again we have to mirror all the objects, Image, Formula, variables, level etc. After the upgrade we were unable to meet our old requirement.

Re: Nprinting 17.6 Excel Expand Range Issue

Lech_Miszkiewicz — Tue, 27 Mar 2018 05:13:22 GMT

Well,

first and foremost NPrinitng 16 and NPrinitng 17 are 2 completly different products. Please do not assume that version 17 has backward compatibility and supports everything what was in version 16. This is very similar to QlikView and Qlik Sense. Both are doing pretty much the same thing, but they are completly different products!

If you look at help document at this page you will see there a table with function comparison between those 2 versions.

https://help.qlik.com/en-US/nprinting/February2018/Content/Introduction/Introduction.htm

There are certain differences which will limit migration functionality. If one of the reports/templates is using unsupported functionality you will not be able to migrate a report. This can mean linked fields, macros, variable filter etc..

Regarding your issue - i will test it in my environment and will get back to you with the behaviour i am experiencing.

regards

Lech

Re: Nprinting 17.6 Excel Expand Range Issue

Lech_Miszkiewicz — Tue, 27 Mar 2018 11:48:30 GMT

Hi,

mate - i have checked this in my system and it works as it should. I am using NPrinitng February 2018 and i get what you called "expected output" in your first screenshot.

If this does not work for you, you have something seriously wrong there.

cheers

Lech

Re: Nprinting 17.6 Excel Expand Range Issue

grs_venki — Tue, 27 Mar 2018 12:22:18 GMT

Hi,

I am using this version Qlik NPrinting November 2017 Version: 17.6.0000.0.

I guess Expand Range is working in latest version of Nprinting February 2018. But here I am using Nprinting 17.6 November 2017 version.

Re: Nprinting 17.6 Excel Expand Range Issue

grs_venki — Tue, 27 Mar 2018 12:24:58 GMT

Does it means that we need to upgrade latest version of Nprinting 17.6 February 2018 ? We cannot make use of our Nprinting 17.6 November 2017 version ?

Re: Nprinting 17.6 Excel Expand Range Issue

grs_venki — Tue, 27 Mar 2018 12:26:39 GMT

Does it means that we need to upgrade latest version of Nprinting 17.6 February 2018 ? We cannot make use of our Nprinting 17.6 November 2017 version ?

Re: Nprinting 17.6 Excel Expand Range Issue

Lech_Miszkiewicz — Tue, 27 Mar 2018 13:13:44 GMT

You can give it a try, else you can log a support case with Qlik support!

Re: Nprinting 17.6 Excel Expand Range Issue

Lech_Miszkiewicz — Tue, 27 Mar 2018 13:16:01 GMT

From the memory i did not have issues with NPrinitng 17.6 and expand range, so i do not think it was a bug.

Did you try to build completly new report (from scratch in NPrinting 17.6 and use unchecked expand range functionality?

I am quessing you may have some legacy staff there in your report template which is causing issues

Re: Nprinting 17.6 Excel Expand Range Issue

grs_venki — Tue, 27 Mar 2018 13:27:06 GMT

No. I had worked around all my homework. I tried building a new template by using one single object option to Expand Range (Checked and Unchecked), but no luck. Also, I did used my old template by checking that option. I have done all the possibilities which I tried from my end. Even I do have full permission to machine.

Here I totally confused as what is the problem.

Re: Nprinting 17.6 Excel Expand Range Issue

grs_venki — Tue, 27 Mar 2018 13:27:34 GMT

Yes, I have raised a ticket with Qlik on the same.