Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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)
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?
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.