topic Re: Table Box in QlikView

Table Box

siddheshmane — Tue, 26 May 2015 10:57:18 GMT

HI,

What if I want to delete a whole row from table box if a certain condition is met.

Here I have 3 columns in a tablebox EmployeeID, ProductName, ShipmentDate.

Like: If ( IsNULL(ShipmentDate) )

{

// display the row in the Table box

}

If ( Not IsNULL(ShipmentDate) )

{

// remove or Hide the row from the Table box

}

Thanks.

Re: Table Box

Joaquin_Lazaro — Tue, 26 May 2015 11:02:45 GMT

HI siddheshmane :

You should creare an auxiliar table in the script

LOAD *

Where IsNull(ShipmentDate)

Hope this helps you

Joaquín

Re: Table Box

jonathandienst — Tue, 26 May 2015 11:19:49 GMT

You can't use conditions and expressions in a table box. You would need to do this in a straight table.

Each expression should include the If(IsNull(ShipmentDate), <your first expression>) and then ensure the option to suppress nulls is enabled. This assumes that ShipmentDate has only one possible value (including NULL) for each combination of the dimensions.

Re: Table Box

siddheshmane — Sat, 30 May 2015 05:50:33 GMT

Hi,

I got the answer what I was looking for. I just had to write this condition

IF(Len(Trim(FIELD_NAME) = 0, FIELD_NAME).