CODEWITHSUNDEEP
business-intelligenceqliksense
alf.cz
alf.cz

Reputation: 59

Filter by date in Qlik Cloud

I have sheet in Qlik Cloud, where I have dataset from whole month. I would like to filter this dataset by date or time - 1 day, 1 week, 12 hours... column with date/time in format yyyy/mm/dd hh:mm:ss is in dataset for each row. Is possible insert some calendar? Or have you any idea? Thanks for your answers ;)

Upvotes: 1

Views: 586

Answers (1)

Chris J
Chris J

Reputation: 936

Provided that your data is loaded correctly, drag the field directly onto the sheet. This will create a look-up box that can be searched.

You can see if the field has been identified correctly as a date as it will appear like this on the field selector

date example

Another Option

Create a filter box option and add your date field to it, the benefit of this is that you can have multiple filters in one place. Allowing users to pick the part of the date relevant to them. For example showing the year field, the month field and the date field in one

one more option

Using non-standard Qlik extensions you can achieve the functionality that you require. SenseDateRangePicker is an extension that provides extended date selection functionality.

Upvotes: 1

Related Questions