Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
francofiorillo
Partner - Creator
Partner - Creator

inputsum

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 RichiestaArticoloData Cons al ClientePrep NewSL NewFasc NewAss NewMIG New
03gen18CM45-337303/01/1828nov30nov04 dic06dic12dic
26gen18CM35-334426/01/1804gen05gen08 gen09gen11gen
02lug18CM35-339602/07/1811giu12giu13 giu14giu18giu
02lug18CM35-339702/07/1811giu12giu13 giu14giu18giu
16lug18CM35-339516/07/1825giu26giu27 giu28giu02lug

Another question.

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

4 Replies
petter
Partner - Champion III
Partner - Champion III

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

thomaslg_wq
Creator III
Creator III

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

sunny_talwar

The app is attached here

Inputsum_FF.qvw

francofiorillo
Partner - Creator
Partner - Creator
Author

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