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: 
qlikplaut
Partner - Contributor III
Partner - Contributor III

Dimension alignment or font change

Hello everyone,

I have a question. I have a straight table with a calculated dimension:

=if([Account number]='I0100000','Gross Revenue',

if([Account number]='I0400000','Net Revenues',

if([Account number]='I0700000','Gross Margin',

if([Account number]='I0800000','Variable logistics cost',

if([Account number]='I0900000','Contribution',

if([Account number]='I2300000','EBIT TDA',

if([Account number]='I3600000','Net Result'

)))))))

Can I bold only 2 of them? Or maybe change the alignment for only 2 of them?

Thank you

6 Replies
sushil353
Master II
Master II

i guess, yes

click on the plus sign of the calculated dimension..

there in the text format.. with the condition try to put '<B>'

for example if you just add ='<B>' there in the text format then your dimension should get bold..

if it happens then put your condition there.

HTH

Sushil

qlikplaut
Partner - Contributor III
Partner - Contributor III
Author

Hello Sushil,

Thank you for your reply. If I put <B> or <i> there is works for every element of the dimension, but I cannot seem to get a condition to work for only 2 of the elements.

If I use the same condition as I do to only limit the dimension to the 7 listed, it does not work, and it's only natural.

Is there a way I can use a condition like

if(dimension='Contribution',<B>) ?

sushil353
Master II
Master II

use <B> inside quotes

'<B>'

qlikplaut
Partner - Contributor III
Partner - Contributor III
Author

Unfortunatelly the quotes will not help with applying this format to only one result from the dimension

sushil353
Master II
Master II

ok.. is it possible for you to share the sample app

qlikplaut
Partner - Contributor III
Partner - Contributor III
Author

Yes, Sushil, I will try to share it first thing in the morning when I get to the server. I guess we will talk then.

Thank you for your help.

Bogdan