I've been asked to convert a tool from Excel into QlikView and have a concern about one of the pieces of functionality.
The tool allows a user to paste in a list of SKUs and matching Quantities, and the tool outputs what the total costs, profits, data would be matching those inputs. In the past, I've built dashboards that allow me to paste in a list of SKUs or other values and been fine, but I'm concerned about trying to input multiple values at a time (especially if one is quantity which probably only be used in a calculation and wouldn't be in the data. Is there a clean way to do this in QV? Maybe a way to build an array or matrix off of a data input?
Hi Andy, if Quantity (or one of the fields) is not likely to be in the data model at all, yet you need to use the new values to do some calculations etc... then you are probably looking at giving the user the ability to augment the data model to bring in that extra data rather than try to capture an unknown number list of values using an unknown number of variables.
I don't know of a great way to provision each user to integrate new data fields into the app in a QlikView web deployment but i suppose it fairly easy for a set of desktop users. What is the deployment going to look like ?
That being said, what i have mentioned is pretty easy in the new product Qlik Sense where you can drag and drop a list of values stored in a file (say CSV or XLS) right into the app and have it augment the data model on the fly. There are still some additional issues to think through but it could be a new start.
Sorry i don't have anything better for you in QlikView.
Thanks for the follow up and sending over the example. I see in the application a space to create a single input, but am still confused as how to input a matrix of information with two fields at a time (see example above).
What are you thoughts - did I miss something in the example you sent? I appreciate your help.
Andy - your explanation is excellent and intentions are clear. You are trying to create a user filtered display of Product IDs . You are also trying to add a new field (quantity) and use this to create a new calculated field using existing fields in the data model. This feels like a 'what if' scenario where you are trying to give users the ability explore pricing scenarios of selling certain quantities of certain products. The users need to add the quantities for selected products. Makes sense to me.
Trying to do this with Input Boxes is a little challenging. I don't know of a really great way to do it that would be seemless for a user. I don't know of an existing extension that would help, although that method is (web developer skills) is always there.
Another way is to give users the ability to JOIN in a new table that contains Product IDs and Quantities. The chart in the app would Product IDs from the file that the users join in (call it File Product IDs) and would display Quantities. The chart would only render once the data model has been augmented with the new file.
This is probably easier to do in Qlik Sense because in Sense users can litteraly drag and drop a CSV or XLS file into the application , select 'add data', and hit load. The file would have to have the right field names that are expected , but the app could provide text to guide the user. They can't really do that in QlikView so the solution isn't as seemless so i would only recommend using Sense for this option. Sense doesn't have all the same features as QlikView and does require 64 bit OS (at least for desktop).