Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

prathapreddyt
New Contributor

how to insert new data from input box to a inline table

Hi ,

Cam any one explain me how to insert new data from input box to a inline table

Example :

i have a inline table like

LOAD * Inline [

EmpID,EmpName,Sal

1,XXX,1000

2,YYY,2000];

I need to insert new row 3, zzz,3000 from front end using 3 input boxs(EmpID,EmpName,Sal).

Please help me to solve this scenario.

Thanks,

Prathap

2 Replies
amayuresh
Contributor III

Re: how to insert new data from input box to a inline table

Try this, I have table with two field Country, Population

Script:

if $(vFlag)=1 then

LOAD * INLINE

[

Country, Population

USA, 100

India, 200

UK, 200

Australia, 300

Canada, 100

];

Concatenate

Load * Inline

[Country, Population

$(vCountry), $(vPop)];

ELSE

LOAD * INLINE

[

Country, Population

USA, 100

India, 200

UK, 200

Australia, 300

Canada, 100

];

ENDif

UI:

1.PNG

Steps:

1. Initially set vFlag=0

2. Action on Add Button as

     1. Set Variable vFlag=1

     2. Reload

Re: how to insert new data from input box to a inline table

Qlikview is not a data entry application. So I recommend using it as such. If you think you know better then you can try the Dynamic Update feature. See this document for more information: Dynamic Update - Simple Database


talk is cheap, supply exceeds demand
Community Browser