Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I count results or expression

I have an expression like that

if(count(
{<
[Year of conclusion]=     {2014},             
[Contract Conclusion Date] -= {"<=$(=Date(vNewC))"}

>}
DISTINCT([Contract Number])
),'New','Old')


How can i count only new contractc and old ones


somefing like


count([My ecpression] = 'New') does not work

or

count({<[My ecpression]={'New'}>} [My ecpression] )

Labels (1)
0 Replies