Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sabreyals
New Contributor III

Input values into a Pivot/straight table

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.

2 Replies
MVP & Luminary
MVP & Luminary

Re: Input values into a Pivot/straight table

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

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

Best,

Sunny