topic Re: Inputsum() functionality in QlikView

Inputsum() functionality

punitpopli — Wed, 28 Sep 2016 06:16:03 GMT

Hi,

I came across Inputsum() and had collected details on the same via Qlik Help, community link and a blog‌, but still curious to know the exact functionality of the function in terms of storing the user entered values.

For e.g. :

Prerequisites of InputSum() : We have to define these fields in the script using InputField command and syntax is as below(refer community link above) :

INPUTFIELD Budget1, Budget2, Budget3, Budget4, Budget5, Budget6, Budget7;

Table:

LOAD * Inline [

Dim1, Dim2, Budget1, Budget2, Budget3, Budget4, Budget5, Budget6, Budget7

A, AA, 0, 0, 0, 0, 0, 0, 0

A, CC, 0, 0, 0, 0, 0, 0, 0

B, AA, 0, 0, 0, 0, 0, 0, 0

B, CC, 0, 0, 0, 0, 0, 0, 0

];

Lets consider the Capital Allocation tab on Credit Risk Analysis demo app from Qlik where we have pivot table and the values of PD column can be changed i.e. user input.

Below are certain doubts on the implementation/use of Inputsum()

Apart from defining the fields for Inputsum() in scripts, do we have to make any other changes?
Where the user input value get saved (according to my understanding it get saved in RAM)?
Will these values be in RAM till the server get reboot or my session expires?

Please share your valuable comments on above and let me know if anything which I had missed to mention here

Regards,

Punit

Re: Inputsum() functionality

tresB — Wed, 28 Sep 2016 06:39:36 GMT

I guess,

Apart from defining the fields for Inputsum() in scripts, do we have to make any other changes? - No
Where the user input value get saved (according to my understanding it get saved in RAM)? - RAM
Will these values be in RAM till the server get reboot or my session expires? - Since this is user-application specific, the values should be be cleared off once the session is over.

Re: Inputsum() functionality

Anil_Babu_Samineni — Wed, 28 Sep 2016 06:51:31 GMT

Tresesco, I do have one doubt. Still confusing here

With InputField

Table:

LOAD * Inline [

Dim1, Dim2, Budget1, Budget2, Budget3, Budget4, Budget5, Budget6, Budget7

A, AA, 0, 0, 0, 0, 0, 0, 0

A, CC, 0, 0, 0, 0, 0, 0, 0

B, AA, 0, 0, 0, 0, 0, 0, 0

B, CC, 0, 0, 0, 0, 0, 0, 0

];

We will get same o/p if we are not using the inputfield, what is the main use of this in Real time. Not the theoritical.please help me

Re: Inputsum() functionality

punitpopli — Wed, 28 Sep 2016 09:02:12 GMT

The script you mention had only the default values and when we use Distribution modes i.e. +,*,=,/ the values of these Budget fields will get changed.

Yes, will get same output if we don't mention the budget fields as inputfield and Inputsum() will also not work for user input values and will get an error as below :

For e.g. : The sheet i had shared above from Qlik demo where PD column has 6% against value 1, 8% against value 2 and so on.

As the expression is defined using Inputsum() it will accept the user values and data across the dashboard will get changed and data i.e. user input values get flushed when session expires(as per Tresesco, in above)

Hope this helps