Page 1 of 1
Conditional Pick Lists
Posted: Thu Mar 07, 2024 4:59 pm
by KaneHenderson
Hi,
I was wondering if it is feasible to have a dynamic picklist selection based on another picklist cell.
For example, if we have a picklist that has x / y / z and another picklist containing a / b / c / d / e. I'm looking to form a relationship between the two as follows:
IF Picklist 1 is X then picklist 2 would have a / b
IF Picklist 1 is Y then picklist 2 would have c and
IF Picklist 1 is Z then d / e
I'm trying to do this to avoid incorrect data mappings, rather than having Picklist 2 having a / b / c / d / e.
Thanks in advance for any support!
Re: Conditional Pick Lists
Posted: Thu Mar 07, 2024 5:31 pm
by Wim Gielis
Hello
Did you try Google on:
TM1 dependent picklists
Re: Conditional Pick Lists
Posted: Fri Mar 08, 2024 2:51 pm
by KaneHenderson
Hi Wim,
Thank you for this. It really helped me to understand more about using picklist control cubes.
I've wrote this rule for one of my picklists:
['Tableau Sub-Function Level 1']=S:IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='EXECUTIVE','subset: 018 Main - Sub-Functions: EXECUTIVE Function',
IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='FACILITIES','subset: 018 Main - Sub-Functions: FACILITIES Function',
IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='FINANCE','subset: 018 Main - Sub-Functions: FINANCE Function',CONTINUE)));
It quite bizarrely works for some lines in my log, but not others. For example:
Where Tableau Function is EXECUTIVE, the picklist populates on line 10 of my log
Where Tableau Function is EXECUTIVE, the picklist doesn't populate and remains as a string data entry value, almost as if the rule doesn't hit the cell.
Re: Conditional Pick Lists
Posted: Fri Mar 08, 2024 5:30 pm
by Wim Gielis
KaneHenderson wrote: ↑Fri Mar 08, 2024 2:51 pm
Hi Wim,
Thank you for this. It really helped me to understand more about using picklist control cubes.
I've wrote this rule for one of my picklists:
['Tableau Sub-Function Level 1']=S:IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='EXECUTIVE','subset: 018 Main - Sub-Functions: EXECUTIVE Function',
IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='FACILITIES','subset: 018 Main - Sub-Functions: FACILITIES Function',
IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function')@='FINANCE','subset: 018 Main - Sub-Functions: FINANCE Function',CONTINUE)));
It quite bizarrely works for some lines in my log, but not others. For example:
Where Tableau Function is EXECUTIVE, the picklist populates on line 10 of my log
Where Tableau Function is EXECUTIVE, the picklist doesn't populate and remains as a string data entry value, almost as if the rule doesn't hit the cell.
Hello
Please make sure that all subsets exist, as public subsets in the respective dimensions.
They can be static or dynamic, doesn’t matter.
It’s a bit odd that sometimes you use no spaces, sometimes you use 2 spaces in front of a dash, …
I don’t put a space after the colon in the picklist definition but probably it will work too with a space.