topic List Down option in QlikView

List Down option

Thu, 21 May 2015 12:17:15 GMT

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.

Re: List Down option

buzzy996 — Thu, 21 May 2015 12:24:52 GMT

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!

Re: List Down option

Thu, 21 May 2015 12:30:41 GMT

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

Re: List Down option

nagaiank — Thu, 21 May 2015 12:40:32 GMT

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,

];

Re: List Down option

Thu, 21 May 2015 12:41:06 GMT

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.

Re: List Down option

vishsaggi — Thu, 21 May 2015 12:42:16 GMT

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.

Re: List Down option

Mon, 25 May 2015 12:00:26 GMT

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.

Re: List Down option

vishsaggi — Mon, 25 May 2015 15:09:30 GMT

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.

Re: List Down option

Tue, 26 May 2015 07:23:03 GMT

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.

Re: List Down option

vishsaggi — Tue, 26 May 2015 07:56:56 GMT

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.

Re: List Down option

Tue, 26 May 2015 08:30:00 GMT

Hi ,

Please find the attached sample qvw.

Thanks.

Re: List Down option

vishsaggi — Tue, 26 May 2015 08:41:27 GMT

Hi Nishith,

I am little confused with this statement:

when i select in parameter 1(SiteActivation) - All, I can select in other parameters from the drop down did not get you what is that missing link?

can you elaborate please what exactly the requirement is??

Vish.

Re: List Down option

Tue, 26 May 2015 08:45:42 GMT

Hi ,

Somehow the qvw is not working fine , when I am selecting 'All' in parameter 1 and 'Good' in parameter3 . It should grey out the country 'New Zealand' as per the source data because parameter 3 does not have 'good' value for New zealand.

Hope this helps.

Regards,

Nishith

Re: List Down option

vishsaggi — Tue, 26 May 2015 09:06:30 GMT

Hi Nishith,

We have circular references in the table viewer which you have to look into cos of this you will get inconsistent data. One more thing is I can see in the first script for country Newzealand you have GOOD for parameter3 so if you select All for paremeter 1 and Good for paremeter3 the country Newzealand is not greyed out it has Good value in the script, can you look into it and correct me if i am wrong. Can you ping me on gtalk if possible mine is vishsaggi@gmail.com will go through it properly.

Vish.

Re: List Down option

vishsaggi — Tue, 26 May 2015 09:38:37 GMT

Check if this helps. Removed circular reference. Let me know.

Vish.

Re: List Down option

Tue, 26 May 2015 10:06:45 GMT

I have sent an invitation

Re: List Down option

vishsaggi — Tue, 26 May 2015 10:42:12 GMT

Got it. Ping me when you free. And also did you get my qvw file please look into it and let me know.

Vish.