Chart with count of $Field values

[rwunderlich]

I want to create a straight table with dimension of "$Field" and expression of count() of field named in $Field. Pseudo code for expression would be something like:

=count( ValueOf($Field) )

I've tried:

=count($(='[' & [$Field] & ']'))

but that only works when one $Field value is selected.

Any ideas?

Thanks,

Rob

[#2]

Hi Ralf

In attachment you can see my problem,for decreasing file size I select only first 100 records

So thanks

Hassan

[rbecher]

Thanks. I guess we're hitting a limitation here of maximum expressions per field (Count Expression) or something else. I have no idea at the moment. At least it works if one table is selected..

[marcus_sommer]

I think it's related to some similar to this one: http://community.qlik.com/message/22129#22129

- Marcus

[#5]

Thanks a lot Rolf, that's correct , this situation is better than noting and solve some problem for me .

I want to split my project to some smaller  size of filed count.

[#6]

Hi rbecher,

Thanks for the great answers! How would you be able to count null records in $Field? I suppose it is similar to the blanks answer you gave but can't figure it out.

Thanks!

[rbecher]

Hi Laila,

just use NullCount() as in QVFieldObserver.qvw

- Ralf

[#8]

Oh I missed that! Awesome! Thanks!!!

[zippo_btl]

You can use formula like this to not to hit limitation:

Pick(Match($Field,$(=Concat({1}TOTAL CHR(39)&$Field&CHR(39),','))),
  $(=Concat({1}TOTAL 'count({1}'&$Field&')',','))
  )

[manoj2102]

Ralf, It's an Excellent Solution

[rjyadav94]

 use fieldvaluecount(fieldname)