Trying to convert SQL query in Qlik sense Cloud

[Ravi_Nagmal]

Hi All,

I am trying to convert below mentioned SQL query in Qlik sense cloud. Please help with Qlik sense query for the same if possible.

(SELECT 
								CASE  When (SELECT TOP 1 Attribute1 FROM CS_Config_LookUpsDataService WITH(nolock) WHERE WebsiteServiceID = isnull(ASN.WebsiteServiceID,INQ.WebsiteServiceID)  AND ServerLocation = isnull(ASN.ServerLocation,INQ.ServerLocation) AND  isDeleted !=1 AND LookUpCategory = 'FormattingOptions' AND CategoryDataId = Isnull(ASN.FormattingOptionId,INQ.FormattingOptionId)) ='No' Then 'No'
  When (SELECT TOP 1 Attribute1 FROM CS_Config_LookUpsDataService WITH(nolock) WHERE WebsiteServiceID = isnull(ASN.WebsiteServiceID,INQ.WebsiteServiceID) AND ServerLocation = isnull(ASN.ServerLocation,INQ.ServerLocation) AND  isDeleted !=1 AND LookUpCategory = 'FormattingOptions' AND CategoryDataId = Isnull(ASN.FormattingOptionId,INQ.FormattingOptionId)) ='Yes' Then 'Yes'
  Else 'N/A'
								END)  'Formatting' 

[Albert_Candelario · Accepted solution]

Hello @Ravi_Nagmal,

Thanks for posting.

Have you created the connection to the database from Qlik Cloud? If not, maybe you can use the Data Gateway direct access - ODBC databases | Qlik Cloud Help

Have you reviewed this - SQL | Qlik Cloud Help?

Cheers,

Albert