Discussion Board for collaboration on QlikView Scripting.
I have the following table of Orders.
Ref Type Units
Order1 Drill 10
Order2 CNC 20
Order3 Drill 15
I also have a table of Complete Production.
I have some rules.
I need to have one table as below that loads the orders, but sets the units to 0 where a valid entry for a station is found against the order.
So my final table would be
Order1 Drill 0
Order2 CNC 0
I'm trying to use an inner join, with a wildcard match but not having much joy.
Any help gratefully received.
You can load 2 Mapping tables from "Complete Product" and "Rules". The first table maps Orders to Stations, and the second table maps Types to Stations.
Then, load your transactions and compare the end results of the two maps:
IF( ApplyMap('Map1', Ref) = ApplyMap('Map2', Type), 0, Units ) as Units
www.masterssummit.com - take your QlikView skills to the next level!
Check out my book QlikView Your Business - an Expert Guide to QlikView and Qlik Sense
View solution in original post
Thanks for the ideas.