Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
A previous question I posted was about defaulting my date filters to 1st day of current month to today's date, I found the answer to that on this link: https://www.youtube.com/watch?v=UTDyO68BYL8
After implementing the instructions there, I just changed the Field Event Trigger for the vStartDate to be =MonthStart(Today(opened_at_date)) and vEndDate to be =Today(opened_at_date). So far all is good, the issue I'm facing is it doesn't seem to apply that filter to my dashboard. Since those dates doesn't exist on my dataset I expect no results to be returned on the charts.
Thanks in advance for the help!
Create a Master Calendar, that will fill in the Gap of your date field
http://qlikviewcookbook.com/2015/05/better-calendar-scripts/
Thanks for the reply, I tried the master calendar approach on your link. It was giving me errors at first when I had it at the start of my script and when I placed it at the end of my script then added an Order By statement on my table it loaded fine.
However, the same issue exist where the date picker default doesn't have data yet the charts are still showing all data instead of none.
can you post a screenshot of your data model? or a sample app?