using variables in a wildcard countif

[#1]

Hiya Im quite new to qlikview and wondering if anyone can help me

I have a field called leasing co with multiple company codes within it i was looking to count the rows which contain a particular company os for eg how many instances in the column that contain 'vLeasingCo'.

Any help greatly appreciated 🙂

[tresesco]

Use WildMatch() rather than if. Try like:

=Count( WildMatch(YourField, '*' & '$(vLeasingCo)' &'*'), YourField)

[#3]

Hi tresesco,

It looked perfect but didn't work told me I could only have 1 parameter for a count

[simondachstr]

count({$<YourField={"*vLeasingCo*"} YourField)

[#5]

sorry I tried it in the back end and it worked perfectly thanks so much  !