I'm pretty new to qlikview and I'm trying to get a hold of this software that looks awesome. The question I have is the following :
I have uploaded an excel file and created a table out of it
I took some values of this table to create a new table in order not to change anything inside the first one (I want to keep it the way it is)
I want to modify the values of the second table. For instance, I have expressions such as 100 % BRSS - 200 % TM and I want to trim the expression in order to remove the spaces inside. Then I want to separate the expression before the minus, in order to create two results put in different columns : one with 100%BRSS and one with 200%TM
I don't exactly know how and where to do this on qlikview. And how to do it for every line of the table. Could someone give me an explanation on this ?