# Expression using dataset

**URL:** <https://forum.inductiveautomation.com/t/expression-using-dataset/3850>\
**Category:** Ignition\
**Created:** [January 12, 2012, 3:40am UTC](https://forum.inductiveautomation.com/t/expression-using-dataset/3850 "2012-01-12T03:40:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joseph\_Mendonca](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\
**Post date:** [January 12, 2012, 3:40am UTC](https://forum.inductiveautomation.com/t/expression-using-dataset/3850/1 "2012-01-12T03:40:11Z")

</div>

Can’t get this to work. Equal will work but not \>= or \<=.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/ef99e818d4d1d85ed8a2792fc1bec6b9f61b9f37.png)

---

<div class="post-metadata">

**Author:** ![Joseph\_Mendonca](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\
**Post date:** [January 12, 2012, 5:23am UTC](https://forum.inductiveautomation.com/t/expression-using-dataset/3850/2 "2012-01-12T05:23:59Z")

</div>

had to use this to get it to work. Had to read the manual,yikes!

toInt({Root Container.dset}[{indirector}, “id”]) \>= 3

---

<div class="post-metadata">

**Author:** ![markdobtech](https://avatars.discourse-cdn.com/v4/letter/m/71e660/32.png) [@markdobtech](https://forum.inductiveautomation.com/u/markdobtech)\
**Post date:** [January 19, 2012, 4:18pm UTC](https://forum.inductiveautomation.com/t/expression-using-dataset/3850/3 "2012-01-19T16:18:36Z")

</div>

A couple of other ways to do it depending on what you are looking for.

Example 1: visible/not visible based on rows in table  
if({Root Container.dset.rowCount} \> 0,1,0)

Example 2: visible/not visible based on specific lookup  
in this case column “id” contains number ‘1’ in some row.  
if(lookup({Root Container.dset.data},1,0,“id”),1,0)

---

<div class="post-metadata">

**Author:** ![Joseph\_Mendonca](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\
**Post date:** [January 19, 2012, 7:42pm UTC](https://forum.inductiveautomation.com/t/expression-using-dataset/3850/4 "2012-01-19T19:42:47Z")

</div>

Fantastic! I will definitely implement example 2. Thanks