topic Re: How can we insert row into table dynamically . in QlikView

How can we insert row into table dynamically .

Mon, 26 Jan 2026 18:19:17 GMT

I want to insert row in table dynamically.

My scenario is like that:

I have one table tabl1:

Date, field1, field2, filed3, count

02-12-2012, A , B , C, 200

02-12-2012, X , Y , Z, 300

03-12-2012, A , B , C, 400

04-12-2012, X , Y , Z , 500

05-12-2012, X ,Y , Z 600

02-12-2012, A , B , C, 600

Here we always consider 1^st date will always have all keys(field1& field1& field1). These all keys should be available for all date if it is not there then

we have to insert new row in table with same key and value for that date.

Here in this example date 02-12-2012 have two key ABC and XYZ .

Now we will move to next date(03-12-2012) and finding here we have only one key ABC and XYZ is missing.

So for this date we ll insert new row with previous date field value key.

In above table we ll insert one row like this for XYZ key.

03-12-2012, X ,Y , Z, 300

In the same way for date 04-12-2012 , we ll insert one more row like this:

04-12-2012, A ,B , C, 400

This process ll follow for each date.

Finally Output table ll be like this:

Date, field1, field2, filed3, count

02-12-2012, A , B , C, 200

02-12-2012, X , Y , Z, 300

03-12-2012, A ,B , C, 400

03-12-2012, X ,Y , Z, 300(newly added)

04-12-2012, X , Y , Z , 500

04-12-2012, A ,B , C, 400(newly added)

05-12-2012, X , Y , Z , 500

05-12-2012, A ,B , C, 400(newly added)

How to do this in QlikView script.

Thanks and Regards

Rahul Rao

Re: How can we insert row into table dynamically .

Thu, 20 Dec 2012 07:40:52 GMT

i think for this ,

firstly in your excel file write according to this, and by the use of input box you can insert row in table.

date	field1	field2
2/5/2012	2	8
2/5/2012	5	9
3/6/2012	6	4
3/6/2012	78	6
4/6/2012
10/12/2012

hope it will help you

Re: How can we insert row into table dynamically .

Thu, 20 Dec 2012 07:51:00 GMT

Hi Vishwaranjan

Thanks for reply!!!!,

But this i want to do in script itself since i have data in qvd.

Can we do this in script level?

Re: How can we insert row into table dynamically .

Thu, 20 Dec 2012 09:42:44 GMT

hi rahul

use inline function and add row dynamically

step1- now go to script then go to insert tab load statement--> from inline

then you must write the unique field name where you want to add the field values

example mat id data price

h101 a

h102 x

step 2-take a input box wthin it add two variables name = x

value= 20

Re: How can we insert row into table dynamically .

er_mohit — Thu, 20 Dec 2012 09:50:40 GMT

hey you can add fields value in script also.

using load * inline function.fot this go in edit script then insert tab and that go to load statement from inline

there's you add values but must be know that write the same field name which are you sing in database to make a key.. and then add values.

hope this will helps you....

Re: How can we insert row into table dynamically .

srinivas17 — Thu, 08 Jul 2021 09:53:33 GMT

Hi Rahul, Could you please let me know if you get solution for this. We also have the similar requirement and trying different solutions in qlik sense but could not get any working one, It will be grateful if you could provide some idea if it is solved .