topic Re: Including dimension in QlikView

Including dimension

Anonymous — Thu, 16 Jul 2015 13:18:01 GMT

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,

Re: Including dimension

sunny_talwar — Thu, 16 Jul 2015 13:24:53 GMT

Would you be able to share the application or a sample may be?

Re: Including dimension

Anonymous — Fri, 17 Jul 2015 08:17:22 GMT

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 !

Re: Including dimension

Anonymous — Fri, 17 Jul 2015 08:17:44 GMT

I have added the application.

Re: Including dimension

sunny_talwar — Fri, 17 Jul 2015 10:28:39 GMT

This?

Re: Including dimension

Anonymous — Fri, 17 Jul 2015 10:30:15 GMT

yes, but how did you get this.

Re: Including dimension

Anonymous — Fri, 17 Jul 2015 10:31:52 GMT

Ok, i got it.

Re: Including dimension

sunny_talwar — Fri, 17 Jul 2015 10:32:36 GMT

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

Re: Including dimension

sunny_talwar — Fri, 17 Jul 2015 10:38:41 GMT

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