topic Translate Listbox Display Value in QlikView

Translate Listbox Display Value

Johnnyg248 — Wed, 13 Mar 2019 15:42:32 GMT

Have a flag field in sql table that is a bit field (value is 0 or 1)

Is it possible to "translate" the field so list box would display 'Y' or 'N'?

I guess could just translate in load script but just curious

Re: Translate Listbox Display Value

jaibau1993 — Wed, 13 Mar 2019 15:48:39 GMT

Hi! You can translate it in the script:

LOAD
...
if(BitField = 1, 'Y', 'N') as TranslatedBitField
...

Also, you can create a calculated dimension in a chart or listbox as well (no script modifications).

Hope it helps!
Jaime.

Re: Translate Listbox Display Value

marcus_sommer — Thu, 14 Mar 2019 09:26:32 GMT

It could be also done within the listbox by choosing an expression as source and not a field. I assume that you have multiple of such flag-fields and then a script-solution would be probably more suitable - maybe also as dual() values, like: dual('Y', 1).

- Marcus