I have a shopping list of things I would like to see added to the Qlik product functionality. Some should be quick wins.
1. Scatter Plots - Control of shape as a dimension. The main competition do it. With the growing interest in predictive analytics and more specific cluster analysis, it would add that something extra. You can control colour and change the font. Shouldn't be too difficult to add to the functionality? I do have a workaround with multiple transparent layers with shape defined in each layer but its a pig to set up and modify.
2. Alternate States - When I first encountered 'AS' I got quite excited. I do quite a bit of Qlikview training and to be honest, set analysis is a bit of a switch off for business users. I envisaged AS could be a friendlier alternative however it doesn't go far enough. It would be great if it could be set at the Expression level. i.e. you could have two sum(sales) expressions but set a different state for each expression.
I know alternate states can be defined in an expression using set analysis sum({[State1]} Sales but it gets messy when you need to also consider non state selections and have to apply an intercept modifier $*[State1] . Watch business users eyes start to glaze over when you explain set operators...
3. Group By (in script). Not an issue for the DBA / SQL Guru but another switch off for the business user. Imaging you are loading a file with 30 odd fields and you slip in an innocuous transformation - count(ID) or even Concat which is an aggregation function. You click reload and all you get for an error message on load is "Invalid Expression". As a bear minimum, it would be nice to have something more meaningful such as "You have aggregated and non aggregated fields, you must use a group by statement for non aggregated fields".
MS Access will put the group by statement in for you. Or as has been done elsewhere in the product (e.g. not needing to specify join statements for instance) why not dispense with Group by altogether and imply it?
4. ALL. ALL is a useful modifier for aggregations. It is not the same as TOTAL and it is not the same as set modifier {1} , Despite this it is not in the help?
5. With the growing interest in infomatics, More chart types and configuration options would be great. e.g. Ability to set a square bubble for that ticker tape look.
