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: 
ashis
Creator III
Creator III

Color of label for calculated dimension

Hi,

Is it possible to change the color of a calculated dimension label (it will render either positive value or negative value) ,

I want red for negative.

my label looks like

='Total'& sum(aggr(sum({<XXX)}>}YYY,ZZZ))

if this value is negative it should show red color in the label. Is that possible

3 Replies
Anil_Babu_Samineni

As far i aware, It's not available in Qlikview using Label format concept. I believe i would think in depth like custom format cell using same in expression of color code?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ashis
Creator III
Creator III
Author

Hi Anil ,

Thank you for your reply. for custom format cell will work for all the dimensions in the pivot table.

My requirement is only for one dimension header.

Anil_Babu_Samineni

No, Nothing implemented till Nov 2017. May be later #Team works.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful