Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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