Switch Statement in Direct Discovery

[#1]

Hi,

I am using Qlikview 11.2 SR7.. I want to use the switch statement "case when field1 = '1' then 'H' when field1 = '2' then 'M' else 'L' end " of SQL in direct discovery. how could I Convert it to be used in Direct Discovery..? Please advise.

I have tried "If Statement" but it is not working..

[tresesco]

Could you post your tried script section?

[ashfaq_haseeb]

Hi,

Not sure if that is supported.

have a look at attached PDF.

To know what is supported.

Regards

ASHFAQ