Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

joshibabu_are
New Contributor

Calculated Dimension in Qlik sense Creating Problem In Nprinting HTML Report

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 !

2 Replies
sebastiandperei
Valued Contributor

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

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])

Employee
Employee

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

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.