topic Quick Help SetAnalysis (using <> operator) in QlikView

Quick Help SetAnalysis (using <> operator)

Fri, 01 Oct 2010 16:25:11 GMT

=count({$<[FIELD1]={"Sales"}>} [FIELD2])

I would like to count, using set analysis, excluding FIELD1="Sales"

would be something like this:

=count({$<[FIELD1]<>{"Sales"}>} [FIELD2])

It seems that using "< >" operators in setanalysis is not property...

Tks!

Fri, 01 Oct 2010 16:27:33 GMT

hi try this:

=count({$<[FIELD1]-={"Sales"}>} [FIELD2])

regards

Fri, 01 Oct 2010 17:18:37 GMT

count({ $<FieldName= (FieldName - {"CustomerId"} ) >} FieldName)

Fri, 01 Oct 2010 17:20:18 GMT

It perfectly answered my question!

Tks