Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've noticed "interesting" text formatting issue on Text Object in Sense (2.1.1).
I have small table with strings that contain underscore character ('_'):
Flex_MI_Vars_Table:
load * inline [
Display_Name, Variable_Visits, Variable_Compare_Visits
Postal, tr_same_store_postal_code_visits, tr_same_store_postal_code_compare_visits
Region, tr_same_store_region_visits, tr_same_store_region_compare_visits
Market, tr_same_store_market_visits, tr_same_store_market_compare_visits
];
Everything works fine if I display these records in Pivot, Standard Table or KPI Objects:
When the same string is displayed in standard Text / Image object, these strings are not displayed properly:
1. The underscore symbol is missing and the substring after that is formatted with "Italian" font style
2. And looks like this "text formatting" is really depends on the following and preceding text for these strings
The "Market String = ..." measure's code is identical for both samples above.
'Market String = ' & Maxstring({<Display_Name = {'Market'}>}Variable_Visits) & chr(10) &
'Postal String = ' & Maxstring({<Display_Name = {'Postal'}>}Variable_Visits) & chr(10) &
'Region String = ' & Maxstring({<Display_Name = {'Region'}>}Variable_Visits) & chr(10) & chr(10) &
But text box displays it differently!
So it looks like the ('_') character works as some kind of Text Formatting symbol (which I was told not yet available in Qlik!)....
I would appreciate some clarification or suggestions how to handle this case...
Best regards,
Vladimir
