Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I want to let our salespeople view information on a particluar customer, how do I store their selection into a variable to be used in set analysis?
Thanks.
Go to top menú: "Settings" and then "Variable Overview", press on Add to create a new variable and input de expression in the Definition box.
Then you can use this variable anywhere you need it.
I do not really see that a variable would be required to solve this type of scenario. It could be expected that a user would select a cusotmer value through a document object, for example in a list box. Thereby you can use GetFieldSelections() to determine what values have been selected.
However, if your analysis is based on the current selection then there is no need to make a set analysis expression for that partion. Please elaborate exactly what your scenario is like,to allow further evaluation of the same.
Toni,
In the dashboard that I would like to create some charts I want to present specific the the user-chosen customer and others that are broader to put that customer in prespective to its peer group. I see other uses for this eventually...show the top 5 markets for that customer but show other customers as well, or maybe be able to highlight that customer in a list.
Maybe it would be better to make a dataIsland of the customer list and drive some of this off of that? Just trying to figure out the best way to go about this. Relatively new to QV.
Best,
Jimmy
To me this sounds like a typical way of using QlikView. You design your data model and load the data into QlikView, then you add you selected objects to the application. The user will select the preferred view by uing for example a listbox containing the customers.
By an active selection the current data set will be limited to match the selection, hence the object will project data related to your selection. If you on the other hand want to limit the datat set withour user selection, then you should look into Set Analysis.
If you have a practical problem in your QVW file, please post if in the community as an example of what you want to accomplish and what your current problem is. In case you just feel unsecure of how QlikView funcitons in general I would recommend that you take a look at the free online training material to get a quick start towards matering QlikView.
I guess where I was going with this was to compare a subset that the user picks with the entire set. So you are right and I just need to do set analysis picking the full set of records {1} and not the . I was thinking about this backwards within the context of QV. I got there it just took me a little while. Thanks for your push! I still think there might be some uses for this. I'll see. Best.