Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show the latest Dates on Date Dimension


Hello!

I have a pivot chart with the Monweek as columns (it's weekly columns)  from 03/01/2009 - current Date... You can just imagine how long is my pivot chart.  Thus, I would like to show only those dimensions and compute  qty and Total Values that belongs to the current week and incoming weeks..

For example :

If this week's Monweek is 02/03,my 1st column would be  02/03  then  02/10, 02/17...etc

                                        next week, my 1st column would be  02/10 then 2/17, 02/24,...etc

So its just like filtering the current week and incoming weeks.

Tks.

1 Reply
Not applicable
Author

IF you have a Date Field called DATA in the calendar,

Insert in Pivot a Calculated Dimension like this:

IF( DATA> Today()-14 and DATA<=Today(), Monweek)

Hope this helps