Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have a straight table where we are getting color values using colormix formula.
But when we select any one dimension, we want the actual color value of the color expression should be available. when we try to ignore the dimension in the expression, even if we select the dimension, unwanted records are coming.
Any idea on same.
Please assist.
Regards,
MK
I attached the application. Used this expression:
If(sum(Vol) > 0,
ColorMix1 ((1+Sign(2*(sum({<state=>}Vol)-RangeMin (top(total sum({<state=>}Vol),1,NoOfRows(total))))/(RangeMax (top(total sum({<state=>}Vol),1,NoOfRows(total)))-RangeMin (top(total sum({<state=>}Vol),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(sum({<state=>}Vol)-RangeMin (top(total sum({<state=>}Vol),1,NoOfRows(total))))/(RangeMax (top(total sum({<state=>}Vol),1,NoOfRows(total)))-RangeMin (top(total sum({<state=>}Vol),1,NoOfRows(total))))-1))))/2, ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0)))
As soon as you make a selection in State Sum(Vol) becomes 0 and all other rows for colormix become null
HTH
Best,
Sunny
Would you be able to share the application or a sample may be?
Hi,
PFA where there are two straight table in the application.
Now when i select A from state filter, the value of color is changing to null, in one straight table and in other the extra values are coming.
The requirement is i should get the output as ARGB(255,255,0,0) with no extra row, when i select A.
Please assist.
Regards,
MK !
I have added the application.
This?
yes, but how did you get this.
Ok, i got it.
I attached the application. Used this expression:
If(sum(Vol) > 0,
ColorMix1 ((1+Sign(2*(sum({<state=>}Vol)-RangeMin (top(total sum({<state=>}Vol),1,NoOfRows(total))))/(RangeMax (top(total sum({<state=>}Vol),1,NoOfRows(total)))-RangeMin (top(total sum({<state=>}Vol),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(sum({<state=>}Vol)-RangeMin (top(total sum({<state=>}Vol),1,NoOfRows(total))))/(RangeMax (top(total sum({<state=>}Vol),1,NoOfRows(total)))-RangeMin (top(total sum({<state=>}Vol),1,NoOfRows(total))))-1))))/2, ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0)))
As soon as you make a selection in State Sum(Vol) becomes 0 and all other rows for colormix become null
HTH
Best,
Sunny
Awesome
If you got what you wanted would you be able to close this thread by marking the correct answer and/or mark any useful answers.
Best,
Sunny