Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi.
You can' t do it out of the box and without macro.
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.
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
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
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
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
Hi Vidhya,
Please post your sample app and I'll mock up something for you.
Thanks,
DV
www.QlikShare.com
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