topic Re: remove 0 values row from table box in QlikView

remove 0 values row from table box

capriconuser — Mon, 19 Mar 2018 07:31:41 GMT

i have this script

Directory;

LOAD head,

subhead,

IsNull(amount) = 0 as amount,

IsNull(month) = 0 as month

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet2);

this shows like this

now here i want to remove these 0 values data from table beacuse i want when i export this table i dont want to these 0 values row data in excel

here i add last line through button .. on button i choose dynamic updated and write insert query so when i fill text boxes and click on add then record has been added and first two rows is coming from script beacuse test.xlsx is like this

head	subhead	amount	month
abc	abc1
def	def1

how i do this

i try to export from actions--external--export

Re: remove 0 values row from table box

Chanty4u — Mon, 19 Mar 2018 07:38:10 GMT

you can try this

num(PurgeChar(Replace(Ltrim(replace(Month,0,' ')),' ',0),'+')) as Month1;

num(PurgeChar(Replace(Ltrim(replace(Amount,0,' ')),' ',0),'+')) as Amount1;

Re: remove 0 values row from table box

MK_QSL — Mon, 19 Mar 2018 07:38:23 GMT

In stead of Table box, use straight table

Re: remove 0 values row from table box

capriconuser — Mon, 19 Mar 2018 07:41:05 GMT

i am using straight table and in straight table data looks fine but when i export the table value with 0 rows are also applied in excel sheet where as i dont want this in excel sheet

Re: remove 0 values row from table box

capriconuser — Mon, 19 Mar 2018 07:41:31 GMT

in script?

Re: remove 0 values row from table box

Chanty4u — Mon, 19 Mar 2018 07:43:17 GMT

yes in script.