I am trying to write below expression in qliksense itself, but it's throwing an error:-
[Parent]:
SELECT
a.code_marketing_campaign ,b.[BusinessUnit__c] as 'Parent Campaign BU' ,b.[CurrencyIsoCode] as ' Parent Campaign Currency Code' ,b.[Description] as 'Parent Campaign Description' ,b.[EndDate] as 'Parent Campaign End Date' ,b.skey_marketing_campaign as skey_campaign_parent ,b.[IsActive] as 'Parent Campaign Active flag' ,b.name_marketing_campaign as 'Parent Campaign Name' ,b.[Region__c] as 'Parent Campaign Region' ,b.[StartDate] as 'Parent Campaign Start Date' ,b.[Status] as 'Parent Campaign Status' ,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] ,b.[Description] ,b.[EndDate] ,b.skey_marketing_campaign ,b.[IsActive] ,b.name_marketing_campaign ,b.[Region__c] ,b.[StartDate] ,b.[Status] ,b.category_marketing_campaign ;
