topic Re: Drop down scroll bar for input box in QlikView

Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 15:58:09 GMT

Hi Guys,

I am using predefined values in drop down for input box. Which, is used to give us a drop down for the field values. Is there a way I can scroll bar when the values exceed ten?

Expression Used:

Conact(Date, ',', Date)

Thanks in advance!

Regards,

Varun

Re: Drop down scroll bar for input box

sunny_talwar — Tue, 27 Oct 2015 16:12:21 GMT

I don't think that this is possible, but it would be good to know if I am wrong here.

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 16:47:07 GMT

Is there any other alternative?

My variable acts as a selection to the report. I want to give dates available as a drop down.

Re: Drop down scroll bar for input box

sunny_talwar — Tue, 27 Oct 2015 17:03:59 GMT

You did not like the MultiBox idea?

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 17:07:26 GMT

I am using two variables with same field. One is used as Start Date and the second one as End Date. This is passing to the report to compare the values between two time periods

Re: Drop down scroll bar for input box

sunny_talwar — Tue, 27 Oct 2015 17:09:48 GMT

May be do the same with MultiBox in two different states? I am not sure how exactly it will work, but I think it is doable. If you can provide a sample, I can test it out

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 17:12:07 GMT

I think it can work. Thanks for the idea. I will try it and will let you know.

Cheers,

Varun

Re: Drop down scroll bar for input box

sunny_talwar — Tue, 27 Oct 2015 17:13:59 GMT

Sounds good

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 17:37:25 GMT

This idea works.

Thank You Sunny!

Cheers,

Varun

Re: Drop down scroll bar for input box

sunny_talwar — Tue, 27 Oct 2015 17:39:32 GMT

Awesome, I am glad I was able to suggest something that was helpful

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 18:16:57 GMT

Sunny,Multi box is not allowing me to select always one selected value. Is it because I am using alternate states?

Re: Drop down scroll bar for input box

sunny_talwar — Tue, 27 Oct 2015 18:23:54 GMT

Try creating list boxes for the field in both states and then try selecting 'Always one selected'.

Does Multi Box object properties give you the option for Always one selected?

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 18:26:05 GMT

Yes, In Presentation tab. But if we use alternate states, it is not allowing us to select always one selected value.

Re: Drop down scroll bar for input box

sunny_talwar — Tue, 27 Oct 2015 18:28:14 GMT

Do you have one value selected before you go in to select 'Always One Selected'?

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 18:28:33 GMT

It worked. I created list box and used same state, which I used in multibox and deleted list box. Now it is working

Re: Drop down scroll bar for input box

sunny_talwar — Tue, 27 Oct 2015 18:29:28 GMT

Hahahaha that's what I was trying to tell you for your other post also.

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 18:31:02 GMT

Yes. Multibox is allowing us to select always one selected value. If we use stste it is not allowing. So, I created list box and selected always one value selected using same state as multibox and it reflected for multibox as well

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 18:31:57 GMT

Learnt many thing today

Cheers!

Re: Drop down scroll bar for input box

sunny_talwar — Tue, 27 Oct 2015 18:32:32 GMT

Awesome. Would you be able to do me a favor? Can you share a screenshot of multibox properties where you can see the option to select 'Always One Selected'?

Thanks

Re: Drop down scroll bar for input box

varunreddy — Tue, 27 Oct 2015 18:34:07 GMT

Sure. How can I attach a screen shot?