User Editable Values in Pivot table (Qlik Sense)

[Anonymous]

Hi Everyone,

I am new to Qlik Sense and would really appreciate if you could help me with my query. So, I have created this pivot table that has a column named "Average Unit Price". Is there any way I could enter numerical values manually in this column for each row item? I know I can assign a single value for the entire column but I want to enter a different value for each row.

Thank you!

[shraddha_g]

You will have to set different value for each value in Dimension using If or Pick.

It is only feasible if you have limited number of Values for Dimension.

For Ex.

Pick(Wildmatch(Dimension1, 'Value1','Value2',..,'Value10'),

'Price1','Price2'..'Price10')

For More number of records you can maintain a Excel and link it with data

[Anonymous]

Thank you, Shraddha! I will try this out.