Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
naishaansh
Contributor III
Contributor III

Weekly Date in QlikSense

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?

Labels (2)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

try this

 

create week(Date)  as Week_no   

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

then use in set analysis below.

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

View solution in original post

4 Replies
Chanty4u
MVP
MVP

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
Contributor III
Contributor III
Author

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
MVP
MVP

 

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

 

naishaansh
Contributor III
Contributor III
Author

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.