I'm quite new to the Qlik just started to this morning and I achieved what I want quite fastly. Just a simple report show average of some values based on the country. Some pivot table shows the figures and a simple chart which is more than enough what I'm going to use them.
Anyways in my case, my row data includes some order numbers and some results if the order has success value is 1 and if not it is 0. Time to time this need to be modified after data is gathered. So simply what I need to go and find order and change results data from 0 to 1. I tried to modify data in the DATA section but it is so limited and I can't use the Replace function since it only applies on the column and changes the same value not the referenced one.
Could you show me some guidance it will be very appreciated?
