Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
RajaRajput28
Contributor II
Contributor II

On Demand App Generation

Hello, 

For one of my requirement , I am trying ODAG (On demand app generation). I am able to execute ODAG with below ODAG Script. 

//////////////////////////////////////////////////////////////////////////////////////////

Sub extendwhere (name, valvar_name)
Let T = name & '_colname' ;
Let COlname = $(T);
Let values = (valvar_name);
If len(Values) > 0 then
If len(Where_part) > 0 then
Let where_part = '$(Where_part) and match ("$(Col_name)",$(Values))';
else
Let where_part = ' Where match ("$(Col_name)",$(Values))';
EndIf
EndIf
end sub;

Set FREQUENCY = ;
Set FREQUENCY = $(odag_FREQUENCY);
Set FREQUENCY_Colname = 'FREQUENCY' ;

sET wHERE_PART = '';

fOR EACH FLDNAME IN 'FREQUENCY'
LET VALLIST = $($(FLDNAME));
WHEN (IsNull(VALLIST)) LET VALLIST = '';
IF LEN (VALLIST) > 0 THEN
cALL EXTENDWHERE ('$(FLDNAME)','VALLIST');

EndIf
Next FLDNAME

Trace GENERATED WHERE CLAUSE: ;
TRACE $(WHERE_PART);

 

 

////////////////////////////////////////////////////////////

 

Here frequency is showing us Count of weekly , monthly and yearly activity.  I am meeting all the ODAG criteria and when giving filter on frequency . (I selected monthly ) and even app is getting generated but it's coming up as same one(App showing Yearly, monthly , weekly) .  but my expectation is to get monthly data only.  

 

#ODAG , #On_Demand , #Dynamic _Link

 

 

Labels (1)
  • SaaS

0 Replies