topic Re: Set Analysis in QlikView

Set Analysis

Fri, 20 Feb 2015 16:33:20 GMT

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 — Fri, 20 Feb 2015 16:45:13 GMT

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

Fri, 20 Feb 2015 16:49:55 GMT

Thanks Manish

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

marcus_sommer — Fri, 20 Feb 2015 16:55:02 GMT

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

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

- Marcus

Fri, 20 Feb 2015 17:00:39 GMT

Thanks Marcus

Still returns 0.

marcus_sommer — Fri, 20 Feb 2015 17:03:55 GMT

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

- Marcus

Gysbert_Wassenaar — Fri, 20 Feb 2015 18:29:38 GMT

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

Mon, 23 Feb 2015 10:13:02 GMT

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 — Mon, 23 Feb 2015 11:24:43 GMT

Hi,

I have updated the report posted by Gysbert.

Hope this helps!

Regards,

Laxmi

Gysbert_Wassenaar — Mon, 23 Feb 2015 14:36:39 GMT

Ok, try this expression:

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

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

Mon, 23 Feb 2015 15:41:35 GMT

Not sure how it works but thank you.