topic Re: inputsum in QlikView

inputsum

francofiorillo — Fri, 05 Jan 2018 07:43:27 GMT

Hello.

I declared in the script a date field with inputfied.

I use this field in a linear table [inputsum (DataConsAgg)], to calculate other dates (Prep New, SL New, ..... MIG New)

it happens to me that, updating this date on a line, sometimes, the dates of the other rows are altered while I want the dates of each row to depend only on the date entered in the input field of that row. I can not understand when it happens and why.

maybe I do not use the function correctly or do I have to act in another way?

can you help me please ?

Data Consegna Richiesta	Articolo	Data Cons al Cliente	Prep New	SL New	Fasc New	Ass New	MIG New
03gen18	CM45-3373	03/01/18	28nov	30nov	04 dic	06dic	12dic
26gen18	CM35-3344	26/01/18	04gen	05gen	08 gen	09gen	11gen
02lug18	CM35-3396	02/07/18	11giu	12giu	13 giu	14giu	18giu
02lug18	CM35-3397	02/07/18	11giu	12giu	13 giu	14giu	18giu
16lug18	CM35-3395	16/07/18	25giu	26giu	27 giu	28giu	02lug

Another question.

can one use a calculated expression in another chart? If yes, how do you do it?

Re: inputsum

petter — Fri, 05 Jan 2018 09:37:10 GMT

It is easier to help you if you provide a sample application to us...

Re: inputsum

thomaslg_wq — Fri, 05 Jan 2018 09:48:31 GMT

Hi,

Make sure you create enough records for this input field, e.g. one for each potential row of your table.

A sample app, or your script could help.

Regards,

Thomas

Re: inputsum

sunny_talwar — Fri, 05 Jan 2018 12:43:32 GMT

The app is attached here

Inputsum_FF.qvw

Re: inputsum

francofiorillo — Fri, 16 Feb 2018 12:12:35 GMT

Hello.

I try to better specify my request for clarification.

in a pivot table I put an input field ("Data Cons to the Customer"). This expression field (inputsum (DataCondAgg) contains a date, and the dates on the right are adjusted for this date (Prep New, SL New, etc.).

The app works. But sometimes, and I can not understand when and how, changing a date in a row also incorrectly changes the date values on the other lines.

having no example of an Inputsum with a given field, I had the doubt that this function was not enabled for dates. I'm walking on a mistake.

could you kindly give me some help?

Thanks in advance