Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conversion to MTD

How to convert the below expression to MTD

Count(if(not IsNull(ONBL) and Len(Trim(OFBL)) <=0 ,FLNO))

3 Replies
ashfaq_haseeb
Champion III
Champion III

Hi

go through the below post.

http://community.qlik.com/docs/DOC-6163

Regards

ASHFAQ

its_anandrjs

Please elaborate more

Or you can use a expression like


Count( {<Datefield = {'>= $( =Monthstart(Datefield)  )  <= $( =Today(DateField) ) '}>} FLNO)


What is the use of not IsNull(ONBL) and Len(Trim(OFBL)) fields


Not applicable
Author

this is the calculation condition for counting the Flight no.,now the user want to see this value on month on month  basis