Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

Two different label for single expression based on dimension value ? Is this possible ?

Hi All ,

Two different label for single expression based on dimension value ? Is this possible ?

I want to give different color for xpect values only for three Months = Jan , Feb , Mar .


Also Only for these Months want to create a separate Legend called ' For ' ,

without using separate expression like sum({<Month={'Jan','Feb','Mar'}>}Expected_Return)  and then renaming it For .

different label for same expression.PNG

Thanks & Regards

Shekar

6 Replies
its_anandrjs

Check the attached is that you are looking for.

pradosh_thakur
Master II
Master II

Hi

1:You can use the colormix option in background color to get different color for the same expression.

2:In place of legend use a text box with background image with colors what you want.

regards

Pradosh

Learning never stops.
shekhar_analyti
Specialist
Specialist
Author

can you share qvw ?

pradosh_thakur
Master II
Master II

Hi

I thought You was satisfied with Anand's answer. Anyways i have done a little modification in his qvw to show the perfect color as legend.

Please find the attached.

edit: I have edited the qvw. Please Check

regards

Pradosh

Learning never stops.
shekhar_analyti
Specialist
Specialist
Author

Hi Anand ,

Actually you have used what i was not looking for .

" Also Only for these Months want to create a separate Legend called ' For ' ,

without using separate expression like sum({<Month={'Jan','Feb','Mar'}>}Expected_Return)  and then renaming it For . "

pradosh_thakur
Master II
Master II

Hi shekhar

pfa and let me know if this is what you are looking for.

regards

Pradosh

Learning never stops.