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

Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

filter

I need single filter for having previous and current month data. Iam able to use the below filter on QV  but it does not work in nprinting filter.

='>=' & Date(MonthStart(Today(), -1)) & '<=' & Date(MonthEnd(Today()))

1 Reply
mohamed_ahid
Partner - Specialist
Partner - Specialist

try this :

='>=' & Date(MonthStart(addmonths(Today(), -1))) & '<=' & Date(MonthEnd(Today()))