Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

Hi

Any suggestion ?