topic expressionproblem in QlikView

expressionproblem

Fri, 05 Nov 2010 07:57:45 GMT

I got a problem with an expression =count(item='a') or is it = count(item)='a' - either way it doesnt work for me.

I got a small test spreedsheet with 2 columns YEAR and ITEM.

YEAR ITEM
2008 a
2008 a
2008 b
2009 a
2009 b
2010 a
I want to make a chart with YEAR as dimension af only showing how many ITEMS a there is?

deepakk — Fri, 05 Nov 2010 08:16:40 GMT

try this expression

count(If(Item='a', item)

Deepak

Fri, 05 Nov 2010 08:28:41 GMT

Deepak - thanx it works like this

count(If(Item='a', item)), - you missed the last )

regards it solved my problem

johnw — Fri, 05 Nov 2010 22:01:10 GMT

Set analysis is faster if you have a lot of data and are using version 8.5 or above:

count({<item={'a'}>} item)