Formatting Change when Report is previewed

[Aditya_Chitale]

Hi All,

I have an excel Nprinting template which when previewed the number values get converted into text. I saw some community articles where it is suggested to change column format to 'number' in Qlik Sense itself.

But the catch is, in that column not all numbers are in number format. Some are percentage values with '%'  symbol, some are time values in mm:ss format. So I need to keep the column format to measure expression or Auto.

I have removed the keep source format option. Is there any way to eliminate the formatting conversion after previewing the report ?

@Lech_Miszkiewicz 

Regards,

Aditya

[Lech_Miszkiewicz]

Hi @Aditya_Chitale 

Well here are my points:

1. Since you dont want to "Keep Source format" you need to take into account that excel format "may" get applied
2. To avoid this you may want to consider one of following things:
   1. make sure you are converting measure to text in Qlik Sense by wrapping whole expression in Text() function
   2. Make sure you also format column as text in your excel template
   3. I have not tested this but you may want to try and add to your Qlik Sense expression single quote character like this one ' - this is so when exported to excel it is interpreted as text. You can do that in your custom num() function or just by appending it as text
3. The way I would tackle it though would be by exposing a value/character in another column with say values: T (for time format) P (for percentage format) etc... and using conditional formatting to format those values using excel capabilities:
4.  

There are many ways you can deal with this - but it all depends on your template requirements and amount of prep you are willing to do.

cheers

[Aditya_Chitale]

Hi @Lech_Miszkiewicz

Thanks for the reply. But converting the measure column to text on both sides (Sense & Nprinting) didn't solve the problem. Previewing the report still shows formatting error.

As for adding the ' sign solution, I cannot implement it because the user makes further calculations on his side after receiving the report from Nprinting so it will be a tedious task for him to remove the sign.

Regards,

Aditya

[Lech_Miszkiewicz]

Hi @Aditya_Chitale 

well, if you want those values to be still stored as actual numbers/values (not text) then that is completely different requirement than in your initial post and the only way to retain formatting is to use excel based conditional formatting which I explained as last option in my previous post. 

cheers