topic Re: How to create drop down menu for select my data SOURCE ? in QlikView

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

paulyeo11 — Tue, 08 Oct 2019 06:43:48 GMT

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

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

zhadrakas — Tue, 08 Oct 2019 08:13:33 GMT

maybe you can use the system field "$table"

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

regards

tim

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

zhadrakas — Tue, 08 Oct 2019 08:17:51 GMT

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

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

paulyeo11 — Tue, 08 Oct 2019 09:42:12 GMT

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

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

paulyeo11 — Tue, 08 Oct 2019 09:43:32 GMT

Hi Sir

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

Paul

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

zhadrakas — Tue, 08 Oct 2019 09:48:36 GMT

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

The user can work with that.

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

paulyeo11 — Tue, 08 Oct 2019 10:02:12 GMT

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

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

zhadrakas — Tue, 08 Oct 2019 10:26:14 GMT

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

please explain in detail what you want to achieve.

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

paulyeo11 — Tue, 08 Oct 2019 10:47:48 GMT

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]