Here is where it gets interesting. In some cases the Transport field can be blank. Since I am counting the number of Rev-Trac# occurances I get a value of one in these situations when I really should have a 0 since there is no Transport. So what I would like to do is write a script that updates the the count field so that where the Transport field IsNull the count field receives a 0 and where the Transport field is not Null it counts the Rev-Trac# occurances.
On a side note, one of the things that I did try was to run another Left Join adding a "final count"field where an If statement compared the fields but when it executes this code the script fails to to memory issues. So I need a way to execute this task using as little system resources as possible.
Any help that you qlikview experts can provide this novice would be appriciated! In advance, thanks!