Ad hoc dimension List box without using Inline table

[Manish]

Hi All

I want give user the flexibility to generate the straight table by selecting the dimension names (Ad hoc report).

Is it possible to get the values of dimension name in a list box without using Inline table??

I don't want to use inline table to get the dimension names in a list box. I tried with valuelist() but no luck.

Many thanks

[rwunderlich · Accepted solution]

You can build a Listbox using ValueList. But I don't know how you would make selections or reference in your chart. 

You could "borrow" the $Field. If you just used $Field, it would list all fields. If you wanted to subset you could do this:

=Aggr(Only({<$Field={'Country', 'FullName', 'Year'}>}$Field), $Field) 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Manish]

Hi Rob 

Many thanks for your reply.

Actually , I want to have a ad hoc dimension list box without using Inline table  as it is  hampering my application performance. 

So, I was wondering by any chance is it possible to achieve the same functionality ( i.e. Users can select /add the dimension in straight table as per their wish) without using inline table to create a dimension names list box. 

[rwunderlich]

I believe I gave a solution that does not require an inline table. $Field is a builtin field, so you don't have to load anything. 

-Rob

[Manish]

Sorry Rob .. Somehow , I misread your earlier post. 

Thanks for your help.