topic Re: Calculated Dimension in Qlik sense Creating Problem In Nprinting HTML Report in Qlik NPrinting

Calculated Dimension in Qlik sense Creating Problem In Nprinting HTML Report

joshibabu_are — Sat, 03 Mar 2018 21:54:30 GMT

Hi Guru's,

My Task is to design NPrinting HTML Report using Qlik sense Table object

I have data for Business Unit,Country,location wise Headcount data.

BU wise ITA (ITALY) has more Number of Employees

Country wise USA has More number of Employees

So i want to display BU wise headcount top to Bottom.i achieved this with Calculated Dimension which is in attached QVF File.

After achieving Desired Sort Order i am Taking this into Nprinting 17 to create HTML Report.

,here the issue is table showing correct result but country column only showing in grey background. as attached.

how to remove grey back ground in HTML Report or How to push calculated Dimension into Script Level.

Please Find the attached Qvf File and Grey background Country field snap shot.

Thanks in advance.any help would be greatly appreciated.

Joshi !

Re: Calculated Dimension in Qlik sense Creating Problem In Nprinting HTML Report

sebastiandperei — Sun, 04 Mar 2018 00:10:24 GMT

Hi, i have answered this in the other post you have writed.

1- The second dimmention should be just "Country"

2- Go to Sorting tab, select "BU" field, check "By expression" and type Sum([Actual head count])

Re: Calculated Dimension in Qlik sense Creating Problem In Nprinting HTML Report

Ruggero_Piccoli — Mon, 05 Mar 2018 09:52:35 GMT

Could you share the HTML template?

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.