Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to pass variables to tsalesforce input ?

Hi,

 

I have a requirement to parameterize the value of createdDate field of my tsalesforce input manual query.

The createdDate should be as below for different iteration:

1 iteration: createdDate >= systemdate and createdDate < (systemdate-2== ie 10th dec 2018-2 days = 8th dec 2018)

 

2 iteration : 8th dec 2018 -2 = 6th dec 2018 ie createdDate >= 8th dec 2018 and createdDate <6th dec 2018

 

Any suggestions to achieve this will be a great help. 

 

Thanks in advance.

 

Labels (3)
2 Replies
TRF
Champion II
Champion II

Use literals such as LAST_N_DAYS:n and TODAY
TRF
Champion II
Champion II

Did this help?
If so, thank's to mark your case as solved (Kudo also accepted as a bonus)