Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using the below expression to calculate the week number for the particular month.
For eg If the date is [15-01-2016 DD-MM-YYYY] is the date then the Week number is 3 instead of the week number in year.
Year([Date]) & ' ' & Month([Date]) & ' ' & ((Week([Date])) - Week( MonthStart([Date]) ) + 1) as week_field
Date is their business date and not system date
The Output of the expression in my local system is 2016 Jan 3
But when i deployed in the server the value of this expression will be showing the below output.
The Output of the expression in qlikview server is 2016 Jan -48 like that
Is there is anything i need to Perform ?
Please check the date format you have set and the input data your receiving
Try something like this, And the deploy and see how it's looking. Can you share That image. If so, getting correct then you may check Date format as avinasheliteRecommend. Then tell us. So that we can figure out the issue?
=Year(Today()) & ' ' & Month(Today()) & ' ' & ((Week(Today())) - Week( MonthStart(Today()) ) +1)