topic Remove row from TableList in QlikView

Remove row from TableList

Thu, 26 Dec 2013 15:30:32 GMT

All,

I build a 'new sheet object' of type Table List. It is populated with data from Excel. Mistakenly, I am loading the last row, that is Total Revenue, and should be calculated separately but is not an item in the list.

Is it possible to remove an item from the list after the list is built ? On right click, it is possible to remove the whole object, but i cannot find how to eliminate one row.

Regards

Re: Remove row from TableList

Thu, 26 Dec 2013 16:01:55 GMT

Hello,

If you can attach the excel file will be much better but you can try a table list using an expresion and the expresion should be something like this:

If(MyField<>'Total', MyField)

If(Len(Trim(MyField))>0, MyField) // If the total row is null or is an space.

Best Regards.