How to use IF clause if lower level data set consist of multiple levels

[whiteside]

Dear Qlik Community,

I am facing an issue with an If clause.

You see I am looking at 1 Shipment. 1 Shipment could have n status or text.

The Formular in the Field "Exonerated Text/Status" is as followed:

If (

    [Textcode key] =('T06') or [Textcode key] =('T08') or [Textcode key] =('T14') ,'Exonerated (textcode)'   

        ,If(

            [Status code]=('U10') or [Status code]=('F02') or [Status code]=('F06') or [Status code]=('F09') or [Status code]=('S36') or [Status code]=('S94'),'Exonerated (Status Code)'

                ,'Evaluated'))

Now if i delete the dimension of the "Status Code"

This is the what happens.

Actualy I expect here the value "Exonerated (Status Code).

Can anyone help me with the correct syntax?

kind regards

whiteside

[sunny_talwar · Accepted solution]

May be try this

MaxString(

If([Textcode key] =('T06') or [Textcode key] =('T08') or [Textcode key] =('T14') ,Dual('Exonerated (textcode)', 3),

If([Status code]=('U10') or [Status code]=('F02') or [Status code]=('F06') or [Status code]=('F09') or [Status code]=('S36') or [Status code]=('S94'), Dual('Exonerated (Status Code)', 2), Dual('Evaluated', 1))))

[whiteside]

Dear Sunny,

you are a live saver. I would not figure this out in a million years.
I have never heard about "DUAL". You are genius #TrulyALegend

Thanks again.

Cheers

whiteside