Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Wildmatch in set analysis to search values from an entire column

Dear community members

i've a requirement. Any help would be hugely appreciated.

I've a data table like this -

PIDPNAMETitleHeadlinePublished Date


In UI i've a staright table where i've to construct two expressions like this -

PIDPNAME# by name match#by title/headline match


#by name match is a simple one where i just have to count the number of times ABC was published.

#by title/headline match  is the trickier one. here i have to search that PNAme in the whole title and headline columns, wherever i find a wildmatch (e.g; ABC1) or a mixmatch (e.g; ABc) or  a mixture of both (like ABc2) or an exact match, i've to count those published dates only.

I've manually populated the desired results in the straight table above.

Could you please help me to construct the second expression.


Many thanks in advance.

Labels (2)
2 Replies
Support (Former)
Support (Former)

If you can attach an example app, that may allow someone to better help you if you are still trying to figure things out on this one.


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.


I'm not really sure you can accomplish this through Set Analysis... since you need to "forget" about the relationships between the string you want to search and the records it has associated... so, I'd go for a script solution. Review the enclosed app.