Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Amberj_29
Contributor III
Contributor III

Test string wildcard in set analysis?

Hi Everyone,

I'm trying to work out this question and I am just not getting very far. I have some data on book titles and their authors/publisher and which location buys them. I have been able to do counts with them all separate, but not altogether. I'm looking for the word 'Training' anywhere in the text string, has to be published by 'Greens' and I want it count distinct by location of sale. 

for example: (count(Distinct{<[Publisher]={'Greens'}, [Title]={'*Training*'}>} [Location]))

It is only the wildcard that is causing the issue here the '*training*'. Any help where I am going wrong would help. Also this is in a text box KPI. 

1 Solution

Accepted Solutions
arulsettu
Master III
Master III

Maybe try like this

(count(Distinct{<[Publisher]={'Greens'}, [Title]={"*Training*"}>} [Location]))

View solution in original post

1 Reply
arulsettu
Master III
Master III

Maybe try like this

(count(Distinct{<[Publisher]={'Greens'}, [Title]={"*Training*"}>} [Location]))

View solution in original post