Faded colors in Area line chart Qlik Sense

[ganeshsvm]

Hi Qlikerz,

Is the following Area line chart possible in Qlik Sense with fading colors.

Note: The fading colors in the main requirement.

Thanks in anticipation.

-Ganesh

[Anil_Babu_Samineni]

Can you share how many measures are needed? Will you able to provide sample QVF

[ganeshsvm]

Hi Anil,

Just one Dimension and one measure. I am using sample data only.

Following snap is from Qlik Sense, where we have area line chart wherein we can fill colors but I need faded color as shown in the image of my original post.

Thanks for the reply.

[vishweshwarisun]

Hi,

I think you should use colormix function.

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

[ganeshsvm]

Yes Anil, I tried with Colormix function, but it is like "if...else..." conditional colors and it gives color based on the value in the 1st parameter and mixing of Colors in 2nd & 3rd parameter, but does not provide a faded color.

[vishweshwarisun]

can you share your expression?

[ganeshsvm]

Hi Vishweshwari Sunketa,

Measure : Avg(Age)

Colormix Exp: Colormix1(0.3, Yellow(), White())

[vishweshwarisun]

try this expression may be it will work

ColorMix1( rank(total column(1))/noofrows(TOTAL) ,rgb(255,255,0), rgb(255,255,255))

[ganeshsvm]

Thanks for the reply,

Following is the result using your expression:

But, this is not the expected result. I need something like this below: