Can qlikview store input data and load from the output

[bharatkishore]

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

[bramkn]

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.

[Anil_Babu_Samineni]

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

[bharatkishore]

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.

[bharatkishore]

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.

[bramkn]

Load

A,

B,

30 AS C

from <Excel>

store into CSV

[bharatkishore]

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..

[bramkn]

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

[vitaliichupryna]

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

[chrismarlow]

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... - 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.