Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
anhdn
Contributor
Contributor

filter for month

I want to add filtering in such way that, i make the filter months for choosing all the month in database, then i want to make the filter days_of_month , this filter will show all the day of the month i chose from months filter

Labels (1)
1 Reply
Braveen
Contributor III
Contributor III

In filter chart, you can use the below functions to get what you want;

You can use MonthName()/Month() function to get month and year/month. For Days of the month, use Day() function.

You can refer the Qlik docs for the same:

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim....

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...