Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selections in Multibox

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

1 Solution

Accepted Solutions
IAMDV
Master II
Master II

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,

DV

www.QlikShare.com

View solution in original post

8 Replies
whiteline
Master II
Master II

Hi.

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

Not applicable
Author

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.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

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


IAMDV
Master II
Master II

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,

DV

www.QlikShare.com

Not applicable
Author

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


IAMDV
Master II
Master II

Hi Vidhya,

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


Thanks,

DV


www.QlikShare.com

Not applicable
Author

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