Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
kvr9
Contributor

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
Highlighted

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

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

View solution in original post

27 Replies
Highlighted

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

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)))

Highlighted
kvr9
Contributor

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

Hi Sunny,

Thank you.

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

Highlighted

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

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

Highlighted
kvr9
Contributor

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

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

Highlighted

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

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

Highlighted
kvr9
Contributor

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

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

Highlighted

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

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

Highlighted
kvr9
Contributor

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

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

Highlighted
kvr9
Contributor

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

Hi Sunny,

Please find the latest qvw.

Request you to look into it.