Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ankitdayal
New Contributor

User Editable Values in Pivot table (Qlik Sense)

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!

qlik cost.PNG

2 Replies
shraddha_g
Honored Contributor III

Re: User Editable Values in Pivot table (Qlik Sense)

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

ankitdayal
New Contributor

Re: User Editable Values in Pivot table (Qlik Sense)

Thank you, Shraddha! I will try this out.