topic Re: Display field values in dropdown( Pls see the image) in QlikView

Display field values in dropdown( Pls see the image)

Tue, 19 Jul 2011 07:37:59 GMT

Hi,

How can i implement same design as seen in below image.

1.) Reporting Mode: "THIS IS DONE BY USING THE TEXT OBJECT "

2.) For displaying the TimeRange in Dropdown , How it can be done ? (Whether i need to go with INPUT BOX or STRAIGHT TABLE or any other object)

Pls can anyone suggest on this.

Regards

Venkat

Display field values in dropdown( Pls see the image)

vikasmahajan — Tue, 19 Jul 2011 08:29:02 GMT

Use straight table

Write Click ,

Select Presentation ,

Select Dropdown tick option

Hope this clear your doubts

Re: Display field values in dropdown( Pls see the image)

Tue, 19 Jul 2011 08:40:41 GMT

Hi,

You can look at the attached file if that what you want

Re: Display field values in dropdown( Pls see the image)

Tue, 19 Jul 2011 08:45:29 GMT

Hi mona

Thanks for reply,

I can't open your file bcoz not having full version Qlikview in my system.

Pls send the steps what you had implemented.

Regards

Venkat

Re: Display field values in dropdown( Pls see the image)

Tue, 19 Jul 2011 08:53:35 GMT

Hi VikasMahajan

Thanks for reply,

I tried it but it is look like below image. But i required exactly what i shown in my first post.

Regards

Venkat

Re: Display field values in dropdown( Pls see the image)

Tue, 19 Jul 2011 09:06:48 GMT

OK ,

1-Put an input box and assign any variable you want to it

2-in the label part remove the variable name in order not to be visible

All the above in the general tab

3-in the constraints tab in Input constraints check on (predefined values only) , in the value list check on (predefined values in drop-down) and in the predefined values check on (listed values) and enter in front of it your values of the drop down list like that(TimeRange;value2;value3;.....)

Hope it's helpful

Re: Display field values in dropdown( Pls see the image)

Tue, 19 Jul 2011 09:17:43 GMT

Hi Mona,

I tried what you said , but in the last step i am providing the field (TimeSelectionRange). But it is always shows only one values in dropdown.

TimeSelectionRange(field) and below is its values

[TimeRange

DateRange]

Pls check this.

Regards

Venkat

Re: Display field values in dropdown( Pls see the image)

Tue, 19 Jul 2011 09:28:15 GMT

Hi,

If you can please attach your qvw file so i can try in it

Thanks

Re: Display field values in dropdown( Pls see the image)

Tue, 19 Jul 2011 09:43:37 GMT

Hi Mona,

Pls see the attached file.

Regards

Venkat

Re: Display field values in dropdown( Pls see the image)

Tue, 19 Jul 2011 09:53:59 GMT

Hi,

just put this

=Concat( TimeRangeSelections,',')

instead of direct field name in order to be treated as a list

and it will work

Best Regards,