topic Re: How to update a report without reload? in QlikView

How to update a report without reload?

Fri, 05 Dec 2014 03:38:16 GMT

Hi, all

As the title, i want to modify a comment with a input box, and then, i want to update this comment into a table without reload. Please help and thanks advanced

BR/Ting

Re: How to update a report without reload?

girish_talele — Fri, 05 Dec 2014 04:47:21 GMT

"update this comment into a table"

which table? In Resident Table?

I think it is not possible. You need to re-load the qvw.

Re: How to update a report without reload?

Fri, 05 Dec 2014 05:09:11 GMT

Thanks for the reply. In resident table. for example: a resident list-box. I had saw a example which can write memory without reload. It can add or delete or modify a row through button. I think it is useful to me. But i don't know how to do. Do you have any idea?

Re: Re: How to update a report without reload?

girish_talele — Fri, 05 Dec 2014 05:20:19 GMT

Your requirement is not clear.

Refer below example, Is this what you want or upload your qvw.

Re: How to update a report without reload?

Fri, 05 Dec 2014 05:31:57 GMT

Wow, it's really useful to me. thank you so much.

Re: Re: How to update a report without reload?

girish_talele — Fri, 05 Dec 2014 05:40:00 GMT

Thanks,

Please mark the reply as correct answer if your query is resolved.

Re: How to update a report without reload?

Fri, 05 Dec 2014 05:57:38 GMT

have been marked. And if you know how to write back to memory?

Re: How to update a report without reload?

Fri, 05 Dec 2014 05:57:42 GMT

Dear Wanting,

This is possible, but its tricky to be used to update a row based database or a QVD file. But using the Input box from Girish's example and a Macro to reload the dashboard, this can be stored back as a QVD at server/machine and reused. A load stated combined by referring to the individual variables updated using the input box could solve this. But this could end up to have many unique variable, 1 per column if seen from a data file point of view

But the reload from browser part might be tricky as this involves Macro and EDX.

Thanks

Ram

Re: How to update a report without reload?

Fri, 05 Dec 2014 06:17:38 GMT

Dear Ram,

Thanks for the reply.I just want to know for example: how to use macro add(or delete or modify) a row in a resident list-box

In fact, my english is poor, Forgive me

BR/Ting

Re: How to update a report without reload?

girish_talele — Fri, 05 Dec 2014 06:17:46 GMT

Very true Ramanan,

As given in example, variable "vScriptVariable" can be fetched in any table while reloading.

But as you correctly said use can enter any value, This can be addressed with Listing pre-defined values Drop Down.

But updating table without reload will be issue.

Re: How to update a report without reload?

girish_talele — Fri, 05 Dec 2014 06:25:05 GMT

Dear Wanting,

Can you give some example/data to understand it better.

Re: How to update a report without reload?

Fri, 05 Dec 2014 06:36:56 GMT

Dear Girish

There is a example document but not a qvw file. And unfortunately it's in chinese. please give me some time to translate it and then share.

BR/Ting

Re: How to update a report without reload?

Fri, 05 Dec 2014 06:46:46 GMT

Dear Girish,

Agreed.

Dear Wanting,

No worries on the language, this is a global community.

I think I kinda get what you want to do here, please refer the screenshot below and study more in F1 on how this works,

Step 1 : define "input fields"

Define before your load statement

Step 2 :

Call the entire table in a table box object in front end

The small blue arrow box you see in "mission" means its editable. Like i said before, this requires no variable. You load a qvd, and display the entire qvd in a table and update any column u want.

Step 3 :

Write a macro to reload using EDX (am not covering this here as its a whole new chapter by itself). There are many existing post on this in the community. Kindly search. The blue botton above does exactly tat, it flushes and reloaded the QVD with the new updated fields.

This works in access point in Internet Explorer only. With IE PLUGIN only

Other experts, any comments ?

Thanks

Ram

Re: How to update a report without reload?

Fri, 05 Dec 2014 06:54:35 GMT

Re: How to update a report without reload?

Fri, 05 Dec 2014 07:27:51 GMT

Dear Ram

I have done it as you said. It's so nice of you.But in step3, if i want to write the result back to database. How to do?

Did you define the macro yet. If yes, could you please share the Macro script?

BR/Ting

Re: How to update a report without reload?

Fri, 05 Dec 2014 07:33:28 GMT

Dear Girish

I think if we can write back the result which we modified into data-source. It will be perfect without issue. What do you think?

BR/Ting

Re: How to update a report without reload?

Fri, 05 Dec 2014 07:49:07 GMT

Dear Wangting,

Here you go, hope you can make it work. Adjust according to your app.

strSQL="insert into QV_input (Mission) values ('"&vtesting&"')"

'strSQL="insert into QV_input values ('sa')"

'Begin Transaction

objADO.BeginTrans

'Execute Transaction

objADO.Execute strSQL, iAffected

objADO.CommitTrans

objADO.Close

'Msgbox(Comment updated)

End Sub

Sub Write_back

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "D:\Shared\HEC Renwals\Backup\OLD\Test on Upload\DataSource\Test.qvd", 4

'obj.ExportEx "D:\tempww.xls", 6

End Sub

Re: Re: How to update a report without reload?

Mon, 08 Dec 2014 07:40:05 GMT

Dear Girish

I got it. Below is the file. But i don't know how to attach the qvw file. Could you please teach me.

BR/Ting

Re: Re: Re: How to update a report without reload?

girish_talele — Mon, 08 Dec 2014 07:46:57 GMT

Hi Wangting,

click on the link (Top Right)-

Use advanced editor

then click on "Attach" link (Bottom Right)

Regards,

Girish.

Re: Re: Re: Re: How to update a report without reload?

Mon, 08 Dec 2014 09:15:13 GMT

Dear Girish

I got it, thanks

BR/Ting