topic Problem with Count in QlikView

Problem with Count

Mon, 06 Jun 2011 12:43:23 GMT

Dears,

I'm using an expression to count how many times the word "Alto" appears in my collumn "H1".
For this, I'm using the follow expression:

=Alta: ' & round(Count({$<[H1] = {'Alto'}>} [H1])/count(Company) * 100,0.01) & ' %'

And it's working perfectly,

But when I try to do the same thing, in order to count how many times the word "Alto" appears in the collumn "H2" it is working wrong.

The expression that I'm using is:

=Alta: ' & round(Count({$<[H2] = {'Alto'}>} [H2])/count(Company) * 100,0.01) & ' %'

The value of (Count({$<[H2] = {'Alto'}>} [H2])) is supposed to be 19, but It's giving me the result of 9. and the same thing is happening with the collumn H3.

Insted of show me the value of 13 in the collumn H3, it is showing me the value og 9, exactly the same as the H2.
What is going on?

Can you help me?

Thanks for your attention,

Best regards

Problem with Count

pat_agen — Mon, 06 Jun 2011 12:58:42 GMT

hi,

maybe you have something selected in your document which is causing this.

The dollar sign $ that you have as the first sign in your set identifier is telling qlikview to apply the current selections. remove this and see if your results are different.

Problem with Count

patricio — Mon, 06 Jun 2011 13:24:06 GMT

You can use the following expression with H1= and H2= .

This way your count in H2 is not depending in your H1 and H3 selections:

round(Count({$<[H2] = {'Alto'}, H1=, H3=>} [H2]))