Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

CAST in DIRECT QUERY

Hi All,

I have a doubt that when i am using CAST function in DIRECT QUERY..it's not working.

EX:->

DIRECT QUERY

SELECT

a.code_marketing_campaign
,b.[BusinessUnit__c] as 'Parent Campaign BU'
,b.[CurrencyIsoCode] as ' Parent Campaign Currency Code'
,CAST(b.[Description]) as 'Parent Campaign Description'
,CAST(b.category_marketing_campaign ) as 'Parent Campaign Type'


from (select distinct code_marketing_campaign from [WH_ID_EMEA].[dwh].[marketing_campaign]) a
inner join [WH_ID_EMEA].[dwh].[marketing_campaign] b
on a.code_marketing_campaign=b.bkey_marketing_campaign

group by
a.code_marketing_campaign
,b.[BusinessUnit__c]
,b.[CurrencyIsoCode]
,CAST(b.[Description])
,CAST(b.category_marketing_campaign );

Please suggest..

0 Replies