Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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])
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.