topic Re: Regarding Scroll Bar in QlikView

Regarding Scroll Bar

Wed, 28 Nov 2012 15:10:16 GMT

Hi All,

In my list boxes I have selected the option "Hide Excluded" under the General Tab.

So whenever a selection is made the unassociated data becomes completely invisible and those

portion get greyed out.

Since under my "Sort" Tab i have selected Sort by "State" - Auto Ascending, thus all associated data is sorted and rearranged

in ascending order upon a selection being made in the list boxes.

I am interested to know if it is possible to eliminate the Scroll Bar while the list boxes are displaying the Associated Data only.

MayilVahanan — Wed, 28 Nov 2012 17:05:24 GMT

PFA

Hope it helps

Regards,

R.Mayil Vahanan

Wed, 28 Nov 2012 18:01:47 GMT

Hi Ramaswamy,

I saw your example, its working fine.

Can you help me in understanding how you made it

MayilVahanan — Wed, 28 Nov 2012 18:09:48 GMT

Use Aggr() function

Ex:

Aggr(Month,Month) as expression in list box.. when you scroll down the drpdown box, you can see expression option

Hope it helps