Trying to convert SQL query in Qlik sense Cloud

Ravi_Nagmal — Wed, 19 Mar 2025 23:04:08 GMT

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'

Re: Trying to convert SQL query in Qlik sense Cloud

Albert_Candelario — Wed, 24 May 2023 17:32:06 GMT

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

topic Re: Trying to convert SQL query in Qlik sense Cloud in Data Movement & Streaming

Trying to convert SQL query in Qlik sense Cloud

Re: Trying to convert SQL query in Qlik sense Cloud