topic Re: Qlik Sense Dual Function - Displaying Text Value in App Development

Qlik Sense Dual Function - Displaying Text Value

tschullo — Sat, 16 Nov 2024 18:25:37 GMT

I searched on this topic and didn't find any satisfying answers.

Something has definitely changed between QlikView and Qlik Sense. We are running Nov 2019.

I have a set of statuses that I have formatted as DUAL values using a mapping table:

TS_StatusOrderMap:
mapping load * inline [
Status, Flag
Posted, 4
Submitted, 3
Approved, 2
Open, 1
] ;

I then apply this in the script to my table like so:

LOAD
...
DUAL(Status,ApplyMap('TS_StatusOrderMap',Status)) as Status,
...;

Once I reload, my Status filter only shows the numeric values 1-4, and my measure were i'm asking for it to show the
Max(Status) or even MaxString(Status) always shows a number. I need to show the text values.

There are cases where there are multiple statuses for a given row of data, so I need to show the max status.

What is going on here?

Re: Qlik Sense Dual Function - Displaying Text Value

Saravanan_Desingh — Mon, 29 Jun 2020 21:03:35 GMT

Can you try Text(Max(Status))?

Re: Qlik Sense Dual Function - Displaying Text Value

Vegar — Mon, 29 Jun 2020 22:46:52 GMT

An alternative solution could be.

TS_StatusOrderMap: mapping load Status, dual(Status,Flag) inline [ Status, Flag Posted, 4 Submitted, 3 Approved, 2 Open, 1 ] ; //Then apply this in the script to your table like so: LOAD ... ApplyMap('TS_StatusOrderMap',Status) as Status, ...;

Re: Qlik Sense Dual Function - Displaying Text Value

tschullo — Tue, 14 Jul 2020 20:46:56 GMT

I haven't quite put my finger on the issue yet, but it turns out that in my script, I load the data first as a temp table and then I create a new table with some additional translations. If I do the DUAL in the first load, everything works normally, but if I do it in the second table load, the weird behavior occurs where even a filter list of the Status field shows numbers instead of text values. Once I moved the DUAL to the first table, MaxString worked just fine.

I think this is a bug in QS as I have never seen it happen in QV.

Re: Qlik Sense Dual Function - Displaying Text Value

rahulanand — Sun, 23 Nov 2025 14:40:50 GMT

This works!