Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zahidrahim_ocp
Partner - Creator
Partner - Creator

Load all previous data from the filter date

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

16 Replies
prat1507
Specialist
Specialist

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
Partner - Creator
Partner - Creator
Author

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
Partner - Creator
Partner - Creator
Author

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
Partner - Creator
Partner - Creator
Author

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?