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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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