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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calender Objects

How to write a Let function for sales date range in edit script?

Labels (1)
3 Replies
avinashelite
MVP
MVP

Hi Vamsi,

Can you please elaborate your problem.

Not applicable
Author

Hi Avinash,

I need syntax for vFromDate= and vToDate= ...for calender object .

I want to select date specific for my sales data.

israrkhan
Specialist II
Specialist II

you can try like,

let vFromDate = Today() - 40; it will give you 40 days back date.

let VTodate = Today() - 2; it will give you 2 days back, as 27- 07- 2014

or let vtoday = Today(); will give you tday...

and than in the textbox you can use as, =Date(VTodate) and = date(vFromDate )  to see whats dates coming...

Hope it help...