topic Re: Dimension alignment or font change in QlikView

Dimension alignment or font change

qlikplaut — Tue, 13 Aug 2013 22:07:53 GMT

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

Re: Dimension alignment or font change

sushil353 — Tue, 13 Aug 2013 22:31:18 GMT

i guess, yes

click on the plus sign of the calculated dimension..

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

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

if it happens then put your condition there.

HTH

Sushil

Re: Dimension alignment or font change

qlikplaut — Tue, 13 Aug 2013 22:40:55 GMT

Hello Sushil,

Thank you for your reply. If I put or 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',) ?

Re: Dimension alignment or font change

sushil353 — Tue, 13 Aug 2013 22:42:23 GMT

use inside quotes

''

Re: Dimension alignment or font change

qlikplaut — Tue, 13 Aug 2013 22:54:01 GMT

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

Re: Dimension alignment or font change

sushil353 — Tue, 13 Aug 2013 22:54:58 GMT

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

Re: Dimension alignment or font change

qlikplaut — Tue, 13 Aug 2013 22:58:49 GMT

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