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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel1908
Creator
Creator

Count/If/Age Expression

Hello Together,

A am using the below expression, it works fine. 
(It counts text which includes bike and excludes Material beginning with 1)

=Count({<[Text]={"=WildMatch(Left(Text,20),'*Bike*')"},
Material=P({<Material={"*"}>}Material)
*E({<Material={"1*"}>}Material)>*(1-<>)}Material)

Now I want to add the below:
It should only count if the beginning date is not >2 Years. 

if(age(today(),[Beginning Date])>2,'OK','Nicht OK')

I want to bring this together, but unfortunately it does not work. 

Any Ideas?

 

2 Replies
Digvijay_Singh

Something like this may be - 

=Count({<[Text]={"=WildMatch(Left(Text,20),'*Bike*')"},
Material=P({<Material={"*"}, [Beginning Date] = {"=age(today(),[Beginning Date])>2"} >}Material)
*E({<Material={"1*"}>}Material)>*(1-<>)}Material)

Daniel1908
Creator
Creator
Author

Thanks for your help