topic Create an Condition into a Table Box in QlikView

Create an Condition into a Table Box

Anonymous — Thu, 16 Jun 2016 13:17:38 GMT

Hello,

I would like to display into a Table Box only data where the dimension named 'FTE' is > 0:

How can i manage that please ?

Thanks you in advance for your help,

Sébastien.

marcus_sommer — Thu, 16 Jun 2016 13:19:51 GMT

Within a tablebox are no calculations or conditions possible but you could instead use a straight-table which offers these features.

- Marcus

sunny_talwar — Thu, 16 Jun 2016 13:20:46 GMT

You can try like this in the script:

If(FTE > 0, 1) as Flag

and then add Flag as one of the field in your table box and on the presentation tab check 'Omit When Value Is Null' option for Flag field.

Alternatively, you can use a straight table instead of a table box

Anonymous — Thu, 16 Jun 2016 13:22:37 GMT

Thank you !

Anonymous — Thu, 16 Jun 2016 13:23:29 GMT

I do not think so that it would be possible in Table Box...

You can do in Straight or Pivot table for sure..