Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
kvr9
Creator
Creator

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

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.

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

27 Replies
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
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

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

kvr9
Creator
Creator
Author

Hi Sunny,

Please find the latest qvw.

Request you to look into it.