Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Partner
Partner

Date filter Issues

I am trying to insert a filter for "year".

My date column currently contains month, date, year, and time stamp.

When I select the 'Date/Time Closed.autoCalendar.Year" option, I am able to see both 2017 and 2018.

2017 is correct, but when I select only 2018, the number count is not correct. It only displays the count that would've been for the first month in 2018.

any ideas why this is happening?

4 Replies
Partner
Partner

Re: Date filter Issues

Hi,

If you can share some data or script that would help solving this fast. Plenty of people here that knows date issues very well.

Is the data coming from the same source?

Best,

Ali A

balabhaskarqlik
Honored Contributor

Re: Date filter Issues

Share expressions or script or screenshot, easy to understand the issue.

Partner
Partner

Re: Date filter Issues

I guess the issue is that Qlik is not recognizing all the timestamp dates in my column, causing the discrepancy in the count.

My date is currently formatted like this:  01/01/2021 12:00 PM

In the data manger, this is a screenshot of how Qlik is interpreting my datatimestamp.jpg

Next is the screenshot showing how some of the dates are marked with a "-"

timestamp not displayed.jpg

Highlighted
Partner
Partner

Re: Date filter Issues

The data is all coming from the same excel file that was extracted from the database