topic Color Expression when expression is set analysis in QlikView

Color Expression when expression is set analysis

supriyabiware — Sat, 16 Nov 2024 19:19:06 GMT

Hello All,

My Chart expression is as below

=Count({1<YearMonth = {"$(=$(vPreviousYearMonth))"},
DEPARTMENT = $:: DEPARTMENT,
SUBDEPARTMENT = $::SUBDEPARTMENT,
ASSIGNMENT_GROUP = $::ASSIGNMENT_GROUP,
PRODUCT_TEAM_SC = $::PRODUCT_TEAM_SC,
AREA = $::AREA>}distinct INCIDENT_ID)

And my color expression is

=if(SERVICE='Advanced Support', $(ColorA1),if(SERVICE='Support',$(ColorA2),if(SERVICE='Others',$(ColorOthers))))

But still somehow when i drill down on chart it doesnt give proper colors at lower level .

Any help??

Regards,

Supriya.

Re: Color Expression when expression is set analysis

agigliotti — Mon, 13 Jan 2020 10:35:49 GMT

what about your chart dimension?

Re: Color Expression when expression is set analysis

supriyabiware — Mon, 13 Jan 2020 10:47:37 GMT

Hi,

Dimension is cyclic dimension (Dept, sub Dept, Assigned Group)

Re: Color Expression when expression is set analysis

agigliotti — Mon, 13 Jan 2020 11:21:07 GMT

could you post the qvw to look in ? otherwise I can't help you find out why.

Re: Color Expression when expression is set analysis

supriyabiware — Mon, 13 Jan 2020 12:48:18 GMT

here goes. i need consistent colors even after selecting any dimensions or filters

Re: Color Expression when expression is set analysis

supriyabiware — Tue, 21 Jan 2020 08:19:33 GMT

if i remove 'One color gradient' option from each color. seems to be working ok.

not sure why the formula mixes all the colors when 'one color gradient' is on.

Re: Color Expression when expression is set analysis

jochem_zw — Tue, 21 Jan 2020 08:42:31 GMT

You Have to add your set analysis from the expression to the background color expression. The current active VW_Service is based on your selection for year etc.

Re: Color Expression when expression is set analysis

Brett_Bleess — Tue, 11 Feb 2020 21:02:01 GMT

Did the last post get you what you needed? If so, do not forget to return to the thread and use the Accept as Solution button on his post to give him credit for the assistance and let other Members know that worked. If you did something different, please consider posting that and then mark it as the solution, and if you still need further help, leave an update for us.

Regards,
Brett