topic Selection in field problem in QlikView

Selection in field problem

Tue, 31 Jan 2012 09:21:41 GMT

Hello,

Here i'm attaching my application along with description of problem. Can anyone help me on this.

Selection in field problem

hic — Wed, 01 Feb 2012 10:35:08 GMT

Not sure it can be done… Your selection depends very much on the sort order of the list box and this is not the same as the sort order of the data. I would build the sort order into the search string, e.g. ='<='&Min(LensKey,$(vNoOfLenskey))

and see how far I get with this approach.

Re: Selection in field problem

Miguel_Angel_Baeyens — Wed, 01 Feb 2012 11:19:39 GMT

Hi Jacq,

I'd use something like the following (using different lines because I have not tested it). What the following does is take the string from the result of concatenating all possible values from field LensKey sorted numeric ascending (as in your listbox) to the nth time (value in vNoOfLenskey).

='(' & Left(
     Concat(DISTINCT LensKey, '|', LensKey)
     , Index(
          Concat(DISTINCT LensKey, '|', LensKey)
          , '|', $(vNoOfLenskey)) -1
     )
& ')'

Hope that helps.

Miguel

Selection in field problem

Thu, 02 Feb 2012 12:03:41 GMT

Thanks a lot Miguel.