Load all previous data from the filter date

[zahidrahim_ocp]

Dear All,

I want to show all records from the date applied in the filter. Suppose i have one month date wise records if i select 15th in a filter then all records from 1 to 15 should display rather than only 15th day record.

Must be a simple solution but i am very much new to scripting.

Regards,

Zahid Rahim

[prat1507]

Use it in your set analysis, use it as

=Sum({<DateField={'<=$(=GetFieldSelections(DateField))'}>}Val)

[OmarBenSalem]

This a month to date implementation.

I invite you to see this; where I tried to explain step by step how to face these kinds of demands:

hope this will help:

YTD, MTD issue

[OmarBenSalem]

I'd suggest you surround it with double quotes from now on:

Quotes in Set Analysis

[zahidrahim_ocp]

Dear Omar,

Thank you for the reply. But could not understand the solution provided. I want to load all previous data from the filter date.

Regards,

Zahid Rahim

[OmarBenSalem]

It would be sthing like :

sum({<YourDateField=,YourDateField={"<= $(=max(YourDateField))"}>}yourExpression)

[zahidrahim_ocp]

Dear Omar,

My Filter Date column is TRANSACTION_DATE and the quantity column which need to be sum all data from the date selected is STOCK_QUANTITY. I am using the expression below but it keep returning 0.

sum({<TRANSACTION_DATE=,TRANSACTION_DATE={"<= $(=max(TRANSACTION_DATE))"}>} STOCK_QUANTITY)

Regards,

Zahid Rahim

[OmarBenSalem]

Can you share your app with? a test one maybe?

[zahidrahim_ocp]

Dear Omar,

There was date formats issue. Now it is adding up all values but the other filter where we don't have any record in that date stopped selection What is the best way to deal with this issue.

Regards,

Zahid Rahim

[OmarBenSalem]

I didn't really get it.

Can you elaborate it with some images maybe?