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.

[antoniodneto]

Sunny,

Im my table I have some rows each one with you specific expression to calc.

I would like to colour the highers in red, medium yellow and lowers green, creating a gradient.

How I could do that?

Ths a lot for your help!!!

[sunny_talwar]

Would you be able to provide the expected output in a Excel file? Meaning color the cells that needs to be colored in Excel

[antoniodneto]

Sunny

I want something like my Excel.

You want the file, or picture is enough to understand?

Tks

[sunny_talwar]

You are basically looking for a heatmap, right? Try to see if this link helps

Heat Map – Qlik Freak

[antoniodneto]

Hi, yeah is it!

But I use Qlik Sense, the example is using the ColorMix Wizard in Qlik View.

Tks

[sunny_talwar]

Do you have a non-licensed version of QlikView on your machine? You can recreate the expression in QlikView and copy paste it into Qlik Sense... or you can create the function on your own... check here

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/ColorFunctions...

[antoniodneto]

So, I Have the expression in Qlik View, but does not work still all white.

[antoniodneto]

Sunny,

Could you help me please?

Tks a lot!!