Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Create a date filter in Alteryx App

pokhan27
8 - Asteroid

hi Expert 

 

i have created an alteryx app which gives user to select QTD or YTD option like below. 

 

 

pokhan27_0-1641347732699.png

now i want to add a date drop down which will allow me to select the timeline for example: "Year drop down" and "quarter drop down" and MNonthly dropdown:. 

i have a source file where there are dates. sample workflow is uploaded

 


 
 

in the flow use can see there is hardcoded filter for current quarter which is prohibiting me to choose the record from past quarter. or even i say 

i am in Jan 2022, and when i try to run last qtr am not able to do as new quarter had already begun

 

in order to overcome this, if i can have a dynamic date filter option before running the flow than it make sense. 

for your reference i have selected one of the flow from my macro along with the sample file

 

screen shot of my macro

 

pokhan27_2-1641349082584.png

 please help

 

 

 

1 REPLY 1
pokhan27
8 - Asteroid

actually i am looking a case similar to the date range type like this one 

 

pokhan27_0-1641390412775.png

but i have more than 10 input file where data is cleaned properly, so need this date range to act as a filter

 

Labels