9 Replies Latest reply: Sep 24, 2013 1:19 PM by Johan Lindell RSS

    Percentages not correct when using subfields

      Hi there,

       

      I've been trying to solve this for a while but with no luck.

      I have made an example (attached) of using a subfield.

       

      In the example - each 'ID' is a person, who has been able to select up to 3 favurite colours.

       

      The problem is that the percentages on the graph work out the % using total entries in the subfield DIVIDED BY the current selection.

      I.e.If you mose over Green you'll see it says 22% and we can see that of our 11 people, 6 have selected Green, so it should be over 50%

      Is there any way that I can make Qlikview show the percentage of People who selected that Colour?

       

      Any help would be really appreciated,

      Thanks,

      Andrew