topic Re: Inputsum doesn't work after joining to another table? in QlikView

Inputsum doesn't work after joining to another table?

Wed, 25 Nov 2020 16:16:04 GMT

I've created a NewField and used INPUTFIELD in my script in a new table using Inline so that the user can control the values within the NewField, and then I need to join this new field to a table I already have. Problem is when I drop the Temp inline table, then I won't be able to use Inputsum in the front end for the user to input the values in my NewField, not sure how I can fix this?

MainTable is:

ID	Criteria	Step	Numbers per each step
2512	cri2	1	12
2874	cri3	2	11
3290	cri1	2	3
1249	cri1	3	4
2840	cri3	1	6
1295	cri2	1	7

And this is what I have, when I dont join, the Inputsum works, but after I join it doesnt.

INPUTFIELD NewField;

InputTable:

LOAD * INLINE [

ID, NewField

2512, 0

2874, 0

3290, 0

1249, 0

2840, 0

1295, 0

];

Join (MainTable)

Load *

Resident InputTable;

Drop Table InputTable;

Re: Inputsum doesn't work after joining to another table?

Tue, 14 Jun 2016 19:18:19 GMT

Actually, figured it out:

I have to reverse the join as below and it works

Join (InputTable)

Load *

Resident MainTable;

Drop Table MainTable;

So now my InputTable will be the main one

Re: Inputsum doesn't work after joining to another table?

sunny_talwar — Tue, 14 Jun 2016 19:18:48 GMT

Why don't you do like this instead of joining:

INPUTFIELD NewField;

MainTable:

LOAD *,

0 as NewField;

LOAD * INLINE [

ID, Criteria, Step, Numbers per each step

2512, cri2, 1, 12

2874, cri3, 2, 11

3290, cri1, 2, 3

1249, cri1, 3, 4

2840, cri3, 1, 6

1295, cri2, 1, 7

];

Re: Inputsum doesn't work after joining to another table?

sunny_talwar — Tue, 14 Jun 2016 19:19:28 GMT

I wonder why you are looking to join. Its all 0's that you are adding, isn't it?

Re: Inputsum doesn't work after joining to another table?

Tue, 14 Jun 2016 19:26:39 GMT

Well because I already have my MainTable coming from different scripts and files..Do you think it's best if I store my MainTable and then load it again, and with the NewField as 0?

Re: Inputsum doesn't work after joining to another table?

sunny_talwar — Tue, 14 Jun 2016 19:29:31 GMT

You mean that you are joining bunch of other tables to create MainTable? I guess, not really sure what you are doing to create MainTable, but another option is to leave InputTable as a separate table linked on the ID field.

Re: Inputsum doesn't work after joining to another table?

Tue, 14 Jun 2016 19:57:56 GMT

Yes, I need to have it joined to my MainTable because I want to be able to create charts based on the dimensions in the MainTable..

Re: Inputsum doesn't work after joining to another table?

sunny_talwar — Tue, 14 Jun 2016 20:01:56 GMT

You don't need to join just because you have to create a chart where dimension resides in MainTable. If the two tables are implicitly joined (without explicitly using join in the script), you would still be able to create a chart the same way if you join them

Re: Inputsum doesn't work after joining to another table?

sunny_talwar — Tue, 14 Jun 2016 20:13:57 GMT

See the data model where I have no joined the InputTable into MainTable and yet created a bar chart with Criteria as dimension and Sum(NewField) as expression

Re: Inputsum doesn't work after joining to another table?

Tue, 14 Jun 2016 21:16:28 GMT

hmm yes got it Sunny! Thanks very much

Now can the same happen when having three tables instead of two, and one common field (ID) between the three?

Re: Inputsum doesn't work after joining to another table?

sunny_talwar — Tue, 14 Jun 2016 22:41:13 GMT

It should still work the same way

Re: Inputsum doesn't work after joining to another table?

Wed, 15 Jun 2016 12:28:45 GMT

So I realized that I have to do the join because I want to do some calculations based on the new column and the other tables columns. If joining is not possible, I'll have to then do all of the calculations on the front end?

Re: Inputsum doesn't work after joining to another table?

sunny_talwar — Wed, 15 Jun 2016 12:34:32 GMT

Well InputField is given a value of 0, what calculation you want to do on the backend for a field which will receive value on the front end?

Re: Inputsum doesn't work after joining to another table?

Wed, 15 Jun 2016 12:44:11 GMT

Right, then I'll have to do the calculations on the front end Thanks:)