Scaling to 100% : two dimensions / one expression

Fri, 18 Nov 2011 13:16:33 GMT

Hello all,

It sounds easy, however I am not able to find the right solution.

I have go a table who looks like this (simplification):

Time Recognition

7                       YES
7                       YES
7                       YES

7 NO

8 NO

TIME and RECOGNITION are the dimension and ANSWER is the expression =count(Recognition).

What I want to see is the distribution indexed to 100% for EACH moment in TIME (7 and 8).

If I thickbox RELATIVE and adjust the Axe maximum to 1 I get what I show here beneath.

===>

However, That is not what i need. The total for EACH moment in time needs to be 100%, not the combination of the two moments in TIME.

I have been thinking about this all day by now. It drives me crazy.

If you can help me with this, you are my hero.

Kinds regards,

Tim

Fri, 18 Nov 2011 13:50:10 GMT

I found it myself after a good and strong coffee.

Today my hero is me.

=count(Recognition ) / count(TOTAL <Time> Recognition)

topic Scaling to 100% : two dimensions / one expression in QlikView