Is it possible to create input variable for KeywordMap field?

Fri, 13 Feb 2015 07:02:50 GMT

Please help me if you can.....

In below example, I am hard coding numbers for subfield map substring. Is it possible to create a variable in dashboard and allow user to select his own number? By that user can take a look number of characters before and after based on his/her input.

In below, I am asking to show 10 characters before and 10 characters after key word. The goal is user can pass that value from dashboard.

===========================================================================================

Terms:

LOAD

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

,mid(Review,index( Review, subfield(MapSubString('KeywordMap', upper(Review)), '|')),10 ) as Mid_Example_Plus

,mid(Review,index( Review, subfield(MapSubString('KeywordMap', upper(Review)), '|')) -10,10 ) as Mid_Example_Minus

,index( Review, subfield(MapSubString('KeywordMap', upper(Review)), '|')) as index_example

RESIDENT Reviews

;

============================================================================================

topic Is it possible to create input variable for KeywordMap field? in QlikView

Is it possible to create input variable for KeywordMap field?