Cells Format of a Expression

[Anonymous]

Hello,

I am a beginner on QlikView and i want to set a specific format for one of my expression ( here Own Costs which is a value of Indicators field ), because i would like that it looks like as a Total column (such as Total here):

Have you got a idea ? Do i use the Dimensionality function ?

Thanks in advance for your help,

Sébastien.

[sunny_talwar]

An if statement like this should work:

If(INDICATORS = 'Own Costs', FormattingType1, FormattingType2)

[MK_QSL]

Try Num(YourExpression,'#,##0.0')

[Chanty4u]

did u try custom format cell ?

[Anonymous]

Yes, but when i change Forecolor for exemple it changes for all lines of Indicators 😕

[Anonymous]

For example, what will be the formula if i want the same format of the column Total please ?

[sunny_talwar]

Then you would need dimensionality. To check what dimensionality it is, create an expression Dimensionality() and see what number you see. You might need to use SecondaryDimensionality() in addition to the Dimensionality() to get this right.

[Chanty4u · Accepted solution]

chk here

How to use - Dimensionality()

[tamilarasu]

You can try below background expression.

If(INDICATORS='Own Costs' ,RGB(243,243,243))

[kkkumar82]

Hi Sebastian,

I think you can try Sunny's expression in the background of the dimension +

Like

if(If(INDICATORS = 'Own Costs', rgb(255,255,2554)

which changes the background to white