Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashish_1102
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
1ABCABCxyz1/1/2019
1ABCABC1xyz12/1/2019
1ABCDEFABc23/1/2019
2ghiaBCuvw4/1/2019
3jklDEF1ABc5/1/2019

 

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

PIDPNAME# by name match#by title/headline match
1ABC35

 

#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
Brett_Bleess
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.

Regards,
Brett

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.
Carlos_Reyes
Partner
Partner

Hi,

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.