Discussion Board for collaboration on QlikView Layout & Visualizations.
It sounds easy, however I am not able to find the right solution.
I have go a table who looks like this (simplification):
7 YES7 YES7 YES
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.
I found it myself after a good and strong coffee.
Today my hero is me.
=count(Recognition ) / count(TOTAL <Time> Recognition)