Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I try the following expression:
if([Contract Type]='Valid',Count([Contract Type]))
and it give me null value!!
any help please
Try count({<[contract type]={'Valid'} >} contractid) no if statement required.
Assuming you are wanting the number of valid contracts.
Regards
Andy
Set analysis is recommended for performance reasons and there is at least one case where IF would give you wrong result. Point 2b in the link below:
Using “IF” in expressions vs using “Set Analysis” | QlikView Help, Tips & Hints
although the other answers are right that a set Analysis for performance reasons are the better solution:
count(if([contract type]='Valid',[contrace type])
works.
Regards