Filter on multiple columns - high level overview, please
Thanks to Miguel's help, I now understand the basic expression syntax better. I would appreciate some high level direction here (not code - I'm not ready for that yet!). I have a large table of 130,000+ rows by 12 columns. It helps us track sales forecasts. I need to filter on the "Country" field (could be "US", "Canada","Europe","Asia","ROW"), and on the "Date Found" field (e.g. found later than 5/6/2012), and on the SalesRep ID field (e.g. of Tom, Dick, Harry, and Charlie, want to select only (say) Tom and Charlie). My boss wants it all done in QV, not Excel. So, from a high level, do I filter "LargeTable" on all three conditions at once, or do I create temp tables (like I might have done in SQL) and apply successive filters to it? Disregarding execution time, which approach is preferred (and why)? Which is easier to maintain (is one harder than another or is there really no difference)? I'm looking more for QV philosophy here rather than code. Thanks!
The easiest way I see is to load all rows into QlikView, then use Listboxes for each of the filters: Country, Date, SalesRepID. Then create a chart (straight or pivot table likely) that shows all the dimensions (fields) and expressions (calculations) on the data you have loaded. There are plenty of working example documents in the QlikCommunity you can just download and see.
.png "Miguel_Angel_Baeyens"){kind=avatar}
