Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
marjan_it
Creator III
Creator III

pass a dynamic variable to a parameter in api

Hi All

I have an api that get startdate, enddate and citycode. H want to pass date(now()) as enddate, date(now()-10)  as startdate and citycode from a table in my database.

I use the following ruls in loading api but it doesnt work

let startdate=date(now()-10) 

let enddate=date(now()) 

WITH CONNECTION(
QUERY "p_start_date" "$(startdate)",
QUERY "p_end_date" "$(enddate)",
QUERY "p_citycode" "$(citycode)")
;

how can I do that?

Labels (4)
0 Replies