topic Re: Format Grand Total In Nprinting. in Qlik NPrinting

Format Grand Total In Nprinting.

infosense_devel — Wed, 01 Jun 2016 15:06:43 GMT

Hello,

I have scenario to format Grand Total for excel template.

Want some thing like this,

i have constraint to not use source formatting of Qlikview.(Keep source format).

Also tried with excel conditional formatting but its repeating all the cell.

only need to do formatting to One Row.

Re: Format Grand Total In Nprinting.

Daniel_Jenkins — Wed, 01 Jun 2016 21:17:54 GMT

Hi,

Sample project attached.

Extract to folder C:\Temp\Community\078 or change the paths in the NSQ.

HTH - Daniel.

Re: Format Grand Total In Nprinting.

infosense_devel — Thu, 02 Jun 2016 09:31:10 GMT

Hello,

Appreciated....!

I have gone through this way but I have too many reports and one of report containing many more excel sheets and sheet had too many object go through each every object is time consuming.

Is there any way we can format row coming from Qlikview we can format it??????

Re: Format Grand Total In Nprinting.

Daniel_Jenkins — Thu, 02 Jun 2016 22:30:34 GMT

Hi,

I'm not clear. You say you can't use Keep Source Formats so it has to be formatted in Excel (you tried conditional formatting) but you want the formatting to come from QlikView? So which is it? If you can use Keep Source Formats in your template you can get output like this:

HTH - Daniel.