topic store variable from a selection in QlikView

store variable from a selection

Fri, 13 May 2011 17:54:23 GMT

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.

store variable from a selection

Fri, 13 May 2011 18:35:45 GMT

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.

store variable from a selection

ToniKautto — Fri, 13 May 2011 19:57:25 GMT

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.

store variable from a selection

Fri, 13 May 2011 20:49:23 GMT

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

store variable from a selection

ToniKautto — Mon, 16 May 2011 08:55:07 GMT

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.

http://www.qlik.com/us/services/training

store variable from a selection

Mon, 16 May 2011 23:05:31 GMT

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.