
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- colouring
- new to qlikview
- new_to_qlikview
- secondary dimension as cyclic group
- year filter
- year to year
- yoy calculations
- « Previous Replies
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check attached... changed the variable def. for vCountry

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny,
Thank you.
It is working perfectly for one if condition/cyclic flip. what about multiple if condition with two cyclic options.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would you be able clarify this using another sample? or is this something which is available in the yoy.qvw attached above?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it is not available but trying to use some extra dimensions such as Sub category and Sub product as another cyclic flip

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I won't know what exactly you are referring to unless you show me an example

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please find the qvw. The issue is with Cyclic flips and explained in the qvw

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are you talking about this in the chart or the list box? I am not sure I understand this?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The color in the chart should reflect based on the list box selection

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny,
Please find the latest qvw.
Request you to look into it.

- « Previous Replies
- Next Replies »