Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

How to Change font and Size of the String in script

Load 'Agnivesh' AS Name  AutoGenerate 1;

I am just writing the string as above i want 'Agnivesh ' should be in Bold and want to change the size , can it be possible in the load statement .

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Load the text formatting specs as an additional field with your data, for example:

Load 'Agnivesh' AS Name, '<B>' AS NameTextFormat AutoGenerate 1;

If you want to display Name values with specific text formatting in tables and such, add the folowing expression to the TextFormat leaf of the Name dimension:

=NameTextFormat

Best,

Peter

View solution in original post

6 Replies
sunny_talwar

I don't think you can do that in the load statement. But I might very well be wrong, but I doubt its possible.

Best,

Sunny

manojkulkarni
Partner - Specialist II
Partner - Specialist II

I don't think it should be possible. Logically why would like to store the size & font of any text, it should matter only while presentation. Don't think even any of database supports this. if you store the content of field in html tag then chances but not sure.

Not applicable

Can you provide a visual output on what you really desire to achieve.

Holding a metadata in a table is a valid approach .However,  what you are providing is not enough to make that assumption.

agni_gold
Specialist III
Specialist III
Author

         P            C
5360950000
5360950000
5360950100
5360950100
5361952000
5361952000
5361952000
5361952100
53619

52100

I want some values bold .

manojkulkarni
Partner - Specialist II
Partner - Specialist II

If you have specific logic to make the values bold or different font color, then you could use expression properties.

Expand expression under Expressions Tab, you can see multiple options.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Load the text formatting specs as an additional field with your data, for example:

Load 'Agnivesh' AS Name, '<B>' AS NameTextFormat AutoGenerate 1;

If you want to display Name values with specific text formatting in tables and such, add the folowing expression to the TextFormat leaf of the Name dimension:

=NameTextFormat

Best,

Peter