topic Re: Chart showing results even date default does not exist on data in QlikView

Chart showing results even date default does not exist on data

roebrich — Fri, 25 Aug 2017 14:55:36 GMT

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!

Re: Chart showing results even date default does not exist on data

vinieme12 — Fri, 25 Aug 2017 15:03:03 GMT

Create a Master Calendar, that will fill in the Gap of your date field

http://qlikviewcookbook.com/2015/05/better-calendar-scripts/

Re: Chart showing results even date default does not exist on data

roebrich — Mon, 28 Aug 2017 04:17:23 GMT

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.

Re: Chart showing results even date default does not exist on data

vinieme12 — Mon, 28 Aug 2017 09:25:59 GMT

can you post a screenshot of your data model? or a sample app?