14 Replies Latest reply on Nov 16, 2017 10:53 PM by Shinichiro Murakami

Switch parameters dynamically based on filter values

Vasu choudhury Nov 10, 2017 8:45 AM

Hello,

I have Qtr filter with 2016-Q4, 2017-Q1, 2017-Q2, 2017-Q3 values.

Created Parameter which has 3 values i.e. All Status, Eligible, Not-Eligible(all these are derived with some specific logic)

Currently, I am able to see all the above 3 values irrespective of the any filter value selection in Qtr filters.

My Requirement, when selected one of the value from drop down:

2017-Q1/Q2--> parameter should show : All Status, Eligible, Not-Eligible(which works currently)

2017-Q3 only --> parameter should show : Eligible, Not-Eligible only.

And this should happen dynamically..

Any suggestions pls..

Regards,

Vasu.

1. Re: Switch parameters dynamically based on filter values

Hari Ankem Nov 11, 2017 6:34 PM (in response to Vasu choudhury)

The list of values in a Parameter is static and cannot be controlled by another parameter or a filter. You can look at having another data source with the required values for a quarter, and joining your primary data source with it.
Like Show 0 Likes(0)

Actions
2. Re: Switch parameters dynamically based on filter values

Norbert Maijoor Nov 15, 2017 10:11 AM (in response to Vasu choudhury)
Hi Vasu,

As mentioned by Hari Ankem you are not able to "populate" a parameter dynamically

An approach could be based on scaffolding in combination with "Relevant Values Only"...but no sure if this is feasible in your scenario. For sure you need a place where you can define the relation between Qtr and Status

Then you are able to work with "cascading" filters based in "Only Relevant Values"-functionality

Hope it helps

Regards,
Norbert

only relevant_nalmai_10.3.twbx 6.5 KB
Like Show 0 Likes(0)

Actions
3. Re: Switch parameters dynamically based on filter values

Vasu choudhury Nov 12, 2017 5:52 PM (in response to Norbert Maijoor)

Thanks for your reply Hari & Norbert!

I don't think this could be a feasible solution in my scenario because I do COUNTD(ID) and derive the parameter values based on the below logic.
Currently dsplaying the Parameter as a quick filter in the dashboard along with other Qtr field.

Created calc field and set to 1 in Filter shelf.
Case [parameter]
when ‘1’ then ‘1’ <--- All Status
when ‘2’ then if [ELIG]=1 and [ENC]=0 then 1 end <-----Eligible
when ‘3’ then if [ELIG] = 1 and [ENC]=1 then 1 end <---- Encounter
end

Please let me know if there is any work around.
Like Show 0 Likes(0)

Actions
4. Re: Switch parameters dynamically based on filter values

Peter Fakan Nov 12, 2017 8:16 PM (in response to Vasu choudhury)

Hi Vasu,

You could try grouping the different arrangements of status fields and then using these groups from your calculated field that you build off your parameter;

in pseudocode

case [parameter]
when "1" then [group 1]
when "2" then [group 2]
else [group 3]
end

HTH

Peter
Like Show 0 Likes(0)

Actions
5. Re: Switch parameters dynamically based on filter values

Vasu choudhury Nov 13, 2017 2:02 PM (in response to Peter Fakan)
Hi Peter,

I think i cannot group based on multiple field values. Please find the attached workbook for your reference.

Dashboard 1: By default i should see all these values(parameter 1) and is working as expected.
Dashboard 2: Expected results. When selected 2015-Q3, then it should display 2 values or trigger(2015-Q3 parm)

Which means that when 2015-Q3 is selected, then 2015-Q3 parm should be placed instead of parameter 1.
And this should happen in one dashboard.

Highly appreciated for any other work around.

-- Vasu.

Paramter_Values.twbx 288.9 KB
Like Show 0 Likes(0)

Actions
6. Re: Switch parameters dynamically based on filter values

Vasu choudhury Nov 15, 2017 8:32 AM (in response to Vasu choudhury)

Hello Experts,

Could you please let me know if any one has any other work around in addressing this functionality.

Regards,
Vasu.
Like Show 0 Likes(0)

Actions
7. Re: Switch parameters dynamically based on filter values

Norbert Maijoor Nov 15, 2017 10:11 AM (in response to Vasu choudhury)

Hi Vasu choudhury

I would like to ask my fellow ambassador Shinichiro Murakami to the table.
Shinichiro Murakami Could you think of an alternative approach on the directions already provided above.
Once again thanks for your valuable input.

Regards,
Norbert
Like Show 0 Likes(0)

Actions
8. Re: Switch parameters dynamically based on filter values

Shinichiro Murakami Nov 15, 2017 11:06 AM (in response to Norbert Maijoor)
I only know ridiculous approach on these request.

Change the field "Dummy" from "XXXXXX" to " " when you use.
I keep it "XXXX" to show the design background

Thanks,
Shin

Paramter_Values_SM_10.3.twbx 310.9 KB
Like Show 1 Likes(1)

Actions
9. Re: Switch parameters dynamically based on filter values

Norbert Maijoor Nov 15, 2017 11:52 AM (in response to Shinichiro Murakami)

Hi Shinichiro Murakami

Briljant:)) Once again thanks for your input:))

Regards,
Norbet
Like Show 0 Likes(0)

Actions
10. Re: Switch parameters dynamically based on filter values

Shinichiro Murakami Nov 15, 2017 12:42 PM (in response to Shinichiro Murakami)

Here is some explanations.

Re: Hiding a parameter control when an action filter is triggered

Thanks,
Shin
Like Show 0 Likes(0)

Actions
11. Re: Switch parameters dynamically based on filter values

Vasu choudhury Nov 16, 2017 3:04 PM (in response to Shinichiro Murakami)

Hello Shin,

That's a good work around to tell the story in a different way.(Business expectation is that to show in a single parameter based on Date/QTR selection which can't be done in Tableau)

However the values from Parameter1 are not driving to the Sheets 3&4 where as other parameter(2015-Q3 parm) does it.

Could you please help me in driving the Parm1 values to other sheets without breaking the other Param selections when selected.

Thanks,
Vasu.
Like Show 0 Likes(0)

Actions
12. Re: Switch parameters dynamically based on filter values

Shinichiro Murakami Nov 16, 2017 5:45 PM (in response to Vasu choudhury)

HI Vasu,

This?

==>

Could you mark my answer as correct to close the thread if you get expected result.

Shin
Like Show 0 Likes(0)

Actions
13. Re: Switch parameters dynamically based on filter values

Vasu choudhury Nov 16, 2017 8:17 PM (in response to Shinichiro Murakami)

Sure Shin, will mark it correct answer if the issue is resolved.

If we change 2015-Q3 param to Parameter 1, other parm selection values are breaking out.
i.e. Select 2015-Q3(Quarter of Order Date). Displays same data in sheet 3&4 for both values(Eligible, Non-Eligible) selected in 2015-Q3 param.

Note: Sheet 3&4 should drive by Quarter of Order Date , 2015-Q3 param & Parameter 1.

Thanks,
Vasu.
Like Show 0 Likes(0)

Actions
14. Re: Switch parameters dynamically based on filter values

Shinichiro Murakami Nov 16, 2017 10:53 PM (in response to Vasu choudhury)
Hi Vasu

Could you check attached file?

Filter category to "context" to LOD work.

Thanks,
Shin

Paramter_Values_SM_10.3_v2.twbx 310.7 KB
Like Show 0 Likes(0)

Actions