Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
I have the following fields / columns from which my data should be loaded into List Boxes
Check & Answer
Now under Check there are several values e.g Instrucions, Shift, Shfit Date, Plant etc.
I want the List Box to only show certain details
e.g under Plant the Answer can be Plant 1, Plant 2 and Plant 3
The List Box should only display
Plant 1
Plant 2
Plant 3
and not all of the answers associated with all checks?
How can I do this?
Your help will be appreciated!
Thanks
you are saying that you want to show certain value in the list box, but based on what you will decide which values you will show or not?
if you only want to limit your choices you can do that in some charts using the dimension limits tab, however with the list box you need to do it using a calculated dimension where you will specify what values you want to show/hide.
Thanks for replying, I basically want the List Box to show Plant 1, Plant 2, Plant 3, Plant 4, Plant 5. And it this is all that it must show, wheter you click it or not.
And could you please give an example of a calculated dimension?
Thanks!
Below how my current list box looks like, I just want all the plants to show not the other values as well
Hi
Try the following:
You could also do this in the script (which is actually preferable) by using the same syntax as above:
Below is an example of a calculated dimension, as you can see i have added an if statement that will filter only for the Region 'South' in your case the Plant.
However it is not recommended to use calculated dimension in objects and it is preferred that you do it in the script, in your case i would consider reviewing my schema and maybe placing the Plan in a separate column.
hi check
the attach example