Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rebelfox
Creator
Creator

Understand A Pivot Table Expression


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.

1 Solution

Accepted Solutions
ChiragPradhan
Creator II
Creator II

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

View solution in original post

4 Replies
ChiragPradhan
Creator II
Creator II

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

View solution in original post

stigchel
Partner
Partner

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
Creator
Creator
Author

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
Creator II
Creator II

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.