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: 
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
Champion III
Champion III

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.