To get the Current week in date field

[vidhya91gct]

Hi All,

I want to show the current week data in chart,

it is my table format,

Milestone_Week  RTC_ID

CW01-2018           1

CW02-2018            2

CW03-2018            3

CW04-2018            4

.

;

CW53-2018            -

Current week is CW17-2018, so i want to show the count of RTC_ID depending upon current week.

I am using in the below expression for getting current week , but it is showing CW53-2018

=if(count(RTC_ID)<>0 or Milestone_Week<>0,MaxString(Milestone_Week),0)

Please help me on it.

[olivierrobin]

hello

in your table, add a field contaning the date of the first day of your week

and use this field in your set analysis

[sasiparupudi1]

May be try

if(mtc_week='CW'&SubField(WeekName(Today()),'/',2)&'-'&SubField(WeekName(Today()),'/',1),Count(RTC_ID))

[vishalarote]

Try this its works,

Make two Variables

1. vCurr

=week(Today())&year(Today())

2. vEqual

=purgeChar(Milestone_Week,'CW-')=week(Today())&year(Today())

and simply used set analysis

=count({<Milestone_Week={"=$(vEqual)"}>}RTC_ID)

PFA,

[vishalarote]

And If u dont want RTC=0

then add in set analysis

=count({<Milestone_Week={"=$(vEqual)"},RTC_ID={">0"}>}RTC_ID)