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

[zahidrahim_ocp]

Dear Omer,

Suppose I have below data.

TrDate      Item          Category          Quantity

01SEP17    1                    A                    10

02SEP17    1                    B                    10

03SEP17    1                    C                    10

04SEP17    1                    A                    10

05SEP17    1                    B                    10

06SEP17    1                    C                    10

07SEP17    1                    A                    10

08SEP17    1                    B                    10

Now if i select TrDate in filter as 05SEP17 it is adding quantity perfectly to 50 with your provided expression and even show category wise total as well like below:

A          20

B          20

C          10

But As we have only one transaction in category B on 05SEP2017 and being the TrDate filter applied on 05SEP17, I can only select category B Others are grey out if i forcefully select it effect on other filters. I want to give filter on category so that user can see total for category A and C as well.

If you need further clarification do inform me.

Regards,

Zahid Rahim

[sumit_ranjan_pa]

Rather that selecting max date, you should always go for range of date.

When you select a max date/ any date, then the range would be dates from the start till the end.

While creating master calendar, you can have this option as well.

This will resole your issue.

[zahidrahim_ocp]

Dear Sumit,

By selecting any date i can see only that date data it is not from start till end.

Secondly can you please share an example or bit elaborate on master calendar solution.

Regards,

Zahid Rahim

[sumit_ranjan_pa]

HI Zahid,

Thanks for the reply.

You can use a slider for max date selection.

Here: http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Slider_Object.htm

https://community.qlikview.com/thread/69270

You can see the master calendar solution in this DOC.

https://community.qlik.com/docs/DOC-8843

https://community.qlik.com/thread/48693

Let me know if you need any implementation help

[zahidrahim_ocp]

Hi Sumit,

Thank you for the reply. Your provided link is for Qlik View BUT i am using Qlik Sense. Do we have any control in Qlik Sense to select a date and we have data from day first till the date selected.

Can you please share your Skype Id.

Regards,

Zahid Rahim

[zahidrahim_ocp]

Dear Omar,

Did you understand the problem with below explanation OR should i elaborate further.

Regards,

Zahid Rahim

[OmarBenSalem]

Sorry, I'm really busy right now; I fully understand your issue, made some tests to try to break the Qlik's associativity but in vain.

stalwar1‌, can u help please?