Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Attached is an approach that creates a seperate table of keywords and links them to the reviews.
-Rob
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
;
Hi Rob
Can you please upload PE enabled version?
BR
SAK
I'm sorry, I can't PE enable documents. Only Qliktech can do that.
-Rob
Hi Rob,
Can you please paste here script for generating multi word keyword list
BR
SAK
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;
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
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.
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