topic Input values into a Pivot/straight table in QlikView

Input values into a Pivot/straight table

sabreyals — Thu, 22 Jan 2015 02:20:42 GMT

Hi All,

I have seen a few examples where inputing values into a pivot table is possible. However this has been done using inline tables.

Is it possible to create a pivot table with dimensions coming from table A, measures from fact B and have a col. where users can manually enter values to affect measure B within the chart?

Please let me know.

Thanks.

Re: Input values into a Pivot/straight table

jagan — Thu, 22 Jan 2015 03:05:17 GMT

Hi,

Please find attached file for solution, in the pivot table you can change the price of a product in pivot table by clicking on the price cell in the table, so that the Total value is changed automatically changed based on the keyed in value.

This is achieved by using the InputField option and InputSum().

Hope this helps you.

Regards,

Jagan.

Re: Input values into a Pivot/straight table

sunny_talwar — Tue, 12 May 2015 17:09:54 GMT

This is awsome jagan mohan‌, I had no idea we could do this.

Best,

Sunny