List box selection special case

[#1]

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

[Anonymous]

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

[#3]

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.

[ecolomer]

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

See the tables

[rido1421]

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"

[anbu1984]

Check this

[#7]

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

[#8]

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

[anbu1984]

Check this

[#10]

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