topic Re: Ad hoc dimension List box without using Inline table in QlikView

Ad hoc dimension List box without using Inline table

Manish — Thu, 28 Oct 2021 19:28:29 GMT

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

Re: Ad hoc dimension List box without using Inline table

rwunderlich — Thu, 28 Oct 2021 19:54:02 GMT

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

Re: Ad hoc dimension List box without using Inline table

Manish — Fri, 29 Oct 2021 19:05:10 GMT

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.

Re: Ad hoc dimension List box without using Inline table

rwunderlich — Sat, 30 Oct 2021 00:00:08 GMT

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

Re: Ad hoc dimension List box without using Inline table

Manish — Sat, 30 Oct 2021 17:16:39 GMT

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

Thanks for your help.