Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_Babu_Samineni

INSERT is Not Working for Inline

Dear Friends,

I have one inline table like below

Company:

LOAD * INLINE [

    EmpName, Sal

    A, 1000

    B, 2000

    C, 3000

];

I want to add one more row with the Name of D and D salary is 4000.

So, here i am not fetching the data from DB. I am using just inline.

Can anyone help me Logic

SQL INSERT INTO Company(EmpName,Sal) Values ('D',4000);

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
18 Replies
amit_saini
Master III
Master III

This might help u:

https://community.qlik.com/docs/DOC-7373

Thanks,
AS

ramasaisaksoft

Hi Anil,

insert into statement is useful in SQl only,That is a syntax  need to follow in sql.

else

may be the below links will help to you.

Can we insert data or records from qlikview to Database

Inserting data into a database

Anil_Babu_Samineni
Author

Yes, I am expecting similar tooo.

1) If i add one more data then i want to effect DB also, Is that possible. Is there any connector from Qlik to DB.

2) If not possible, How do we acheive this

3) If possible, Please send me which connector i need to maintan / Install

4) If we are maintain Inline, how to update using above link. As Rodorf we can do, but client asking me why you want to connect every time to DB. Just check is there any chance to DML/DDL operation in Qlik also?

- ANIL

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Digvijay_Singh

Hi,

The Core use of Qlikview is to analyse data and help management to take corrective and preventive decisions. Here you are indicating that your data needs frequent changes. The standard way is to do it through script changes or changes in the source system.

When 100 employees joined then surely your transaction system must also change, same is the case when salary is updated, so automatically in next reload the updated data will be loaded in Qlikview or you would need some tweak in script to accomodate new structural changes.

If you try to use Qlikview as your main data repository then you will face many troubles while maintaining it as Qlikview is not made for this purpose.

Thanks and Regards,

Digvijay

Anil_Babu_Samineni
Author

Thanks, Here you mean to say - If we want to update / insert / delete everything happen from DB only, Right? We can't do that operations in Qlik(As i understand). In the below, Sai shared two links in that first link some one replied that, It is possible using macro / Connector. If not possible let me know. If possible, Please give me a solution?

- Thanks

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tyagishaila
Specialist
Specialist

LOAD * INLINE [

    EmpName, Sal

    A, 1000

    B, 2000

    C, 3000

];

Concatenate

LOAD * INLINE [

    EmpName, Sal

    D, 100

    B, 200

    C, 3000

];

OR

LOAD * INLINE [

    EmpName, Sal

    D, 100

    B, 200

    C, 3000

];

Concatenate

Load * from Company.qvd

where not Exists(EmpName);    // It is optional depends upon your requirement.

Digvijay_Singh

You can use dynamic update( See in button action), also shared in one of the link here to update data loaded in Qlikview but it won't update your DB, so after reload you need to run the action every time. Also I don't think you can do mass update through this in smooth way. I suggest you make updates in your source system and use join/concat etc in your script to reload them in Qlikview.

Anil_Babu_Samineni
Author

Yes, I will follow that. But, While reporting the report was not the correct if we follow this.

Might be the best option is DB only. As i understand from this Thread, If we update anything, The DB is not possible with Updated Data. If we updated the data from DB it is possible and reports also Good.

Thanks My all Supporters.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
amit_saini
Master III
Master III

Yes for data update or insert ...QlikView is not the best option.

Thanks,

AS