Discussion Board for collaboration on QlikView Scripting.
Hello, expert friends. On this occasion I turn to his powerful knowledge in data transformation. It is possible to obtain the following data transformation.
My initial data:
load * inline [
Periodo, Customer, Venta
The transformed data that I want to obtain:
- Rango: Calculated field. If 201701 => 201701 - 201701; if 201703 => 201701 to 201703. .....
- Total Venta: accumulated sum accumulated sum according to the rank (rango)
I hope you can help me. thank you
You can do this using an AsOf table:
The As-Of Table
View solution in original post
Excellent reference, my friend, I had to make some changes but it helped me a lot.