topic Re: QVD load with Input Field in QlikView

QVD load with Input Field

Fri, 09 Oct 2015 12:04:52 GMT

Problem Statement :

I have few fields which were converted to inputfield in script before Load statement. On first time Load of data input functionaliy works fine but as soon as the QVD is updated and data is reloaded in the application the input fields does not show the updated data.

It would be really great if you please help me in this regard.

Re: QVD load with Input Field

marcus_sommer — Fri, 09 Oct 2015 12:20:38 GMT

Maybe you droped those fields at first, then new assign them as input fields and then the qvd-loading.

- Marcus

Re: QVD load with Input Field

NareshGuntur — Fri, 09 Oct 2015 12:33:52 GMT

Input values will hold values according to the user. Any user can update the value of an input field. The field values changes accordingly and different users may see different values as what they have entered.

So, Input values functionality is only to hold values during that time and are expected to change after the reload as the values will not get stored in any of the QVDs or data sources. So, upon reload, input fields will lose the updated data through front end.

Cheers,

Naresh

Re: QVD load with Input Field

Fri, 09 Oct 2015 12:38:05 GMT

Currently application is in unit testing phase and only I am viewing / using it

Re: QVD load with Input Field

sudeepkm — Fri, 09 Oct 2015 12:46:46 GMT

Naresh is right the input field data would be user session specific (from UI). Have you checked if the user session is reset or closed properly.

Re: QVD load with Input Field

Fri, 09 Oct 2015 12:47:43 GMT

Will check the way you mentioned and will confirm if it resolves my issue

Re: QVD load with Input Field

Anonymous — Fri, 09 Oct 2015 12:50:35 GMT

Hi Ankur,

Please check below post:

Qlikview Table - Input fields

Re: QVD load with Input Field

NareshGuntur — Fri, 09 Oct 2015 12:50:48 GMT

Hi Ankur,

Even if some user changes the values, those'll be user specific and the other users will not be able to see that. What is exact requirement that led you to use Input Values?

Cheers,

Naresh

Re: QVD load with Input Field

Fri, 09 Oct 2015 12:51:37 GMT

Hi Sudeep,

I have checked it. Since its opened using my Id only there does not exist a case mentioned by Naresh. However, while rolling it out for wide audience I will keep Naresh's point in mind.

Re: QVD load with Input Field

Fri, 09 Oct 2015 12:56:22 GMT

Requirement is while reviewing the representative level report corresponding district heads can correct / change the sales figures at run time (they will be able to view only their team's data so there is no point where a district head can change other district's value).

Re: QVD load with Input Field

NareshGuntur — Fri, 09 Oct 2015 12:59:30 GMT

The scenario which you want something similar to writing back to database. This can't be done using INPUT Fields.

Cheers,

Naresh

Re: QVD load with Input Field

Tue, 13 Oct 2015 05:00:41 GMT

Hi Naresh,

It would be great if you can suggest some way to achieve this

Re: QVD load with Input Field

Tue, 13 Oct 2015 05:01:30 GMT

Thanks for sharing but I am not sure whether it will resolve my issue. I will try and will revert...

Re: QVD load with Input Field

Tue, 13 Oct 2015 07:14:28 GMT

Followed the way mentioned in Store Inputfield table data to QVD with button macro and was able to store data back in QVD.

Thanks all for your help

Re: QVD load with Input Field

SreeniJD — Wed, 14 Oct 2015 08:02:35 GMT

Please refer Jop Moekotte's‌ and SAKHAN1986‌ comments on Create and Save data in Qlikview

Hope this will help

Re: QVD load with Input Field

Wed, 14 Oct 2015 08:06:37 GMT

Hi Jd Sreeni

Thanks for sharing this post of Jop Moekotte and Shoaib Ahmed of creating and saving data in Qlikview. Following this approach the performance has also improved slightly than my last fix. This seems to be acceptable solution as of now. Therefore Marking it correct too..

Thanks to You and original creator of this post Shoaib Ahmed and Jop Moekotte

Regards

Ankur