topic Re: Cells Format of a Expression in QlikView

Cells Format of a Expression

Anonymous — Tue, 19 Apr 2016 09:06:16 GMT

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.

Re: Cells Format of a Expression

sunny_talwar — Tue, 19 Apr 2016 09:07:47 GMT

An if statement like this should work:

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

Re: Cells Format of a Expression

MK_QSL — Tue, 19 Apr 2016 09:08:32 GMT

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

Re: Cells Format of a Expression

Chanty4u — Tue, 19 Apr 2016 09:09:07 GMT

did u try custom format cell ?

Re: Cells Format of a Expression

Anonymous — Tue, 19 Apr 2016 09:10:33 GMT

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

Re: Cells Format of a Expression

Anonymous — Tue, 19 Apr 2016 09:26:59 GMT

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

Re: Cells Format of a Expression

sunny_talwar — Tue, 19 Apr 2016 09:29:13 GMT

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.

Re: Cells Format of a Expression

Chanty4u — Tue, 19 Apr 2016 09:29:59 GMT

chk here

How to use - Dimensionality()

Re: Cells Format of a Expression

tamilarasu — Tue, 19 Apr 2016 09:31:43 GMT

You can try below background expression.

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

Re: Cells Format of a Expression

kkkumar82 — Tue, 19 Apr 2016 09:44:39 GMT

Hi Sebastian,

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

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

which changes the background to white

Re: Cells Format of a Expression

awhitfield — Tue, 19 Apr 2016 11:00:22 GMT

Hi Sebastien,

I presume that you mean like this:

If so, change the text colour against the expressions, e.g. :

if(INDICATORS = 'Own costs', lightblue(), black())

Just substitute the colours that you require.

HTH Andy

Re: Cells Format of a Expression

Anonymous — Tue, 19 Apr 2016 11:16:43 GMT

I think you can try custom format cell

Re: Cells Format of a Expression

Mahamed_Qlik — Tue, 19 Apr 2016 12:04:08 GMT

Hi Sebastien,

Did you tried dragging the cell Own cost?

If not then you can do it in following ways:

- Take the mouse cursor to the cell Own cost.

- click and hold and drag next to the Total column.

Try and let me know, this is what you are looking for.

Regards,

Mahamed

Re: Cells Format of a Expression

Anonymous — Tue, 19 Apr 2016 13:19:29 GMT

Thanks i will check this

Re: Cells Format of a Expression

Mahamed_Qlik — Wed, 20 Apr 2016 12:30:46 GMT

If your issue resolved then mark it as correct answer and close the trail.

-Mahamed

Re: Cells Format of a Expression

Mahamed_Qlik — Thu, 21 Apr 2016 08:19:44 GMT

Hi Sebastien,

If your issue has been resolved then I will really appricate, if you can marke answer as correct and close the trail.

Have a nice day!!!

Regards,

Mahamed

Re: Cells Format of a Expression

Anonymous — Thu, 21 Apr 2016 08:24:46 GMT

Hello,

I am sorry but how i can close the trail ?

Thanks in advance for your return

Sebastien.

Re: Cells Format of a Expression

Mahamed_Qlik — Thu, 21 Apr 2016 08:37:26 GMT

Hi Sebastien,

Below link will help you for your question

Re: how to close an answered thread ?

Regards,

Mahamed