Hi All
I’m new to QlikView so I’m trying to map out a source file with multiple rows into a table with specific allocation, like a pivot table through the scripts.
I tried a few ways in the LOAD using Sum and Ifs but I get an error using sum and for the total as well.
From a csv file with something like this
into something like this that can be stored into a qvd.
I’m adding a file with sample data.
Any help and guidance would be greatly appreciated.