Part 2: Pop-up Parameter in Tableau | Show/Hide Parameter | Show Both Relative & Custom Date Filter
Ғылым және технология
Make a parameter dynamic by showing/ hiding it as per the selection made in the main parameter. This functionality is also known as the pop up parameter. Also, you'll get to learn how to make two different kinds of date filter available for use.
Part 1 Link- • Part1: Calculations fo...
Пікірлер: 38
This should be more straightforward to do, but while it isn't, your solution works. I had seen two similar videos but yours is clearer and the first I could replicate.
We have legacy reports that use this option and this walk-tru was perfect to understand how they were created. Thank you!
Awesome video! I did not understand how to show hide dates with selection before and struggled. Thank you so much for all the detailed explanations.
Very good information, thank you for sharing..
Very nice! Worked like a charm :) Thank you Aanchal!
Fantastic little trick! Thank you so much
I liked this technique. Pls keep upload new videos
This solved my problem! Thank you for sharing your knowledge.
Hi Aanchal, I'm not able to remove the point from pop up sheet. Is it because of tableau version, I'm using 2021.1.5 Please help me with this. Thanks in advance
@polatejaswini2233
2 жыл бұрын
Hold shift button and try removing
It's brilliant. Thank you.
Hi Anchal, Great video. One question: My popup sheet is not expanding when data range is selected...my data source has no data right now. Is it because of that?
Thanks a lot
Hey Aanchal, very informative video! I want to change my Custom SQL parameter value automatically according to other parameters, any suggestion/ help you can provide?
Nice mam pls do share more videos
This solution I guess would only work for fixed sizing Dashboards as you are using floating sheet to cover up . Do you have any other solution for Automatic sized dashboard ?
Thanks..letmetry&letUknow
Thanks a lot..
worked
how to do for 3 options? like on choosing other option, for them also i have hirerchy
can you share the workbook. Also, how can we do it for weeks,months,quarter.
hi Anchal, thanks for the video, here you controlled 2 parameters start date ,end date but i need to control another 4 like start week ,end week and start month &end month , please suggest
@aanchalsoni3597
11 ай бұрын
Hi Rajeshwari!! Just apply the show hide filter according to your use case. Use a horizontal container as demonstrated.
how can we get workbook mam?
Hi, Is it possible to do the same thing in a vertical container. Can you make a video on the same please. Thank you.
@aanchalsoni3597
Жыл бұрын
Hi Lakshmi! Please follow this link for vertical container- kzread.info/dash/bejne/X3uklsWuYcmvhKw.html
Really great video! However, when I create a calculated field based on my parameter, I don't get all the options - true/false/null like you. Any ideas why?
@ashantinyongo7632
2 жыл бұрын
sometimes the filter gets stuck on only relevant values, try to check the all values in database box when you edit the filter
Client expects auto update end date was latest client not interested to manual select end date ... above method good but real scenario used very less.
@aanchalsoni3597
4 жыл бұрын
SANAGARI BABU - You are right, in that case you can use Today() date function to retrieve the latest date. There are n ways to illustrate a functionality, depends on how well you collaborate or mix/match the calculations.
i dont know what is the use of pop up sheet , can we use directly empty sheet with floating option
@aanchalsoni3597
3 жыл бұрын
Hi Naresh! The pop up sheet pulls and pushes the start & end date parameters. If you intent to use only the blank sheet then the parameters will show/ hide as expected, however, they won’t be clickable (bcuz the blank sheet would be overlapping them.)
@nareshd4199
3 жыл бұрын
@@aanchalsoni3597 supperb , thanks
when i added show or hide calc feild to filter it shows me only true option and no false or null option is shown in the filter ? why
@aanchalsoni3597
3 жыл бұрын
Check your calculation in that case. It should satisfy either true or false condition.
@monikadileep1731
3 жыл бұрын
@@aanchalsoni3597 did the same how you did in part 1 and 2 ,still same error. one question: Can we create vertical reference line for bar charts with measure on y axis,if so how
Hi, can we hide dimension filters on the dashboard same like this. If so please let me know. I need some help on top n function. Let me know your email I’d
Have you seen your own video. Nothing is visible.