Once I load all my data and view them in my tables. If I want to see all items that for example cost more than a $100 how do I do that. It is easy enough to see all items that cost exactly $100 - just need to click the field that has that value and it will then only display items of that value.
I am only using SQL to load the data from the server based Notes database. Is there are way to use SQL statements on these subsequest Qlikview table with all the flexibility the language provides or is there another way that I have not figured out yet.
In a listbox with Cost, type ">100" without the quotes.
You can use the same expression in a chart column. However, you have to enable searching for the column on the chart's Presentation tab. For expressions. the property is "Dropdown Select". For Expressions, the property is "Searchable".
Read up on "search" in the Help for more info.
Qlikview uses it's own language, AQL, to manipulate tables once the data is loaded into Qlikview. AQL is directed at the needs of Qlikview, and it is very powerful and flexible for Qlikview use. It is however, different than SQL, and some some study and training is required.
