topic Re: Need help On InputField Functionality in QlikView

Need help On InputField Functionality

Sun, 27 Oct 2013 23:05:07 GMT

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

Re: Need help On InputField Functionality

jagan — Mon, 28 Oct 2013 03:49:00 GMT

Hi Swetha,

Can you attach the sample file.

Regards,

Jagan.

Re: Need help On InputField Functionality

preminqlik — Mon, 28 Oct 2013 04:18:42 GMT

hi there,

find attachment.hope this helps you ...

send me sample application ,try chesta....

Regards

Premhas

Re: Need help On InputField Functionality

tmumaw — Thu, 07 Nov 2013 15:43:27 GMT

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

Re: Re: Need help On InputField Functionality

preminqlik — Fri, 08 Nov 2013 09:09:29 GMT

hi Thom,

here we go :

Re: Need help On InputField Functionality

tmumaw — Fri, 08 Nov 2013 12:30:50 GMT

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

Re: Need help On InputField Functionality

Anonymous — Wed, 31 Aug 2016 23:15:52 GMT

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

Re: Need help On InputField Functionality

tmumaw — Thu, 01 Sep 2016 10:35:00 GMT

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.