Weekly Date in QlikSense

[naishaansh]

I have a pivot table. The column is Weekly Date. Currently it is showing past weeks , current week and future weeks. 

They want it to show future week.

E.g the values currently are 3/19, 3.26, 4/2, 4/9, 4/16

the want to see only 4/9, 4/16 and beyond

How do I do that?

[Chanty4u · Accepted solution]

try this

create week(Date)  as Week_no   

and variable  : vCWeek = =(week(today()))

then use in set analysis below.

sum({$<,Week_No= {'>=$(vCWeek) '}>}Sales)

[naishaansh]

Thanks.

1. Its not a set analysis measure. Its a column in the pivot table. How to do there?

2. When using  >= , don't we surround it by " ". You have surrounded it by  ' '.

[Chanty4u]

Simply add calculated dimension: IF( WeekNumber >= Max(WeekNumber), WeekNumber )

[naishaansh]

Thanks . Your solutions helped. Depending upon the need one can choose set analysis or calculated dimensions. 

I resolved this way - 

if( [Weekly_Date] >= weekend(today(),0,0), [Weekly_Date])

My first week of the day was set to 5 and the weekly dates were displaying the saturday dates.