Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

suryajegan
Contributor

Wanted to bind the user input date in formula

Hi

Now my formula is binding the last week end date instead of that i wanted to bind the user selected week end date.

=Sum({1<[PROCESSED_DT.autoCalendar.Date]={">=$(=(MonthStart(Max({1}[PROCESSED_DT.autoCalendar.Date]))))<=$(=WeekEnd(Max({1}[PROCESSED_DT.autoCalendar.Date]),-1))"},

[Rollover_Activity_Only.ROLLOVER_DESTINATION_TXT]={'RTF'}

>}

[Rollover_Activity_Only.ROLLED_TO_AMT])/1000000

Is that possible?

1 Reply
suryajegan
Contributor

Re: Wanted to bind the user input date in formula

Hi

Any suggestion ?

Community Browser