topic Re: Understand A Pivot Table Expression in QlikView

Understand A Pivot Table Expression

rebelfox — Tue, 01 Sep 2015 14:28:45 GMT

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.

Re: Understand A Pivot Table Expression

ChiragPradhan — Tue, 01 Sep 2015 14:51:45 GMT

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

Re: Understand A Pivot Table Expression

stigchel — Tue, 01 Sep 2015 14:52:31 GMT

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)

Re: Understand A Pivot Table Expression

rebelfox — Tue, 01 Sep 2015 15:15:38 GMT

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?

Re: Understand A Pivot Table Expression

ChiragPradhan — Tue, 01 Sep 2015 15:32:12 GMT

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.