topic Re: Create/Append new record via Expression in QlikView

Create/Append new record via Expression

Anonymous — Fri, 11 Mar 2016 18:43:59 GMT

Hi All,

Is it possible to create/append new record derived from Expression? What I want is a new set of record from below table. For Example: column Total is derived from Value1 + Value2. I want create/append this new set of record for Company ABC with "Date" and "Total" columns to existing data.

Company	Date	Value1	Value2	Total
ABC	2/29/2016	1	2	3
DEF	3/1/2016	2	3	5
XYZ	3/2/2016	3	4	7

Many Thanks,

Frank

Re: Create/Append new record via Expression

Digvijay_Singh — Fri, 11 Mar 2016 19:06:17 GMT

Do you mean existing table contains Company,Value1 and Value2 and you want to add new columns Date and Total?

If this is the case then you need new information Company(will act as join key),Date at least to join with existing data in script, Total can be calculated from existing fields.

Re: Create/Append new record via Expression

Anonymous — Fri, 11 Mar 2016 19:53:24 GMT

Yes, only Company and I have Value1 and Value2 are input values by user where it will generate a Total value and Date.

So It have to be done via script? I need to reuse this Date and Total value for my XIRR calc. Is there any chance this can store in memory where I can reuse?

Many Thanks

Re: Create/Append new record via Expression

Digvijay_Singh — Sat, 12 Mar 2016 02:59:34 GMT

It seems you are trying to save information in data model from front-end Qlikview application. Not a usual practice but you can check if dynamic update can help you in this. But keep in mind, it will not survive new reload I think.

Dynamic Update - Using Actions

Re: Create/Append new record via Expression

Digvijay_Singh — Sat, 12 Mar 2016 09:30:09 GMT

See the sample, if you click on button, it will save values in data model for date and Total from variable expression. I kept Total and Date fields in data model with empty values.

Re: Create/Append new record via Expression

Anonymous — Mon, 14 Mar 2016 21:25:53 GMT

Thank you! I really appreciate your help. I will give it a shot and hope this will solve my problem.