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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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] )

0 Replies