Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create list box of search terms

I have a data based on some ratings and reviews for which I have all the charts I need.

I'm trying to create a list of common search terms on the review text (instead of everyone having to type in search terms), which people can click on to see all the charts update.

Eg. Assume my data set is a bunch of reviews for a hotel, rating and some other dimensions for which I have created charts.

I want a list box box of industry search terms like clean, service, staff, view, pool, kids, etc... so that my clients can just click on these terms and discover patterns.

Any suggestions on how to do this?

Thanks,

Vijay

22 Replies
Not applicable
Author

Okay..I found the problem.

If I search using the quick search on on the field, then that is not bookmarkable.

If I create a seperate search object linking it to my Review field and then use that to search, then it sticks in the bookmark.

So I have an acceptable way that works.

Thanks everyone.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Attached is an approach that creates a seperate table of keywords and links them to the reviews.

-Rob

http://robwunderlich.com

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Here's another version - even simpler. This one works only if the keywords are single words. If the terms are multi words like "poor service" you'll have to use the previous example. Example Qvw attached as well.

Keywords:

LOAD * INLINE [

Keyword

Clean

Pool

Service

Kids

Vacation

]

;

Reviews:

LOAD *, RecNo() as ReviewId INLINE [

Review

The pool was great

Great place for kids. Very clean.

The staff was terrible. Bad stay all around.

Very clean pool. Great service!

]

;

Inner Join(Keywords)

LOAD

          ReviewId,

          subfield(Capitalize(purgechar(Review, '.!,')), ' ') as Keyword

RESIDENT Reviews

;

Not applicable
Author

Hi Rob


Can you please upload PE enabled version?

BR

SAK

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I'm sorry, I can't PE enable documents. Only Qliktech can do that.

-Rob

Not applicable
Author

Hi Rob,

Can you please paste here script for generating multi word keyword list

BR

SAK

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Here you go:

Keywords:

LOAD * INLINE [

Keyword

Clean

Pool

Service

Kids

]

;

KeywordMap:

MAPPING LOAD

          Upper(Keyword),

          '|' & Keyword & '|'

Resident Keywords

;

Reviews:

LOAD *, RecNo() as ReviewId INLINE [

Review

The pool was great

Great place for kids. Very clean.

The staff was terrible. Bad stay all around.

Very clean pool. Great service!

]

;

Terms:

LOAD

          ReviewId,

          subfield(MapSubString('KeywordMap', upper(Review)), '|') as Keyword

RESIDENT Reviews

;

Inner Join(Keywords)

LOAD *

RESIDENT Terms

;

DROP Table Terms;

Not applicable
Author

Hi Rob,

Thanks a lot! I found many selfless people here who are just share knowledge especially with beginners and non-tech people.

Hope I would be able to use your script for my purpose.

BR,

SAK

Not applicable
Author

Dear Rob,

This solution looks perfect to me, and I would like to use this from an excel load, but I cannot seem to change the script from the inline into an excel-load.

-->

Reviews:

LOAD *, RecNo() as ReviewId INLINE [

Review

The pool was great

Great place for kids. Very clean.

The staff was terrible. Bad stay all around.

Very clean pool. Great service!

Where "Review" is a column in the excel.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I would think it would be as simple as something like:

LOAD Review, RecNo() as ReviewId

FROM

[..\myexcel.xlsx]

(ooxml, no labels, table is Sheet1);

-Rob