Set Analysis

[#1]

I'm having a problem with my Set Analysis. I'm trying to count all fields in a table where the contents = <?> here is my code

sum({<[$Fields]={'<?>'}>} 1)

Can some one point me in the right direction.

Thanks

[MK_QSL]

=COUNT({<FieldName = {'<?>'}>}FieldName)

[#3]

Thanks Manish

But I have tried that already and all it returns is zero

[marcus_sommer]

The count must be over $Field not $Fields - try this:

count({<[$Field]={'<?>'}>} [$Field])

- Marcus

[#5]

Thanks Marcus

Still returns 0.

[marcus_sommer]

Than you has no field with <?> and you need another search-string, for example {'*gruppe'} or {"*gruppe"} worked for me.

- Marcus

[Gysbert_Wassenaar]

My guess is that he wants something else. Perhaps one of the two calculations from the attached qvw (from the Silly Tricks Department).

[#8]

Your on the right line but I need to count how many <?> I have in each row for example in F2 there is 3. Not sure if Qlikview can do this.

[Anonymous]

Hi,

I have updated the report posted by Gysbert.

Hope this helps!

Regards,

Laxmi

[Gysbert_Wassenaar · Accepted solution]

Ok, try this expression:

=pick(Match($Field, $(=concat( chr(39) & $Field & chr(39),',' )) ),

$(=concat( 'count({<[' & $Field  & ']={' & chr(39) & '<?>'  & chr(39) & '}>} [' & $Field  & '])' ,',')))