Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading specific strings from Table using WHERE INDEX

Dear Qlik Community!

I need your help once more, please! I have a big file where i'm storing thousands of tweets that are categorized by groups, brands, etc.

How could I load data into my Qlik Model that only considers certain categories? Would it have to be with an index function?

I'm trying

load * from 'C:\qlikview\Redes Sociales\CanastaTwitter\TwitterSearchTerms*.qvd' (qvd)

where index(Grouping(),'Retail')=1;

And it doesnt work. It just stops at that part of the script.

Any ideas? I need to extract all the accounts that are associated to that Grouping (Which is the name of the column) from a single file.

Thanks!!

2 Replies
m_woolf
Master II
Master II

where index(Grouping,'Retail')>0;

effinty2112
Master
Master

Hi Roberto,

                         Change your Where clause to:

Where WildMatch(Grouping, '*Retail*');

Good Luck

Cheers

Andrew