topic Re: Pivot Table Dimension: show selected date + 3 weeks in QlikView

Pivot Table Dimension: show selected date + 3 weeks

Wed, 25 Jun 2014 12:40:52 GMT

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!

Re: Pivot Table Dimension: show selected date + 3 weeks

Wed, 25 Jun 2014 12:49:55 GMT

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?

Re: Pivot Table Dimension: show selected date + 3 weeks

Gysbert_Wassenaar — Wed, 25 Jun 2014 12:54:18 GMT

See attached example

Re: Pivot Table Dimension: show selected date + 3 weeks

Wed, 25 Jun 2014 13:15:07 GMT

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