topic List box selection special case in QlikView

List box selection special case

Wed, 17 Sep 2014 11:17:06 GMT

Hello,

There is a listbox with 'Breakage Reasons'.

When a 'Breakage reason' is selected, I would like to see the data filtered with the selected 'Breakage'

and also the data without breakage, that is breakage reason is empty or '-'.

Please suggest how can i acheive it.

PFA the sample qvw file

Thanks,

Deepa V

Re: List box selection special case

Anonymous — Wed, 17 Sep 2014 22:09:04 GMT

It may be for two reasons.

the first, the fields have no information.

second, they have more than one value '-'

I saw your dashboard and say that is the first reason.

regards

Re: Re: List box selection special case

Thu, 18 Sep 2014 05:34:08 GMT

Erik Mendieta wrote:

Hi

:

It may be for two reasons.

the first, the fields have no information.

second, they have more than one value '-'

I saw your dashboard and say that is the first reason.

regards

Hello Erik,

Thanks for the reply.

I will not get the breakage code '-' in Breakage reasons.

So I loaded by concatinating '-' in Breakage Reasons list box.

But, I have the below challenges:

1 .when I select '-' in list box, data is not filtering.

2. I need to see the data with breakage reason '-' + selected 'breakage reason' in result.

Pls find attahced the revised qvw.

Please help me.

Re: Re: Re: List box selection special case

ecolomer — Thu, 18 Sep 2014 05:44:55 GMT

In my opinion you have a problem in the script and the data are non good relationship

See the tables

Re: List box selection special case

rido1421 — Thu, 18 Sep 2014 05:47:40 GMT

Hi Deepa

what if you Joined the "LMTB_BREAKAGE_REASON_EOLT " Table to the "LMTB_Product_EOLT"

using entity Code ? instead of Joining on the "BREAKAGE REASON"

Re: Re: Re: List box selection special case

anbu1984 — Thu, 18 Sep 2014 06:02:25 GMT

Check this

Re: Re: Re: Re: List box selection special case

Thu, 18 Sep 2014 06:05:59 GMT

Hello Enrique Colomer,

Thanks for the reply,

I am loading data from the attached excel.

Please suggest, is there any issue with datamodel or while loading other tables .

Thanks,

Deepa V

Re: Re: Re: Re: List box selection special case

Thu, 18 Sep 2014 06:18:44 GMT

Hello Anbu cheliyan,

Yes, in the document, when ever any breakage code is selected in the table I am seeing '-' as selected.

But now I am seeing 2 values with '-', on clear selection.

whenever I select any breakage code EX: 'HC_FALL'

I am seeing as below:

count should be 1000 for breakageCode '-'

Please help me.

Thanks,

Deepa V

Re: Re: Re: Re: Re: List box selection special case

anbu1984 — Thu, 18 Sep 2014 06:57:39 GMT

Check this

Re: Re: Re: Re: List box selection special case

Thu, 18 Sep 2014 07:34:55 GMT

Hi Anbu Chelian,

Thanks a lot for this, It is ok now.

I am trying to get something like below:

BREAKAGE_REASON	othercnt	If(nullcount<>0,nullcount,othercnt)	Percentage Rejected
	1009
HC_FALL	1009	2	2/1009	0.19 %
SG_BK	1009	1	1/1009	0.10%
SG_ENG	1009	1	1/1009	0.10%
SG_PR	1009	3	3/1009	0.29%
SG_PWR	1009	1	1/1009	0.10%
SG_WXS	1009	1	1/1009	0.10%
-	1009	9	9/1009	0.89%

Kindly help me with this

Thanks,

Deepa V

Re: Re: Re: Re: Re: List box selection special case

anbu1984 — Thu, 18 Sep 2014 08:19:45 GMT

Check this

Re: Re: Re: Re: List box selection special case

Thu, 18 Sep 2014 08:28:35 GMT

Thanks a lot Anbu Chelian..

It helped me a lot....