List Down option

[#1]

How can I create list down objects with values which are not in actual data .

I want to create exact replica of this above image, is this possible in qlikview?  Values like 'None' and 'All' are not available in data source but should work as per their meaning when selected.

Thanks in advance.

[buzzy996]

definitely u can do that by defining ur own expression in list box,

but as you know qlikview is associate model..if the data(None or All) is not available in source/model by selecting those options ...hopes it won't helps to show something on charts.

other wise ,then have to define when they select either ALL or None what they want to see on chart objects!

[#3]

Because qlikbview is associtaed you have to specify what you mean by all and none and set an expresion up to handle this.

[nagaiank · Accepted solution]

If your field Type has the values Excellent, Good, Average, and Null (Blank) values, define the following table and create a list box on the field Type1.

LOAD * Inline [

Type1,Type

All,Good

All,Fair

All,Excellent

Good,Good

Fair,Fair

Excellent,Excellent

None,

];

[#5]

Thanks for the replies , Kindly help me with expression what should i use.. trying to use Valuelist unction but it is not working.

Apologies, I am pretty new to Qlikview world.

[vishsaggi]

Hi Nishith,

May be you can use Multibox with single dimension. As the experts mentioned with regards to All and None you have to define them accordingly.

V.

[#7]

Hi All,

How can i alter multi box design, like I want to show options exactly like the below image :

What I am able to get in QV is default multibox option. Kindly let me know if I can modify the default design as above.

Thanks.

[vishsaggi]

Hi Nishith,

To my knowledge NO. You cant get exactly what your picture looks using Multibox. The workaround will be see the Print screenBelow:

will this suffice your request??

Vish.

[#9]

Hi Vishal,

Thanks for your input. The image which you have shared , it can be done through multibox right. Let me know if some additional set up is required.

Also I am able to get options like 'All and None' using Load inline command. But in my requirement , like Siteactivation there are other parameters too . When I am selecting 'All' option in SIte Activation it is not allowing  me to select any other options in other parameters.I fuess some linking step is missing among these parameters.

SIte Activation is Parameter 1 , similarly there are other parameters which need to used as filters/choice. Hope I am able to put my query correctly.

Thanks.

[vishsaggi]

Hi Nishith,

Will that be possible to send me your sample qvw file you are working, so that it would be easy to comprehend the requirement.

Vish.