topic Re: Select Possible From Chart in QlikView

Select Possible From Chart

bhelms — Thu, 05 Dec 2013 20:28:08 GMT

I have a chart that has a field called KEY. when the users make a few selections, this field within the chart gets limited down to a few records. I want to be able to automatically select those records. I can't use SelectPossible however, since the entire field KEY isn't limited down. Only the field within the chart is limited because of the way the chart was designed. I am hoping there is a way to write a macro, to do the following

1) Look at all possible values for KEY within the chart CH123

2) Select those values

Re: Select Possible From Chart

Thu, 05 Dec 2013 21:21:11 GMT

I don't think so you need a macro. I believe, you are using calculated dimension to limit the KEY field values in the script.

1. Get the all the possible values for KEY and pass into variable

2.. Apply the filter to remove the unwanted data from variable [calculated dimension filter]

3. Select the KEY field

Please post sample qvw ...

Re: Select Possible From Chart

angelaecheverri — Fri, 06 Dec 2013 03:11:37 GMT

Is better do not use a Key Field as a Dimmension or into a Expression.

You should work with fields which are not used like Key.