Understand A Pivot Table Expression

[rebelfox]

I have inherited a Qlikview report with an expression I don't understand.

Can anybody explain to me what this is doing?

Count ({$<[Contract_No]-={'100464-1','ZAD-HOC-1','YAD-HOC-1','ZHSADHOC-1'}>}Distinct Contract_No)

Thanks.

[ChiragPradhan · Accepted solution]

Hi

That expression is giving you a count of distinct Contract_No excluding these {'100464-1','ZAD-HOC-1','YAD-HOC-1','ZHSADHOC-1'} from the current selection.

HTH

Chirag

[stigchel]

Hello Roy, this set expression is counting the Distinct Contact_No under the current selections but with the stated values removed ('100464-1','ZAD-HOC-1','YAD-HOC-1','ZHSADHOC-1')

remove FieldA  A strings from the current set:

=Count({<FieldA-={"A"}>}FieldA)

[rebelfox]

Aha!  Yes OK.  I get it now.  Thanks.

That '-' and the list had me scratching my head.

I find it hard to make sense of these expressions but clearly you guys can read them and they make sense instantly.

Is there some sort of technique or trick to it?

[ChiragPradhan]

Hi Roy,

Here, Set Analysis: syntaxes, examples

And this is a good one for creating set analysis expressions: Set Analysis Wizard for QlikView

HTH

Chirag.