How to use Convert and Case SQL functions in QlikS

[Wallibee]

Hi 

I want to use following SQL statement in Qlik, how can we use it script?

    convert(varchar,Relationnumber) AS keynumber,

    case when countrycode in ('S','SE') then SUBSTRING(Postnummer,1,4) else Postnummer end AS Newcode

Thanks in advance

@mindaugas2048 

[Wallibee]

Hi 

I want to use following SQL statement in Qlik, how can we use it script?

    convert(varchar,Relationnumber) AS keynumber,

    case when countrycode in ('S','SE') then SUBSTRING(Postnummer,1,4) else Postnummer end AS Newcode

Thanks in advance

@mindaugas2048 

[Anil_Babu_Samineni]

Check this

https://help.qlik.com/sv-SE/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptCon...

[Wallibee]

thanks @Anil_Babu_Samineni  for your responds .

Sorry but the link does not answer the question, Do you mean to say switch is the  replace syntax for convert ? 

[Anil_Babu_Samineni]

We don't know where you are using. If you are using as field may be

If(match(countrycode, 'S','SE'),  mid(Postnummer,1,4), Postnummer) AS Newcode

[Wallibee]

I am applying this in QS and  countrycode is a field . I was wondering if substring works in  QS scripting as a function 

[Anil_Babu_Samineni · Accepted solution]

You have to use mid in qlik as mentioned in the expression