Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
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
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
Dear Omar,
Did you understand the problem with below explanation OR should i elaborate further.
Regards,
Zahid Rahim
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?