Skip navigation

5 Replies Latest reply on Jan 4, 2018 9:39 PM by Shinichiro Murakami

Show / Hide quick filter dynamically based on another quick filter value

Saravanan Chidambaram Dec 31, 2017 9:18 AM

Hi,

I have a case where I need to Show / Hide a quick filter based on a value selected on another quick filter.

Please let me know if you have come across a similar case and have a solution.

Parameter is not a solution for me as we have bunch of other filters also in the dashboard which is a global filter going across different dashboard.

Attaching a sample dashboard with a scenario.

I want to HIDE the Campaign name quick filter dynamically if the anyone select the Country Code other then "US".

NOTE: it should remain hidden when it "All" by default and should show only when we select the "US" under the Country Code quick filter.

Thanks,

Saravanan.

Show&hide filter_VT.twbx 34.2 KB

1. Re: Show / Hide quick filter dynamically based on another quick filter value

Shinichiro Murakami Dec 31, 2017 8:03 PM (in response to Saravanan Chidambaram)
Hi Saravanan,

Quite a bit manual works are needed, but this is the only way I know of.

Create another worksheet.

Fit entire view and hide title.

You can change "XXXX" to " " (space) afterwords.

Thanks,
Shin

Show&hide filter_VT_SM_10.0.twbx 21.0 KB
Like Show 0 Likes(0)

Actions
2. Re: Show / Hide quick filter dynamically based on another quick filter value

Saravanan Chidambaram Jan 1, 2018 3:36 AM (in response to Shinichiro Murakami)

Thanks for your detailed response..

Can you please attach the dashboard where you made the modification for me for reference?

Thanks & Regards,
Saravanan Chidambaram.
Like Show 0 Likes(0)

Actions
3. Re: Show / Hide quick filter dynamically based on another quick filter value

Shinichiro Murakami Jan 1, 2018 9:08 AM (in response to Saravanan Chidambaram)

Hi Saravanan,

You cannot see attachment from inbox view, please go to original post.

And could you mark my answer as correct to close the thread, not from inbox but from original post.

Thanks,
Shin
Like Show 0 Likes(0)

Actions
4. Re: Show / Hide quick filter dynamically based on another quick filter value

Saravanan Chidambaram Jan 4, 2018 1:39 PM (in response to Shinichiro Murakami)

Hi,

On your workbook. I am not able select filters which are show once the condition is met which is "US".

Looking forward for your response.

Thanks & Regards,
Saravanan Chidambaram.
Like Show 0 Likes(0)

Actions
5. Re: Show / Hide quick filter dynamically based on another quick filter value

Shinichiro Murakami Jan 4, 2018 9:39 PM (in response to Saravanan Chidambaram)
HI Saravanan.

sorry for the confusion.
Here is a revised version.
Added layout container.

Regards,
Shin

Show&hide filter_VT_SM_10.0_V2.twbx 20.6 KB
Like Show 1 Likes(1)

Actions

Go to original post

More Like This