Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zahidrahim_ocp
Contributor

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
Valued Contributor

Re: Load all previous data from the filter date

Use it in your set analysis, use it as

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

OmarBenSalem
Esteemed Contributor

Re: Load all previous data from the filter date

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
Esteemed Contributor

Re: Load all previous data from the filter date

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

Quotes in Set Analysis

zahidrahim_ocp
Contributor

Re: Load all previous data from the filter date

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
Esteemed Contributor

Re: Load all previous data from the filter date

It would be sthing like :

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

zahidrahim_ocp
Contributor

Re: Load all previous data from the filter date

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
Esteemed Contributor

Re: Load all previous data from the filter date

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

zahidrahim_ocp
Contributor

Re: Load all previous data from the filter date

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
Esteemed Contributor

Re: Load all previous data from the filter date

I didn't really get it.

Can you elaborate it with some images maybe?

Community Browser