topic Inputfield & InputSum in QlikView

Inputfield & InputSum

Tue, 12 Apr 2011 11:29:32 GMT

Hi All,

Currently I am working on InputField and InputSum.

If any one have the demo app on InputField and InputSum then pls share.

Thanks & Regards

Re: Inputfield & InputSum

Miguel_Angel_Baeyens — Tue, 12 Apr 2011 11:44:20 GMT

Hello Upendra,

Just check the documentation in regards to those subjects. The most simple way is creating the following script:

INPUTFIELD Amt;
LOAD * INLINE [
Code, Amt
A, 100
B, 200
C, 300
];

Now create a new chart, select pivot or straight table, set Code as dimension and the following as expression

InputSum(Amt)

You will see how the total changes. In short, each field declared in the load script as an inputfield needs an InputSum() aggregation function instead of a Sum() to change its value in a chart.

If you want to see all available values for Amt, create a listbox and you will see how the cursor changes when you hover the values, so you can change them.

Hope that helps.

Inputfield & InputSum

Tue, 12 Apr 2011 13:11:30 GMT

Hi Miguel,

Thanks you for the example.

How I use the InputSum with other functions or If statement? Because I am not able to edit the InputField when I use the If statement.

Is there anyway to do the same.

Thanks & Regards

Inputfield & InputSum

Miguel_Angel_Baeyens — Tue, 12 Apr 2011 13:24:16 GMT

Hello,

You can use

InputSum(If(Field > 10, Amt))

That will return 0 if the Field has not a value greater than 10. Anyway, you can always change values in the listbox of Amt.

Hope that helps.

Inputfield & InputSum

Wed, 13 Apr 2011 06:17:32 GMT

Hi Miguel,

Thanks for your valuable input.

Thanks & Regards

Inputfield & InputSum

Tue, 11 Oct 2011 06:30:46 GMT

How can the same can be done, but using LOAD from the file say XL sheet, and not INLINE?

Re: Inputfield & InputSum

Miguel_Angel_Baeyens — Tue, 11 Oct 2011 17:40:17 GMT

Hi,

It always takes the same form, as in the code above. I have reformatted it to be readable in the new forums.

INPUTFIELD FieldName;
Table:
LOAD FieldName
FROM Excel.xls;

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Inputfield & InputSum

Wed, 12 Oct 2011 04:55:12 GMT

Thanks, I did the same but not working. Strange thing is that it was working few months back, Same script not working now, particularly while loading from XL. INLINE is still working. I have already posted the query in a seperate thread. Please refer the following link:

http://community.qlik.com/thread/36665?tstart=30

It will be a great help to me if you can show some light on it. Best Regards.