topic Re: How to create drop down list from a Date field in QlikView

How to create drop down list from a Date field

Wed, 02 Jul 2014 03:56:47 GMT

Hi,

I have a date field that i want to use in a drop down list (Please refer the image below). The date field has multiple values, hence i cannot specify hard coded values in any of the drop down object field. Can you please help me in creating the drop down list object?

Since I'm using the free version of QV, please provide detailed steps to achieve this. Thanks in advance.

Re: How to create drop down list from a Date field

SunilChauhan — Wed, 02 Jul 2014 04:00:37 GMT

use matibox

Re: How to create drop down list from a Date field

Anonymous — Wed, 02 Jul 2014 04:19:10 GMT

Do use multibox

or use a table and check on dropdown list.

check them. Left mutlibox,right a table box.

HTH

Ravi N.

Re: How to create drop down list from a Date field

Wed, 02 Jul 2014 04:19:21 GMT

Hi Sunil,

I tried multibox but it doesn't give me the output as per the image. Or probably I'm missing something.

Re: How to create drop down list from a Date field

Wed, 02 Jul 2014 04:19:27 GMT

Say In the list box, click on the field, scroll down to the bottom, choose Expression and type =Date(<your date>,'MMM-YYYY')

Re: How to create drop down list from a Date field

Wed, 02 Jul 2014 04:57:06 GMT

I can use Table Box but how do i format the date field in there - Date(<your date>, 'MMM-YYYY')

Re: How to create drop down list from a Date field

sasikanth — Wed, 02 Jul 2014 05:09:11 GMT

HI Mohita

use table box and for making your date in to that format

Do that one at your script levele it self

some thing like

Load

date(<date-field>m'MMM-YYY') as Mydate,

from....

.......................................

may be helpful

Re: How to create drop down list from a Date field

PradeepReddy — Wed, 02 Jul 2014 05:18:57 GMT

We can achieve this in 2 ways

1) at script Level

Create a field "Month(Date)&'-'&Year(Date) as MonthKey ".

use the MonthKey field in List Box.

2) at sheet level

Create a list box, with the expression.... Month(Date)&'-'&Year(Date)

Regards,

Pradeep

Re: How to create drop down list from a Date field

avinashelite — Wed, 02 Jul 2014 09:01:25 GMT

Hi Monita,

If u want the exact representation go for the Calender Object and in the Data field select expression and use the Date(fieldname,'MMM-YYYY') function . This will give u the similar representation.

Regards,

@vi

Re: How to create drop down list from a Date field

Thu, 03 Jul 2014 03:18:50 GMT

Thanks, Sasikanth. This helped.

Re: How to create drop down list from a Date field

sasikanth — Thu, 03 Jul 2014 05:53:32 GMT

U r welcome