topic Re: Re: Selections in Multibox in QlikView

Selections in Multibox

Fri, 07 Mar 2014 05:15:52 GMT

Hi all,

I am having many dimensions in my multibox, so my multibox looks really big.

So, I wish to have a list box in a separate sheet ,wherein if i select the fields in the list box, only those fields should be displayed

in multibox, rather than displaying all the fields.

I want to have this in my application without using macros. Is this possible?

Kindly help me out for this.

Thanks in advance,

Vidhya

Re: Selections in Multibox

whiteline — Fri, 07 Mar 2014 09:43:48 GMT

Hi.

You can' t do it out of the box and without macro.

Re: Selections in Multibox

Fri, 07 Mar 2014 11:18:17 GMT

Hi Vidhya,

I think if you were to define exactly how many fields you wanted to bring through to your multibox you could do this.

I would create a list box using the $Field field, then I would create a variable using the GetFieldSelections function. Then I would create variables for each field I want to bring through to the multibox so if you want to show 10 fields set up 10 variables, use the substring function to get each selected item from the $Field list box into a separate variable. Then in your multibox click on the expression button and add your variables (i.e. $(vtest1) etc...)

Bit of a long way around it but I think it would work.

Re: Selections in Multibox

stevedark — Fri, 07 Mar 2014 11:24:24 GMT

As whiteline says you can't do this exactly as you describe.

You may want to take a look at the Data Profiler app that I uploaded as this could provide you a basis for building something similar to what you describe:

QlikView App - Generic Data Profiler

There is a blog post that accompanies the app that describes how it is built.

Steve

Re: Selections in Multibox

Fri, 07 Mar 2014 11:44:24 GMT

Thanks for your response Grace.

But the problem is I am not sure about the number of fields that I am going to add to multibox.

The number is not fixed.

Thanks,

Vidhya

Re: Re: Selections in Multibox

IAMDV — Fri, 07 Mar 2014 13:04:04 GMT

Hi Vidhya,

As mentioned by Steve Dark and whiteline there is no straight forward way to do it. However, you can use FirstSortedValue function along with the Dollar Sign Expansion to dynamically create filters in the MultiBox based on the ListBox selection. I'm attaching the sample for your reference and you can build based on this approach. This is completely scalable once setup and you don't have to use a Macro (I'm sure...that brings a smile on your face!).

Also, I'd recommend watching two video tutorials on how FirstSortedValue() function works. I've made these video tutorials on my blog. Here is the link (Copy & Paste the URL):

http://qlikshare.com/tag/firstsortedvalue

I hope this helps!

Good luck!

Cheers,

www.QlikShare.com

Re: Selections in Multibox

Wed, 12 Mar 2014 11:28:47 GMT

Thanks Deepak for your response.Your application is very helpful for my reference.

I am facing the following issue while implementing the concept in real time data.

Consider I have a field 'Year' with values 2012, 2013 and 2014,

Month with 'Jan','Feb' and 'Mar'.

how should I include it in the following script?

'Field_01_Value_' & RowNo() AS Field_01,

I tried many ways, but i am not coming out with the correct solution

Kindly can you help me on this?

Thanks in advance

Vidhya

Re: Re: Selections in Multibox

IAMDV — Wed, 12 Mar 2014 13:37:15 GMT

Hi Vidhya,

Please post your sample app and I'll mock up something for you.

Thanks,

www.QlikShare.com

Re: Re: Re: Selections in Multibox

Fri, 14 Mar 2014 06:03:14 GMT

Hi Deepak,

Thanks for your response.

Is there any way to hide "=" which is displayed in the multibox, when selections are made in the list box?

Sample application is attached for you reference.

Thanks and Regards,

Vidhya