topic Re: Appending Rows to existing table in QlikView

Appending Rows to existing table

Shiva123 — Thu, 31 May 2018 16:42:00 GMT

hello,

everyone i am trying to append a dummy row to the existing straight table, that dummy row has a dollar amount which is the only expression. The dummy row is from another source table, where as straight table data source is from another table . is that possible to add a dummy row to the table .

thanks

Shiva

Re: Appending Rows to existing table

vishsaggi — Thu, 31 May 2018 16:54:20 GMT

Can you show us what your expected output is?

Re: Appending Rows to existing table

Shiva123 — Thu, 31 May 2018 22:09:37 GMT

attached is the app, below main straight table, there is another table which has to be added to the straight table below the totals line .

the main link for this is PAL 3 that is the common thing. we are appending because to show the difference in dollars with rebates and without rebates . i have tried, but they come as columns only but not as rows

thanks in advance

Shiva

Re: Appending Rows to existing table

vishsaggi — Fri, 01 Jun 2018 02:44:11 GMT

I will look into this tomorrow.

Re: Appending Rows to existing table

Shiva123 — Mon, 04 Jun 2018 16:20:34 GMT

any idea vishsaggi‌

Re: Appending Rows to existing table

Shiva123 — Mon, 04 Jun 2018 21:19:53 GMT

do u have any idea about this stalwar1‌

Re: Appending Rows to existing table

vishsaggi — Tue, 05 Jun 2018 18:35:00 GMT

Sorry for delay in replying was pretty occupied. So what could be your dimension values in that first row for your Net Dollar value. IN your straight table i mean?

Re: Appending Rows to existing table

Shiva123 — Tue, 05 Jun 2018 19:03:25 GMT

the dimension value stays the same , it can be blank or dummy value can be added . the new row should be below

the total value of net amount .

thank you again

Re: Appending Rows to existing table

vishsaggi — Tue, 05 Jun 2018 21:39:58 GMT

The only way i think is using Pick(Dim()) . Create an inline Dim table like

Dim:

LOAD * INLINE [

Dim

];

After you run your file with this just upload again so we can try.

Re: Appending Rows to existing table

Shiva123 — Thu, 07 Jun 2018 00:01:06 GMT

there is already inline in the script with dimension in the last tab .

thanks

Shiva