Custom Color Gradient in Treemap

[elizabeth__]

Hello all,

I have a treemap that I want to add a (measure-based) color gradient to beside the Qlik ones of orange and blue. I want it to be red for larger measure values and green for lower measure values. Is there a way to achieve this with an expression?

Thanks

[santho_ak]

Attached screenshot for your reference. Write custom expression based on your requirement.

[Channa · Accepted solution]

try 

colormax1

sample

ColorMix1 ((1+Sign(2*(rangemin(5000000,rangemax(sum(CUSTOMS_VALUE_QAR),1000))-1000)/(5000000-1000)-1)*Sqrt(Fabs((2*(rangemin(5000000,rangemax(sum(CUSTOMS_VALUE_QAR),1000))-1000)/(5000000-1000)-1))))/2, ARGB(255, 19, 236, 160), ARGB(255, 35, 75, 1))

measure:CUSTOMS_VALUE_QAR

highvalue:5000000

lowvalue;1000

[AdityaAgarwal]

I am getting the error "Nested aggregation not allowed" Can someone help me?

=ColorMix1 ((1+Sign(2*(rangemin(250000,rangemax(sum(($(v_SalesFST)/ $(v_SalesFST_Comp) ) -1),185000))-185000)/(250000-185000)-1)*Sqrt(Fabs((2*(rangemin(250000,rangemax(sum(($(v_SalesFST)/ $(v_SalesFST_Comp) ) -1),185000))-185000)/(250000-185000)-1))))/2, ARGB(255, 19, 236, 160), ARGB(255, 35, 75, 1))

high value_250000
LowValue_185000