Colors are not reflecting with Year in Cyclic drill down for YoY comparison

[kvr9]

Hi Experts,

Need your help in solving an issue.

Requirement:

I need a YoY graph, along with Category and Product in one chart. So used a cyclic flip option for Category and Product .

Also defined color codes for them.

Below is the Issue:

I used max(year) for current Year and Max(Year)-1 for Previous Year  in expression, when nothing is selected in year it is working as expected . But when we select the year then the defined color codes are reflecting for selected year(Max (Year)) only and not for previous Year.

Could some one help me in resolving the issue.

Attached is the source data and sample qvw.

Thank you in advance.

[sunny_talwar]

Change your vColor variable to this

if(GetCurrentField([cgNew])='Category',pick(Match(Only({1} Category), 'A', 'B', 'C','D' ),RGB(187,216,84),RGB(255,217,47),RGB(82,145,221),RGB(252,171,59)),

pick(Match(Only({1} Product), 'YY', 'ZZ', 'TT','RR' ),RGB(252,171,59),RGB(187,216,84),RGB(255,217,47),RGB(82,145,221)))

[kvr9]

Hi Sunny,

Thank you.

It is working perfectly for one if condition/cyclic flip. what about multiple if condition with two cyclic options.

[sunny_talwar]

Would you be able clarify this using another sample? or is this something which is available in the yoy.qvw attached above?

[kvr9]

it is not available but trying to use some extra dimensions such as Sub category and Sub product as another cyclic flip

[sunny_talwar]

I won't know what exactly you are referring to unless you show me an example

[kvr9]

Please find the qvw. The issue is with Cyclic flips and explained in the qvw

[sunny_talwar]

Are you talking about this in the chart or the list box? I am not sure I understand this?

[kvr9]

The color in the chart should reflect based on the list box selection

[kvr9]

Hi Sunny,

Please find the latest qvw.

Request you to look into it.