Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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