topic Re: InputSum question in QlikView

InputSum question

jduluc12 — Fri, 08 Sep 2017 12:20:33 GMT

Hi,

I am using

INPUTFIELD Field1

in my load script and using

inputSum([Field1]) in the my expression.

I am able to enter the values for Field1 in the pivot table.

But this value changes by itself when ever i filter the chart.

I want to keep the value of Field1 unchanged.

Is there any way to do it?

-Jean

Re: InputSum question

Anil_Babu_Samineni — Fri, 08 Sep 2017 12:24:47 GMT

Even, If i filter it's not changing the value. i am not sure, Whether this is version issue or something.. If not, Please update work file

Re: InputSum question

jduluc12 — Fri, 08 Sep 2017 12:34:07 GMT

I think you are right

i was using

inputsum(Field1, '*')

Re: InputSum question

Anil_Babu_Samineni — Fri, 08 Sep 2017 12:34:51 GMT

* won't consider here. Use InputSum(Field1)

Re: InputSum question

jduluc12 — Fri, 08 Sep 2017 12:48:41 GMT

in fact, i will take my word back.

it is still changing.

it changes like this

suppose the initial value is 15 and this is how the table looks like

sales Field1 sales*(Field1/100)

1091753.25 15 163762.99

And then i select some filter like date which makes sales as 26643.32

then the value of Field1 changes to 10.38

I want it to be 15 always.

Re: InputSum question

Anil_Babu_Samineni — Fri, 08 Sep 2017 12:53:05 GMT

May be share application or images atleast. Before change and after change with filter?

Re: InputSum question

jduluc12 — Fri, 08 Sep 2017 13:02:06 GMT

Before

after date selection

The load script looks like

INPUTFIELD [Commission Rate]

and it is loaded as

0 as [Commission Rate], RowNo() as key

I added RowNo() because it was giving me "Duplicate keys when loading input field"

Re: InputSum question

Anil_Babu_Samineni — Fri, 08 Sep 2017 13:06:23 GMT

Is this is simple, please post sample application

what if we are using this? InputSum({1}Sales) // Sales you need to change?