Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (1)
22 Replies
rajeshvaswani77
Valued Contributor III

Create list box of search terms

Hi Vijay, You could use BookMarks. regards, Rajesh Vaswani

jason_michaelid
Honored Contributor II

Create list box of search terms

Just create a bookmarks bar.  Make each set of selections and save as bookmarks.  These will be in your bookmarks bar as a drop-down list.

vlad_komarov
Valued Contributor II

Create list box of search terms

You can create a mapping table with list of pre-defined items which will be connected with your data via one of the fields (like 'Category') and have a list box with these items available for selecetion.

Good luck!

Regards,

Vladimir 

Not applicable

Create list box of search terms

Rajesh/ Jason,

Thanks for your response with the suggestion for Bookmarks. I tried doing it and running into trouble.

With all selections cleared, I went to the Review field box and typed "clean". Then I went to Bookmarks > Add Bookmarks and named it 'clean'.

Then, to test, I cleared my selections and tried to select the bookmark again hoping that it will apply the search filter correctly, but it failed and did nothing.

Am I doing something wrong?

Valdmir, Thanks for your suggestion. Never tried mapping before..will read about it and give it a shot.

Thanks,

Vijay

jason_michaelid
Honored Contributor II

Create list box of search terms

So "Review" is a field in your dataset and "Clean" is a valid value?  Have you tried clicking the value to select it rather than typing it in?  Then create the bookmark...

rajeshvaswani77
Valued Contributor III

Create list box of search terms

Vijay, Make your selections and then create the bookmark. Once its created then clear selections and select the bookmark. This will apply te selection you made again when you created the bookmark. Thanks, Rajesh Vaswani

rajeshvaswani77
Valued Contributor III

Create list box of search terms

Clean is valid and works for me.

vlad_komarov
Valued Contributor II

Create list box of search terms

Here is the basic example:

WorkModeMap:

mapping LOAD *

INLINE

[

    Mode, Description

    0, UNKNOWN

    10, UNSTAF

    20, AVAIL

    30, ACD

    40, ACW

    50, AUX

];

DataLoad:

LOAD *

Inline

[

          Mode, Price

          0,          12.34

          0,          43.24

          0,          43.42

          10, 34.34

          20,          54.52

          20,          444.99

          30, 3434.34

          30,          0.99

          30,          2.99

          30, 3.62

          40, 4.12

          50, 4.55

          50, 9.99

          50, 4.99

          50, 33.67

          10, 12.00

          0,  33.99

];

    

Data:

Load

          Mode,

          Price,

          ApplyMap('WorkModeMap', Mode) as Category

resident DataLoad;

DROP Table DataLoad;

Use Category field from the last table for selections.

Regards,

Vladimir

Not applicable

Create list box of search terms

Review is a field that may contain a scentence like "The room was awesome and clean". Another review might say, "The room was clena and the staff were friendly". The values are basically scentences.

When I search for 'clean', it will filter the dataset for reviews that contain the word clean.

For some reason at this point if I set the bookmark, it does not stick. Wondering if bookmark will only store selection and not search values?..will keep trying.