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]

When I select country C2, cgNew2 group is already on Product... but you mentioned 'Change listfield (i.e. cgNew2 group) then Product appears

Similarly, when country C3 is selected, cgNew group is arleady on Category.

Are you sure you have not mistyped something in this text box or the one on the top?

[kvr9]

Probably I changed the option while saving the qvw. to hightlight the issue.

Do we have any reset option for list box??

Request you to follow the conditions mentioned in the below text box in

qvw for issue.

[kvr9]

Below is the issue, when I select the year the defined colors are not reflecting for previous year

[sunny_talwar · Accepted solution]

Check attached... changed the variable def. for vCountry

[kvr9]

Excellent Sunny.

Thank you so much.it is working.

It would be great help if you explain , how the condition works.

if(wildmatch(concat({1<Country=p(Country)>}Country),'*c2*')>0

[sunny_talwar]

Ignoring all selections except for selection in Country field.... that is what the set analysis is for

Now if you got what you wanted, I would suggest you to close the thread by marking the correct response and any other helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[kvr9]

Thank you Sunny 🙂

[sunny_talwar]

Please mark the appropriate response as a correct response instead of marking 'Assumed Answer'

Thank you

[antoniodneto]

Hi Sunny! Can you help me with colors in another question?

Tks

[sunny_talwar]

Sure