qliksense - Qlikview Current selections box to use labels rather than table.fieldnames -


in qlik view document want change current selections information use label applied field rather table.field format.

for example

partstable.partno

would be

part number

unfortunately there's no way in current selections object. however, may have alternatives depending on requirements.

first of all, if you're happy seeing current selections text (rather having functionality of current selections object), can create text object , use expression:

=replace(getcurrentselections(), 'partstable.partno', 'part number')

this below:

qlikview text object , list box partstable.partno

the other alternative use rename statement in load script after table loads complete. rename allows rename single field or collection of fields using mapping table. syntax single field shown below:

rename field oldname newname

if should need rename more 1 field @ time, can expand to:

rename field oldname1 newname1, oldname2 newname2,...

more detail on syntax including using mapping table can found in qlikview installed file.

for example, put small demo:

qualify *;  partstable: load * inline [     partno     100     200     300 ];  unqualify *;  rename field partstable.partno [part number];

this results in:

the renamed field alongside current selections object

rename similar alias (as) statement, except can first load of data, , rename @ end. rename field appears under new name in front-end controls (e.g. current selections etc.) however, may not suitable if have existing field named part number in script.


Comments

Post a Comment

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

this code i'm using find latitude , longitude of place: function coords($address){ echo $url="http://maps.googleapis.com/maps/api/geocode/json?address=".$address; $json = file_get_contents(urlencode($url)); $data = json_decode($json, true); print_r($data['results'][0]['geometry']['location']['lat']); print_r($data['results'][0]['geometry']['location']['lng']); } however returns warning: failed open stream: http request failed! http/1.0 400 bad request if use above code in simple procedure works fine not in function. note: have tried curl_init()... method produced same result? instead of encoding whole url encode address part. following code work fine $add='jamshoro phase 2'; $url="http://maps.googleapis.com/maps/api/geocode/json?address=".urlencode($add); $json = file_get_contents($url); $data = json_decode($json, true); print_r($data['r
Read more

java - How to filter a backspace keyboard input -

i have code gives message when key number pressed: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochararray().length - 1]; if (!(ch >= '0' && ch <= '9')) { system.out.println("the char entered not number"); t.consume(); } } }); now if press on wrong button , press backspace remove it, error message. how can add backspace input if statement? i have found answer: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochar
Read more

java - Show Soft Keyboard when EditText Appears -

i have code in android app, alert dialog , keyboard, , when dialog shown want keyboard appear. not , not sure why? here code: final alertdialog.builder alert = new alertdialog.builder(this); alert.settitle("title"); alert.setmessage("message"); final edittext input = new edittext(this); input.setinputtype(inputtype.type_class_number); alert.setview(input); input.setonfocuschangelistener(new view.onfocuschangelistener() { @override public void onfocuschange(view v, boolean hasfocus) { if (hasfocus) { log.i(tag, "in focus"); inputmethodmanager inputmethodmanager = (inputmethodmanager) getsystemservice(context.input_method_service); inputmethodmanager.showsoftinput(input, inputmethodmanager.show_implicit); } } }); but keyboard not appear though edit text in focus, , tell appear why, doesn't come up? thanks in advance.
Read more