Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
beskqlik
New Contributor II

Passing date dynamically from filter panel to report

HI 

I have date column.I am trying to 30 previous dates when selecting a date at filter panel.Like if i select May 10 2019 at filter. Below at report i should get dates.Can any one suggest as how can i get it


11-Apr-19
12-Apr-19
13-Apr-19
14-Apr-19
15-Apr-19
16-Apr-19
17-Apr-19
18-Apr-19
19-Apr-19
20-Apr-19
21-Apr-19
22-Apr-19
23-Apr-19
24-Apr-19
25-Apr-19
26-Apr-19
27-Apr-19
28-Apr-19
29-Apr-19
30-Apr-19
1-May-19
2-May-19
3-May-19
4-May-19
5-May-19
6-May-19
7-May-19
8-May-19
9-May-19
10-May-19

Labels (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Passing date dynamically from filter panel to report

You can fetch the last 30 days in your expression by using SET analysis.
Try something like this, assuming SUM(Amount).

Sum({<
Month, year, week, yearmonth,
DateField={">$(=max(DateField)-10)<=$(=max(DateField))"}
>} Amount)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Partner
Partner

Re: Passing date dynamically from filter panel to report

You can fetch the last 30 days in your expression by using SET analysis.
Try something like this, assuming SUM(Amount).

Sum({<
Month, year, week, yearmonth,
DateField={">$(=max(DateField)-10)<=$(=max(DateField))"}
>} Amount)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

beskqlik
New Contributor II

Re: Passing date dynamically from filter panel to report

Wow, its working. Thank you very much

Partner
Partner

Re: Passing date dynamically from filter panel to report

Typing 30days writing code for 10 days🙊🙉🙈

I'm still a bit sleepy this morning.

Glad it worked out for you.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes