topic Re: DUAL REPLACE NUMBER BY TEXT in App Development

DUAL REPLACE NUMBER BY TEXT

jmialoundama — Sat, 16 Nov 2024 03:01:46 GMT

I am using an extension which allows me to display the values of my column.

have a column called Level which contains numbers from 1 to 6.

I would like to replace these figures with text for example if it is 1 then we put Lvl.1, if it is 2 then we put Lv.2

I was told about the DUAL function on Qlik Sense which allows you to do this.
I would like to have more details, thank you

martinpohl — Tue, 10 Mar 2020 15:52:37 GMT

hello,

the dual function allows you to give text a numeric value.

best example is month

jan = 1

feb = 2

oct = 10

So you see name of month but it is sorted by the numeric value

In script you can use it like

dual(text field,number field) as fieldname

All dual values are aligned like a number field to right instead of text fields aligned to the left by default

Regards

jmialoundama — Tue, 10 Mar 2020 15:58:18 GMT

Hi ,

Thanks you for you answer.

So in my case if I want to change the "1" of my DEPTH fields to "Lvl 1", what will it do in my script?