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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel1908
Creator
Creator

Count & Exclude a Field beginning with the same Number

Hello Together, 

I want to count the Material Numbers beginning with 6*, but exclude the ones beginning with  "6TZ8*"

=Count( {<[Price]*={"<=100"},Productkey*={'TH',"LR"},[ReturnLabel.]-={'A','B'}, Material= {"6*"},Material-= {"6TZ8*"}>

This does not work, any ideas?

Thanks in advance. 

Daniel

 

2 Replies
Frank_Hartmann
Master II
Master II

Maybe like this:

=Count({<[Price]*={"<=100"},Productkey*={'TH',"LR"},[ReturnLabel.]-={'A','B'},Material= {"=if(Wildmatch(Material,'6TZ8*')=1,Null(),Material)"}>}if(Wildmatch(Material,'6*')=1,Material))
Daniel1908
Creator
Creator
Author

The Formula shows OK but my expression afterwards doese not work anymore 

*(1-<[Request]={"*"}>)}[Product Number])