# Case on property expression

**URL:** <https://forum.inductiveautomation.com/t/case-on-property-expression/35475>\
**Category:** Ignition\
**Created:** [June 9, 2020, 10:28pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475 "2020-06-09T22:28:25Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [June 9, 2020, 10:28pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/1 "2020-06-09T22:28:25Z")

</div>

hello

I have a drop-down list and an LED screen I also have 3 labels and I want that when I select a data from my list I will put the data of the label inside the LED screen

for this I am using a CASE as an expression inside the LED Display but it only shows me the -1

can you help me with my CASE

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/ab1a0a6b24ef93dd8b491a352029e3f7750252c3.png)

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [June 9, 2020, 10:51pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/2 "2020-06-09T22:51:40Z")

</div>

Looks fine to me. Can you screenshot your dataset table data?

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [June 10, 2020, 1:20pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/3 "2020-06-10T13:20:04Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f777e416671eaa2ceeae9506899e44e144240cdd.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 10, 2020, 2:09pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/4 "2020-06-10T14:09:50Z")

</div>

Is there any change your dataset content is space-padded? That will mess up comparisons.

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [June 10, 2020, 3:07pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/5 "2020-06-10T15:07:11Z")

</div>

I don’t see anything irregular

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/bc7c9cf407d393027a4a4f0894768554e2a58970.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e6f7e6fea5577e826b9dafc9a1f07ce6f04fe3ae.png)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [June 10, 2020, 3:19pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/6 "2020-06-10T15:19:01Z")

</div>

Is there any whitespace after the entry in the dataset (for example: 'Linea\_Disco ')?

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [June 10, 2020, 7:13pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/7 "2020-06-10T19:13:41Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c8b2158d9dd70ab8c2a221b67aeb90a8d953dd06.png)

how to remove the space

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [June 10, 2020, 9:08pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/8 "2020-06-10T21:08:06Z")

</div>

That space padding will be coming from the dataset. Remove it from the dataset

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [June 11, 2020, 12:33pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/9 "2020-06-11T12:33:45Z")

</div>

> [@nminchin](#):
>
> Remove it from the dataset

Alternatively, use trim() in the expression. (At least, I think you should have trim() available, since you're using case() )

`trim({Root Container.Dropdown.selectedStringValue})`

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [June 11, 2020, 12:42pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/10 "2020-06-11T12:42:39Z")

</div>

Better to use trim in the SQL query on the dataset’s binding, or RTRIM(LTRIM(…)) combo for MS SQL. I didn’t actually realise (didn’t look) that the data property was a binding. (Presumably it comes from a SQL query?)

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [June 11, 2020, 3:27pm UTC](https://forum.inductiveautomation.com/t/case-on-property-expression/35475/11 "2020-06-11T15:27:21Z")

</div>

thanks @nminchin this is the solution
