Dynamic Drop Down to get QTD or YTD data from one input file

[pokhan27]

Hi Expert

I am trying to make an analytical app which gives the user to choose whether they want QTD or YTD from the given extract 

in sample data. like when they run the app they will have an option to choose QTD or YTD as a dropdown. 

thank you again in advance. 

[atcodedog05 · Accepted solution]

Hi @pokhan27 

Here is how you can do it. You need to use condition tool and containers

Workflow:

Here is a helpful resource

https://community.alteryx.com/t5/Interactive-Lessons/Implementing-Conditional-Routing/ta-p/243117

Hope this helps : )

[pokhan27]

Hi 

Thank you so much, that's exactly what i was looking for. 

[atcodedog05]

Happy to help : ) @pokhan27 

Cheers and have a nice day!

[pokhan27]

hi 

its been a while i created a flow based on your workflow, but its only giving me the record from YTD container instead qtd even if i select qtd

when i select i qtd am getting calculation from YTD instead of QTD but YTD case is same. can you help