topic InputField in a pivot table in QlikView

InputField in a pivot table

Sun, 16 Oct 2011 21:34:57 GMT

I want to answer how can i put input data in the attached qvw at the expression "final order suggestion". The qvw calculate with a type the order suggestion expression and i want the user to add manualy the "final order suggestion" . I want also the final order suggestion column have the value of order suggestion. Thanks a lot.

InputField in a pivot table

swuehl — Sun, 16 Oct 2011 22:18:40 GMT

Hi,

in a pivot table chart, you need to use inputsum(FinalOrderSuggestion).

(or inputavg(FinalOrderSuggestion), depending on your needs, please check the manual for details, also about the optional distribution mode).

I think you need to rework your data model to allow to input a value for each row (if I understood you correctly). Currently, it seems that FinalOrdersuggestion has only 1 value.

Hope this helps,

Stefan

InputField in a pivot table

raghavsurya — Mon, 17 Oct 2011 10:38:47 GMT

Hi, Not sure if you can use input fields in pivot table. It can only be used in a straight table chart. Regards, Raghav