Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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...