topic Re: Creating Input Box with values from input field in QlikView

Creating Input Box with values from input field

manpri7078 — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I want to create an input box with drop down values picking from a field list. The creation of list box is no problem but I want to create an input box for the same. The reason being I don't want to select that field because then whole Qlikview document will show objects with reference to that field.

I want to use that input box selection as a variable in some expressions independent of other objects anywhere else in the document and be restricted to that expression only.

The field is of month name and I want to select the desired month name from drop down values in an input box. The predefined values should show all possible values from that field or show only those values which are within n months back from a selected month.

Regards,

Manish Prasad

Re: Creating Input Box with values from input field

sunny_talwar — Tue, 27 Jun 2017 12:07:12 GMT

What issue are you running into when you create the input box? Is it not working? I mean you mentioned what you want and you seem to know what you want... but what is holding you back here? Can you share a sample?

Re: Creating Input Box with values from input field

manpri7078 — Tue, 27 Jun 2017 12:15:24 GMT

I am not able to create an input box. I am new to qlikview. I want to create an input box just as a list box is created from a particular field.

Regards,

Manish Prasad

Re: Creating Input Box with values from input field

Tue, 27 Jun 2017 12:24:53 GMT

please check the attachment.

place below expression in listed value on contraint tab.

=concat(distinct {<Month=>}Month,',')

Re: Creating Input Box with values from input field

sunny_talwar — Tue, 27 Jun 2017 12:25:01 GMT

Would you be able to share a sample where we can show you how it can be done?

Re: Creating Input Box with values from input field

manpri7078 — Tue, 27 Jun 2017 12:25:46 GMT

I am attaching sample document for my query.

In the attached document one list box is there for the month name. I want to create an input box independent from any selection in the list box but with values taking from list of month names. and then I want to use that input as a variable in my some expressions.

Hope I am able to clarify my query

Regards

Manish Prasad !

Re: Creating Input Box with values from input field

Tue, 27 Jun 2017 12:31:29 GMT

PFA

Re: Creating Input Box with values from input field

sunny_talwar — Tue, 27 Jun 2017 12:38:00 GMT

Check the attached

Although the Month selection is May, we are seeing the expression show Jan based on the variable vInputMonth. Also, vInputMonth has a dropdown which would make selection easier

Re: Creating Input Box with values from input field

manpri7078 — Wed, 28 Jun 2017 03:35:20 GMT

I have made a small correction in your expression and it is

=Concat({1}DISTINCT [Mon-Y], ',', Date([Mon-Y], 'MMM-YY'))

It is giving results in month values as for example 42856.

It is not showing in the format MMM-YY. Can you tell me the reason and how to implement it

Regards

Manish Prasad

Re: Creating Input Box with values from input field

sunny_talwar — Wed, 28 Jun 2017 03:39:55 GMT

Try this

=Concat({1}DISTINCT Date([Mon-Y], 'MMM-YY'), ',', Date([Mon-Y], 'MMM-YY'))

Re: Creating Input Box with values from input field

manpri7078 — Wed, 28 Jun 2017 03:57:01 GMT

Dear Sunny,

Thanks for the guidance. I had missed completely what changes was required.

Regards

Manish Prasad

Re: Creating Input Box with values from input field

sunny_talwar — Wed, 28 Jun 2017 08:41:01 GMT

This change was more important than the other one. Because second time we use MonthYear is to actually order the Concat function... So this should also work for you

=Concat({1}DISTINCT Date([Mon-Y], 'MMM-YY'), ',', [Mon-Y])