Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Qlik Refresh

Hi Team,

 

I have requirement, I need to start job in QMC based on one SQL Query like below 

 

SELECT *
FROM DBT_META_CTCT_PRD.TB_PROCESS
WHERE  load_cd = 'FWL'
 AND process_name = 'FWL' and stat_cd=2

QUALIFY ROW_NUMBER()

OVER (ORDER BY process_start_dtm DESC) =1

 

The job needs to be trigger whenever stat_cd=2 daily basis. If Stat_cd=1 or Stat_cd=3 it should ignore

 

Please help me how can we do this? 

 

 

Thanks,

Siva

1 Reply
Partner
Partner

Re: Qlik Refresh

Hi 

 

If anyone not understand. I can explain more clearly. Please let me know

 

Thanks,

Siva