I have e request to make nprint excel report. I developed a table in qliksense with required columns. The excel report should be in particular excel design with headers and boarders. So in order to do it , I unchecked 'Keep sources' for the whole table. But I have issue with one column which has conditional font text coloring. When I do uncheck 'Keep sources' , its color disappears. And if I do 'Keep sources' only for it, it does not have boarders and the text moves to the right. Conditional coloring in excel itself does not suit, as conditional coloring in qlik is based on variables. Please help:)
My workaround is to add extra column to your table which will hold values for your conditional formatting (those can be just numbers like 1,2,3....) and I would then also add this column to your excel template and use its values in excel conditional formatting to apply colour format and in the end hide that column
cheers
Lech
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
The workaround you have recreate the variable in Excel FC either straight or put one table as a reference and then based on the value shown, reference this table to the one you want to show. The first table shall be outside of your Printed area.
My workaround is to add extra column to your table which will hold values for your conditional formatting (those can be just numbers like 1,2,3....) and I would then also add this column to your excel template and use its values in excel conditional formatting to apply colour format and in the end hide that column
cheers
Lech
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
