Need help On InputField Functionality

[#1]

Hi All,

I have a requirement on what-if analysis which we have implemented using QlikView InputField functionality.

The below Image is showing the final output format of the requirement.

InSales and To Sales rows should be Input lines and EndSales should be output line.

The caluclation involved in EndSales is Previous Month EndSales + ToSales - InSales.

So when Ever I change either InSales or ToSales my EndSales should change, which I am able to achieve.

If I change my InSales in March the resultant EndSales of March will change but April EndSales should also change as it depends on March EndSales,

MayEndSales should also change as it depends on April EndSales and so on all the month EndSales should change which I am not able to achieve.

Please help to achieve the logic in Qlikview.

This requirement is possible in Excel as excel points to the cell, I have attached the sample excel report for functionality proof.

Thanks & Best Regards

Swetha

[jagan]

Hi Swetha,

Can you attach the sample file.

Regards,

Jagan.

[preminqlik]

hi there,

find attachment.hope this helps you ...

send me sample application ,try chesta....

Regards

Premhas

[tmumaw]

Hi Premhas,

Need your help.  How did you set the vPrice, vCost and vQuanity?  I don't see it in the script based on the above attachment.

Thanks

Thom

[preminqlik]

hi Thom,

here we go :

[tmumaw]

How did you get vcost and vprice on your table (do a table view) ctrl T

[Anonymous]

Hi!  I tried to load an inputfield on my script but how come my vfield is lost after reloading...

[tmumaw]

Here is what I did in my script and it works fine:

INPUTFIELD vPCT;

Then be sure and initialize the value in your script, something like this:

0 as vPCT,

Then on your chart use something like this;

InputSum(vPCT)

Hope this helps.