topic Re: Two different label for single expression based on dimension value ? Is this possible ? in QlikView

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

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

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 .

Thanks & Regards

Shekar

its_anandrjs — Sun, 08 Oct 2017 07:27:44 GMT

Check the attached is that you are looking for.

pradosh_thakur — Sun, 08 Oct 2017 08:02:05 GMT

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

shekhar_analyti — Tue, 10 Oct 2017 07:31:52 GMT

can you share qvw ?

pradosh_thakur — Tue, 10 Oct 2017 07:44:58 GMT

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

shekhar_analyti — Tue, 10 Oct 2017 07:58:11 GMT

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 — Tue, 10 Oct 2017 08:57:37 GMT

Hi shekhar

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

regards

Pradosh