Newest #Qlikview toy, Margin Analysis

So I recently created this little APP for accounting. It basically pulls in the costing information, last sales information, and lets you play with the margins. What happens if costs go up 2% and we increase prices by 3% and they take their 2% discount. And what if volume goes down a little on one item? That sort of thing


It also implemented this awesome post

So they copy and paste Products from excel into a input box and then go and select those!  This select in field string is the magic

=’(‘ & Replace(Replace(Replace(Trim(‘$(vProductList)’), ‘  ‘, ‘|’),’ ‘, ‘|’), chr(10), ‘|’) & ‘)