Pivot Table Dimension: show selected date + 3 weeks

[#1]

Hi Qlik community,

I have a pivot table with a couple of dimensions. It works as a forecast tool. When the user selects a date from a listbox, my table needs to show this date and the following days (in my case 3 weeks) as the dimension.

I am not realy sure how to achieve this.

Any help is appreciated!

[#2]

Hi Dr.Proton!

Try to use set analysis in your expression.

First change dollar sign to 1 - this will select all the dates from report, then manually select something like Date={P(date+21)}

For more information about this function read this:

P() & E() and where do you use them?

[Gysbert_Wassenaar · Accepted solution]

See attached example

[#4]

Exactly what I had in mind. Thank you very much!