topic To get the Current week in date field in QlikView

To get the Current week in date field

vidhya91gct — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 24 Apr 2018 07:24:52 GMT

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 — Tue, 24 Apr 2018 08:36:39 GMT

May be try

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

vishalarote — Tue, 24 Apr 2018 10:33:32 GMT

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 — Tue, 24 Apr 2018 10:40:33 GMT

And If u dont want RTC=0

then add in set analysis

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