Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to create drop down menu for select my data SOURCE ?

Hi All

my QVW , have 20 SOURCE , May I know how to display 1 SOURCE , and when user click on the right side arrow of Box , it will list 20 SOURCE for selections.

May I know how to achieve this ?

Paul

1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

ok got you.

i think you really want to use 

1) a multibox with one field "SOURCE" and name it service

see examples

https://discuss.analyticsvidhya.com/t/qlikview-dropdown-menu/1278

http://www.qlikfix.com/2014/07/08/building-nicer-dynamic-multibox/

2) inputbox as a dropdown list

https://community.qlik.com/t5/QlikView-Creating-Analytics/Drop-Down-List/m-p/958461/highlight/true

hope that helps you finding the right solution.

regards

tim

View solution in original post

11 Replies
zhadrakas
Specialist II
Specialist II

maybe you can use the system field "$table"

sysfield.png

if you cannot see this field create an diagram object -> tab dimension -> tick show System fields

show_sysfields.png

regards

tim

zhadrakas
Specialist II
Specialist II

alternatively you can do it in script if you would like to do more advanced things:

//initial create Table
Fieldlist:
LOAD * INLINE [
    $Field name, $Table name, $Field number, $Table number, $Field|Table name, $Field|Table number
];

//Loop each table
For t = 1 to NoOfTables()

    LET vTable = TableName($(t)-1);
	//loop each field
	For f = 1 to NoOfFields('$(vTable)')
		//generate Meta Table
		Concatenate(Fieldlist)
		Load *,
		     [$Field name] & '|' & [$Table name] as [$Field|Table name],
			 [$Field number] & '|' & [$Table number] as [$Field|Table number]
		;
		Load Fieldname($(f),'$(vTable)') as [$Field name],
		     '$(vTable)' as [$Table name],
		     FieldNumber(Fieldname($(f),'$(vTable)'), '$(vTable)' ) as [$Field number],
		     num(TableNumber('$(vTable)')+1) as [$Table number] //should start with 1, so +1 
		AutoGenerate(1);
		
	next f
Next t
paulyeo11
Master
Master
Author

Hi Sir

You script is very advance. Can you pls create a QVW and send me , so that i can know is it able to solve my problem ?

( I have try to reload your script , but i cannot see understand )

Paul

paulyeo11
Master
Master
Author

Hi Sir

So by default Qlik View does not able user to create a pull down menu ?

Paul

zhadrakas
Specialist II
Specialist II

by default use the field "$table" as i mentioned in the first comment. 

The user can work with that.

 

paulyeo11
Master
Master
Author

Hi Sir

I still cannot make the $ Table for pull down menu.

Enclosed my QVW

I need to make it a pull down menu for SOURCE field.

Paul Yeo

zhadrakas
Specialist II
Specialist II

i think i dont understand what you mean by pull down.

please explain in detail what you want to achieve.

 

paulyeo11
Master
Master
Author

Hi Sir

If you look at my QVW. My SOURCE field have 5 Label. ( In actual fact I have 20 label ) I am not able to display all value label . So I need the pull down or drop down . Where user can click on the box and it will have all value label list drop down . So user can select which one for analysis.

Same like below image , when user click on SERVICES , there will be a list of items for them to select.

[Image]
paulyeo11
Master
Master
Author

Hi Sir

I think you can not view the image :- pls click on below

https://www.dropbox.com/s/ggj818s1y5jv8tl/IMG_2973.jpg?dl=0