Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to create input variable for KeywordMap field?

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

;

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

0 Replies