Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cells Format of a Expression

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):

Capture.PNG

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

Thanks in advance for your help,

Sébastien.

17 Replies
awhitfield
Partner - Champion
Partner - Champion

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

Anonymous
Not applicable
Author

I think  you can try custom format cell

Mahamed_Qlik
Specialist
Specialist

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

Anonymous
Not applicable
Author

Thanks i will check this

Mahamed_Qlik
Specialist
Specialist

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

-Mahamed

Mahamed_Qlik
Specialist
Specialist

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

Anonymous
Not applicable
Author

Hello,

I am sorry but how i can close the trail ?

Thanks in advance for your return

Sebastien.

Mahamed_Qlik
Specialist
Specialist

Hi Sebastien,

Below link will help you for your question

Re: how to close an answered thread ?

Regards,

Mahamed