topic Re: Can qlikview store input data and load from the output in QlikView

Can qlikview store input data and load from the output

bharatkishore — Tue, 06 Nov 2018 07:04:19 GMT

Hi All,

I am not sure whether this is possible. Here is the scenario:

Firstly i have an excel with 3 fields.. Say A,B,C

Now In A i have data and B i have data and C is a column with no data.

Now in qlikview i want to give manual input to column C and i want that value to be stored in Column C.

Is this possible..

Thanks,

Bharat

Re: Can qlikview store input data and load from the output

bramkn — Tue, 06 Nov 2018 07:17:38 GMT

Qlikview cannot write into xls/xlsx files. But you can store into CSV with ";" delimiter which is easily opened in Excel.

EDIT: I am talking about native behaviour. If there is an other way to do this I am not aware of this.

Re: Can qlikview store input data and load from the output

Anil_Babu_Samineni — Tue, 06 Nov 2018 07:20:44 GMT

Let's say You excel having this

Sample:

Load *, 'Manual Data' as C Inline [

A, B, C

abc, def,

];

Now, If you want to load some value for C Column, You can define like above in Red part

Re: Can qlikview store input data and load from the output

bharatkishore — Tue, 06 Nov 2018 07:22:46 GMT

Hi Bram,

Thanks for the reply. Yes even CSV is also fine. But can you please tell me how can i store the value into dummy column.

I mean in front end i need to assign a value and it should be stored in the back end.

Say for Ex:

In script

load A,B,C from CSV;

After reloading output is like

A-10,

B-20,

C-Empty or Blank

now in front end i assigned a value for C..Say 30

Now this is value should be assigned to column C.

Output be like

A-10,

B-20,

C-30.

Please let me know if you need anything more.

Re: Can qlikview store input data and load from the output

bharatkishore — Tue, 06 Nov 2018 07:26:46 GMT

HI Anil,

Please see the below example..

In script

load A,B,C from CSV;

After reloading output is like

A-10,

B-20,

C-Empty or Blank

now in front end i assigned a value for C..Say 30

Now this is value should be assigned to column C.

Output be like

A-10,

B-20,

C-30.

Re: Can qlikview store input data and load from the output

bramkn — Tue, 06 Nov 2018 07:29:57 GMT

Load

30 AS C

from <Excel>

store into CSV

Re: Can qlikview store input data and load from the output

bharatkishore — Tue, 06 Nov 2018 07:33:18 GMT

Hi Bram,

Just for example i have given 30 number.. But only when i assign a value in front end then only it should get stored.

Value is not defined.. It can be any number..

Re: Can qlikview store input data and load from the output

bramkn — Tue, 06 Nov 2018 08:07:40 GMT

replace it with what ever logic you build in to get the 3rd column.

Re: Can qlikview store input data and load from the output

vitaliichupryna — Tue, 06 Nov 2018 10:35:23 GMT

Hi Bharat,

I've attached qvw with possible solution,

Idea is following:

1. Load dataset

2. Create Input object and variable (ex. vInput ) for future inputs

3. Create text table with variable vInput as a Calculated dimension and 1 as an expression

4. In the Macro editor create macro that will export data from text table object. For this you need put object id into Macro

5. Add button and add two actions for this button: Export table(macro) and Partial reload

6. In script add Load from file that will be created on step 4. In my opinion we should use ADD Load and concatenate our new table to source table.

7. STORE data from new table in the csv file.

BTW, in the example I use ID;C in the input field, so for test you should use 1;30 if you want to add value C=30 to id =1

Thanks,

Vitalii

Re: Can qlikview store input data and load from the output

chrismarlow — Tue, 06 Nov 2018 10:48:34 GMT

Bharat,

You can set a field to be an input field in script - https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/Inputfield.htm - this then facilitates overwriting in the front end.

In terms of storing the data back for use elsewhere I think that takes an extension (if you search for write back on the community you will get a lot of stuff). However you could take elements of Vitalli's suggestion depending on how the app will be used.

Cheers,

Chris.

Re: Can qlikview store input data and load from the output

bharatkishore — Tue, 06 Nov 2018 10:57:55 GMT

Thanks Vitalli.. Will check and let you know...

Re: Can qlikview store input data and load from the output

bharatkishore — Tue, 06 Nov 2018 10:58:05 GMT

Thanks Chris..

Re: Can qlikview store input data and load from the output

bharatkishore — Tue, 06 Nov 2018 11:10:04 GMT

If possible can you please send First and Details CSV files... So that it will be more helpful and get much more better understanding

Re: Can qlikview store input data and load from the output

vitaliichupryna — Tue, 06 Nov 2018 11:14:56 GMT

Sure,

Thanks,

Vitalii

Re: Can qlikview store input data and load from the output

bharatkishore — Tue, 06 Nov 2018 11:38:09 GMT

Thanks for the files. Let me be more clear so that it will be easy for you to understand:

Now say i have a input file with the below columns :

Now if you see in column test i need to add some value in front end.Say for example i have added 40..

Now once i enter and reload the file means i should get Test value as 40.

Hope i am clear .. Can you please tell me how to do this..

Re: Can qlikview store input data and load from the output

vitaliichupryna — Tue, 06 Nov 2018 12:20:00 GMT

Bharat,

You can use INPUTFIELD;

See attached example

Thanks,

Vitalii !