topic Re: Re: User selectability of dimensions in QlikView

User selectability of dimensions

Thu, 15 May 2014 06:13:35 GMT

Hi all,

I want to have the following requirement in my application.

I wish to have 3 list boxes,

First list box will have all the fields , second should display only those fields that are selected in the first list box and the third should show only the values of the selections made in the second list box.

I have attached sample docs for your reference.

Kindly help me out here.

Thanks in advance,

Vidhya

Re: User selectability of dimensions

MK_QSL — Thu, 15 May 2014 06:28:49 GMT

Expression for 2nd List box

=Pick(Match(GetFieldSelections(MyFields),'Country','City','Sales','Year','HalfYear','Qtr','Month','Day'),

Country,City,Sales,Year,HalfYear,Qtr,Month,Day)

Expression for 3rd list box

=GetCurrentSelections()

Re: Re: User selectability of dimensions

Thu, 15 May 2014 06:41:44 GMT

Thanks for your response Manish.

If I give the second expression suggested by you, I get only the values of the fields, which is not my requirement.

I have attached sample appln with more details. Kindly find the same.

Thanks,

Vidhya