Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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