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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need to get Tomonth as num ?

HI All,

I need to get v_monthto should come as number in text object.

Jan means  ---1

Feb means ---2

Regards,

Helen

2 Replies
Not applicable
Author

You can load it into your script, or you can set it by just using Num(Month)   

settu_periasamy
Master III
Master III

Try this in text object

=Num(Month(Date#(v_monthto,'MMM')))