Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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:
See attached example
Exactly what I had in mind. Thank you very much!